PHP sqlsrv查询数据库
我从MySQL迁移到MS SQL Server,并尝试从例程中获取所有数据。我已经连接过了,但我不确定如何使用它sqlsrv获取数据。我走了多远?$conn_array = array"UID" => "sa", "PWD" => "root", "Database" => "nih_bw",);$conn = sqlsrv_connect('BILAL',$conn_array);if ($conn){ echo "connected"; $result = sqlsrv_query($db->db_conn,"SELECT * FROM routines");}else{ die(print_r(sqlsrv_errors(),true));}sqlsrv_close($conn);?>
解决方案:
首先,如果我没记错的话,我会的sqlsrv_connect结果存储 ,$conn而且结果不是类obj因此,请删除其资源$db->conn
这个例子将连接起来,然后获得返回的资源 sqlsrv_query
$conn_array = array"UID" => "sa", "PWD" => "root", "Database" => "nih_bw",);$conn = sqlsrv_connect('BILAL',$conn_array);if ($conn){ echo "connected"; if(($result = sqlsrv_query($conn,"SELECT * FROM routines")) !== false){ while( $obj = sqlsrv_fetch_object( $result )) { echo $obj->colName.'
else{ die(print_r(sqlsrv_errors(),true));}
页:
[1]