<html> |
<body> |
<?php |
$conn =odbc_connect( 'northwind' , '' , '' ); |
if (! $conn ) |
{ exit ( "Connection Failed: " . $conn );} |
$sql = "SELECT * FROM customers" ; |
$rs =odbc_exec( $conn , $sql ); |
if (! $rs ) |
{ exit ( "Error in SQL" );} |
echo "<table><tr>" ; |
echo "<th>Companyname</th>" ; |
echo "<th>Contactname</th></tr>" ; |
while (odbc_fetch_row( $rs )) |
{ |
$compname =odbc_result( $rs , "CompanyName" ); |
$conname =odbc_result( $rs , "ContactName" ); |
echo "<tr><td>$compname</td>" ; |
echo "<td>$conname</td></tr>" ; |
} |
odbc_close( $conn ); |
echo "</table>" ; |
?> |
</body> |
</html> |