PHP sqlsrv query to database
52,726
Solution 1
First if I'm not wrong you are storing sqlsrv_connect
result into $conn
and this result isn't a class obj its a resource, so remove $db->conn
This example, will connect, then fetch if there are resources returned from 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.'<br />';
}
}
}else{
die(print_r(sqlsrv_errors(), true));
}
Solution 2
After you've successfully executed the query with sqlsrv_query
you can fetch the results, e.g., by using sqlsrv_fetch_array
:
$result = sqlsrv_query($db->db_conn, "SELECT * FROM routines");
if($result === false) {
die( print_r( sqlsrv_errors(), true) );
}
while( $row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC) ) {
echo $row['column1'].", ".$row['column2']."<br />";
}
Comments
-
user3185936 almost 2 years
I am migrated from MySQL to MS SQL Server, and trying to fetch all data from the routines table. I am connected but unsure how to fetch data with sqlsrv. This is how far I have came:
$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); ?>
-
user3185936 about 10 yearsI get this error: dropbox.com/s/lod1s8olf1iwog3/errors.png, its in the $result line it errors.
-
Thom about 10 yearsWhen you answer with code, please provide a brief explanation along with the code.
-
alpakyol about 10 years@user3185936 Why are you using
$db->db_conn
? You set connection to$conn
withsqlsrv_connect()
so use it:$result = sqlsrv_query($conn, "SELECT * FROM routines");
-
phoenixstudio about 3 yearsThis does not provide an answer to the question. You can search for similar questions, or refer to the related and linked questions on the right-hand side of the page to find an answer. If you have a related but different question, ask a new question, and include a link to this one to help provide context. See: Ask questions, get answers, no distractions