DRAFT
PHP ODBC Simple Select
Quick Notes
PHP Sample Code
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP ODBC Test</title>
</head>
<body>
<?php
echo "PHP Omnidex OBDC Simple Select";
$conn=odbc_connect('OdxSystemTest','',''); // had to use system datasource
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM table1";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>MYSEQ</th>";
echo "<th>MYTEXT</th></tr>";
while (odbc_fetch_row($rs))
{
$myseq=odbc_result($rs,"MYSEQ");
$mytext=odbc_result($rs,"MYTEXT");
echo "<tr><td>$myseq</td>";
echo "<td>$mytext</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>
</body>
</html>