01.<?session_start();?>
02.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
03.<HTML>
04. <HEAD>
05. <TITLE> New Document </TITLE>
06. <META NAME="Generator" CONTENT="EditPlus">
07. <META NAME="Author" CONTENT="">
08. <META NAME="Keywords" CONTENT="">
09. <META NAME="Description" CONTENT="" charset="windows-874">
10. </HEAD>
11.
12. <BODY>
13. <?
14.$id = $_POST['id'];
15.echo"$id";
16.$objConnect = oci_connect('tplus','tplus','135.9.200.1/ths');
17.$strSQL = "select * from gb_location where loc_id='$id'";
18.$objParse = oci_parse ($objConnect, $strSQL);
19.oci_execute ($objParse,OCI_DEFAULT);
20.?>
21.<table width="600" border="1">
22. <tr>
23. <th width="91"> <div align="center">CustomerID </div></th>
24. <th width="98"> <div align="center">Name </div></th>
25. <th width="198"> <div align="center">Email </div></th>
26. <th width="97"> <div align="center">CountryCode </div></th>
27. <th width="59"> <div align="center">Budget </div></th>
28. <th width="71"> <div align="center">Used </div></th>
29. </tr>
30.<?
31.while($objResult = oci_fetch_array($objParse,OCI_BOTH))
32.{
33.?>
34. <tr>
35. <td><div align="center"><?=$objResult["0"];?></div></td>
36. <td><?=$objResult["1"];?></td>
37. <td><?=$objResult["2"];?></td>
38. <td><div align="center"><?=$objResult["3"];?></div></td>
39. <td align="right"><?=$objResult["4"];?></td>
40. <td align="right"><?=$objResult["5"];?></td>
41. </tr>
42.<?
43.}
44.?>
45.</table>
46.<?
47.oci_close($objConnect);
48.?>
49.</BODY>
50.</HTML>
