<?php
$test_conn = ocilogon( "scott", "Manas6");
$cmdstr = "select ename, sal, job from emp";
$parsed = ociparse($test_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
echo "<html><head><title>Oracle PHP Test</title></head><body>";
echo "<center><h2>Oracle PHP Test: XP-Home/Apache-2.0/Oracle 10.g
2.0</h2><br>";
echo "<table border=1 cellspacing='0' width='400'>\n<tr>\n";
echo "<td><b>Name</b></td>\n<td><b>Salary</b></td>\n<td><b>JOB</b></td>\n</tr>\n";
for ($i = 0; $i < $nrows; $i++ )
{
echo "<tr>\n";
echo "<td width='100'>" . $results["ENAME"][$i]
. "</td>";
echo "<td width='150'bgcolor='#99CCFF'>$ " . number_format($results["SAL"][$i],
2). "</td>";
echo "<td bgcolor='#000080' width='100'> <font color='#FFFF00'>" . $results["JOB"][$i]
. "</font></td>";
echo "</tr>\n";
}
echo "<tr><td colspan='3'> Number of Rows: $nrows</td></tr></table>";
echo "<br><em>This is a simple query that retrieves ename, sal and job
from a table emp!</em><br></center></body></html>\n";
?>
|
