Saturday, November 7, 2015

PHP Connectivity with MS SQL Server (mssql) commands

<?php
$myServer = "server name";
$myUser = "user name";
$myPass = "password";
$myDB = "database name"; 

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer")

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB"); 

//declare the SQL statement that will query the database
$query = "SELECT * from table-name";


//execute the SQL query and return records
$result = mssql_query($query);

$numRows = mssql_num_rows($result); 
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>"; 

//display the results 
echo "<li>" . $row["ItemId"] . $row["ItemName"] . $row["SupplierId"] . "</li>";

}

//close the connection
mssql_close($dbhandle);
?>

No comments:

Post a Comment