PHP sqlsrv query to database

Question

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);
?>

Saic Siquot · Accepted Answer · 2016-03-16 19:54:43Z

15

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));
}

edited Mar 16, 2016 at 19:54

Saic Siquot

6,5135 gold badges37 silver badges56 bronze badges

answered Jul 2, 2014 at 17:16

Quijote Shin

5014 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mureinik · Accepted Answer · 2014-04-17 11:21:20Z

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 />";
}

edited Apr 17, 2014 at 11:21

answered Apr 17, 2014 at 11:13

Mureinik

316k54 gold badges399 silver badges405 bronze badges

2 Comments

user3185936 Over a year ago

I get this error: dropbox.com/s/lod1s8olf1iwog3/errors.png, its in the $result line it errors.

alpakyol Over a year ago

@user3185936 Why are you using $db->db_conn? You set connection to $conn with sqlsrv_connect() so use it: $result = sqlsrv_query($conn, "SELECT * FROM routines");

Greg Motyl · Accepted Answer · 2014-04-17 11:14:23Z

0

Try this:

while( $row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC) ) {
  var_dump($row);
}

sqlsrv_free_stmt($result);

answered Apr 17, 2014 at 11:14

Greg Motyl

2,56519 silver badges31 bronze badges

1 Comment

Thom Over a year ago

When you answer with code, please provide a brief explanation along with the code.

user3645814 · Accepted Answer · 2021-02-12 19:43:42Z

0

$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));
}

that work great for me, but please any one can help me to display the result on a table ?

I mean this parts :

while( $obj = sqlsrv_fetch_object( $result )) {
              echo $obj->colName.'<br />';
        }

answered Feb 12, 2021 at 19:43

user3645814

215 bronze badges

1 Comment

phoenixstudio Over a year ago

This 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

Collectives™ on Stack Overflow

PHP sqlsrv query to database

4 Answers 4

Comments

2 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related