Using PHP to connect to SQL Server 2005

Question

Hi I am using a PHP script to connect to SQL Server 2005. After much tinkering around I can finally establish a connection. However when I try and query the database I am getting no response. I have tested my SQL Query on the database and it runs fine. Any help greatly appreciated. Thanks

<?php
/

$serverName = "*******";
$usr="******";
$pwd="****";
$db="*****";



//Connection to Database
$connectionInfo = array("UID" => $usr, "PWD" => $pwd, "Database" => $db);

$conn = sqlsrv_connect($serverName, $connectionInfo);
if( $conn )
{
     echo "Connection to database established.\n";

}
else
{
     echo "Connection could not be established.\n";
     die( print_r( sqlsrv_errors(), true));
}

//-----------------------------------------------
// Perform operations with connection.
//-----------------------------------------------

$sql = "SELECT ContactName FROM dbo.TBL_JOB WHERE EngineerID = 1 ";


/* Close the connection. */
sqlsrv_close( $conn);
?>

Where is the query code, I can only see a string $sql ?

xdazz
– xdazz

2012-01-26 10:18:17 +00:00
Commented Jan 26, 2012 at 10:18 — xdazz
– xdazz, Commented Jan 26, 2012 at 10:18

xdazz · Accepted Answer · 2012-01-26 10:36:54Z

2

Add the code below after $sql = "SELECT ContactName FROM dbo.TBL_JOB WHERE EngineerID = 1 ";:

$stmt = sqlsrv_query($conn, $sql );
if ($stmt === false) {
     die(print_r(sqlsrv_errors(), true));
}

while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
      echo $row['ContactName']. "<br />";
}

sqlsrv_free_stmt($stmt);

edited Jan 26, 2012 at 10:36

answered Jan 26, 2012 at 10:20

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

Collectives™ on Stack Overflow

Using PHP to connect to SQL Server 2005

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related