Below is a simple PHP script to demonstrate how to connect to a MS SQL database using an ODBC DSN. You can find the SQL DSN information in the SQL Manager section in the control panel.
For more information on ODBC with PHP, please review the followings
- PHP Builder tutorial - http://www.phpbuilder.com/columns/jayesh20021029.php3
- PHP Documentation on ODBC connections - http://www.php.net/manual/en/ref.odbc.php
<html>
<head><title>PHP SQL TEST</title></head>
<body>
<h2>MS SQL / DSN Test</h2>
<table border="1">
<?php
$DSN="SQLDSN_sqlConn";
$DSN_User="sqlusername";
$DSN_Passwd="sqlpassword";
$QueryString="SELECT id, FirstName, LastName, Email FROM tblContact";
$Connect = odbc_connect( $DSN, $DSN_User, $DSN_Passwd );
$Result = odbc_exec( $Connect, $QueryString );
echo "\t" . "<tr>\n";
echo "\t\t" . "<td>id</td><td>FirstName</td><td>LastName></td><td>Email</td>" . "\n";
while( odbc_fetch_row( $Result ) )
{
$id = odbc_result($Result,"id");
$FirstName = odbc_result($Result,"FirstName");
$LastName = odbc_result($Result,"LastName");
$Email = odbc_result($Result,"Email");
echo "\t" . "<tr>\n";
echo "\t\t" . "<td>" . $id . "</td><td>" . $FirstName . "</td><td>" . $LastName . "</td><td>" . $Email . "</td>\n";
echo "\t" . "</tr>\n";
}
odbc_free_result( $Result );
odbc_close( $Connect );
?>
</table>
