01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & Oracle Tutorial</title>
04.</head>
05.<body>
06.<?
07.$objConnect = oci_connect("myuser","mypassword","TCDB");
08.$strSQL = "SELECT * FROM CUSTOMER";
09.$objParse = oci_parse($objConnect, $strSQL);
10.oci_execute ($objParse,OCI_DEFAULT);
11.?>
12.<table width="600" border="1">
13.<tr>
14.<th width="91"> <div align="center">CustomerID </div></th>
15.<th width="98"> <div align="center">Name </div></th>
16.<th width="198"> <div align="center">Email </div></th>
17.<th width="97"> <div align="center">CountryCode </div></th>
18.<th width="59"> <div align="center">Budget </div></th>
19.<th width="71"> <div align="center">Used </div></th>
20.</tr>
21.<?
22.while($objResult = oci_fetch_array($objParse,OCI_BOTH))
23.{
24.?>
25.<tr>
26.<td><div align="center"><?=$objResult["CUSTOMERID"];?></div></td>
27.<td><?=$objResult["NAME"];?></td>
28.<td><?=$objResult["EMAIL"];?></td>
29.<td><div align="center"><?=$objResult["COUNTRYCODE"];?></div></td>
30.<td align="right"><?=$objResult["BUDGET"];?></td>
31.<td align="right"><?=$objResult["USED"];?></td>
32.</tr>
33.<?
34.}
35.?>
36.</table>
37.<?
38.oci_close($objConnect);
39.?>
40.</body>
41.</html>
Quote:
