01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & Oracle Tutorial</title>
04.</head>
05.<body>
06.<?php
07.include("phpOracleFunctionClassDatabase.php");
08.
09.
10.$strTns = "TCDB";
11.$strUser = "myuser";
12.$strPassword = "mypassword";
13.$clsMyDB = new MyDatabase($strUser,$strPassword,$strTns);
14.
15.
16.
17.
18.$clsMyDB->strTable = "customer";
19.$clsMyDB->strField = "CUSTOMERID,NAME,EMAIL,COUNTRYCODE,BUDGET,USED";
20.$clsMyDB->strValue = " 'C005','Weerachai Nukitram','webmaster@thaicreate.com','TH','2000000','0' ";
21.$objInsert = $clsMyDB->fncInsertRecord();
22.if(!$objInsert)
23.{
24. echo "Record already exist.<br>";
25.}
26.else
27.{
28. echo "Record inserted.<br>";
29.}
30.
31.echo "<br>===========================<br>";
32.
33.
34.
35.
36.$clsMyDB->strTable = "customer";
37.$clsMyDB->strCondition = " CUSTOMERID = 'C005' ";
38.$objSelect = $clsMyDB->fncSelectRecord();
39.if(!$objSelect)
40.{
41. echo "Record not found<br>";
42.}
43.else
44.{
45. echo "Customer Detail.<br>";
46. echo "CUSTOMERID = $objSelect[CUSTOMERID]<br>";
47. echo "NAME = $objSelect[NAME]<br>";
48. echo "EMAIL = $objSelect[EMAIL]<br>";
49. echo "COUNTRYCODE = $objSelect[COUNTRYCODE]<br>";
50. echo "BUDGET = $objSelect[BUDGET]<br>";
51. echo "USED = $objSelect[USED]<br>";
52.}
53.
54.echo "<br>===========================<br>";
55.
56.
57.
58.
59.$strTable = "customer";
60.$strCommand = " BUDGET = '4000000' ";
61.$strCondition = " CUSTOMERID = 'C005' ";
62.$objUpdate = $clsMyDB->fncUpdateRecord($strTable,$strCommand,$strCondition);
63.if(!$objUpdate)
64.{
65. echo "Error update record.<br>";
66.}
67.else
68.{
69. echo "Record updated.<br>";
70.}
71.
72.echo "<br>===========================<br>";
73.
74.
75.
76.
77.$clsMyDB->strTable = "customer";
78.$clsMyDB->strCondition = " CUSTOMERID = 'C005' ";
79.$objDelete = $clsMyDB->fncDeleteRecord();
80.if(!$objDelete)
81.{
82. echo "Record not delete.<br>";
83.}
84.else
85.{
86. echo "Record deleted.<br>";
87.}
88.?>
89.</body>
90.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
