Below is a simple PHP script to demonstrate how to connect to a MS SQL database using the php MS SQL driver.
Sample code:
| <?php |
| $serverName = "SQL Server"; |
| $uid = "sqlusername"; |
| $pwd = "sqlpassword"; |
| $databaseName = "DBName"; |
| |
| $connectionInfo = array( "UID"=>$uid, |
| "PWD"=>$pwd, |
| "Database"=>$databaseName); |
| |
| /* Connect using SQL Server Authentication. */ |
| $conn = sqlsrv_connect( $serverName, $connectionInfo); |
| |
| $tsql = "SELECT id, FirstName, LastName, Email FROM tblContact"; |
| |
| /* Execute the query. */ |
| |
| $stmt = sqlsrv_query( $conn, $tsql); |
| |
| if ( $stmt ) |
| { |
| echo "Statement executed.<br>\n"; |
| } |
| else |
| { |
| echo "Error in statement execution.\n"; |
| die( print_r( sqlsrv_errors(), true)); |
| } |
| |
| /* Iterate through the result set printing a row of data upon each iteration.*/ |
| |
| while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_NUMERIC)) |
| { |
| echo "Col1: ".$row[0]."\n"; |
| echo "Col2: ".$row[1]."\n"; |
| echo "Col3: ".$row[2]."<br>\n"; |
| echo "-----------------<br>\n"; |
| } |
| |
| /* Free statement and connection resources. */ |
| sqlsrv_free_stmt( $stmt); |
| sqlsrv_close( $conn); |
| ?> |
| |
| |
|
Article ID: 183, Created: August 6, 2012 at 11:37 PM, Modified: August 6, 2012 at 11:37 PM