# Sampel code for make connection with Oracle Database and send simple DDL,DML and query commands from oci8 extension.
# Database instance: fuju
# host name : fuju.exzilla.net
# lintener port number : 1521
# user : scott
# Password : tiger
# You can connect to database server from this program without setting tnsnames.ora.
# fuju at exizilla dot net, Jan10,2002
# Modifid from original of " http://www.php.net/manual/en/function.ocilogon.php "
function delete_data($conn)
{ $stmt = ociparse($conn,"delete from scott.hellotable");
ociexecute($stmt,OCI_DEFAULT);
echo $conn." deleted hellotable\n\n";
}
function commit($conn)
{ ocicommit($conn);
echo $conn." committed\n\n";
}
function rollback($conn)
{ ocirollback($conn);
echo $conn." rollback\n\n";
}
function select_data($conn)
{ $stmt = ociparse($conn,"select * from scott.hellotable");
ociexecute($stmt,OCI_DEFAULT);
echo $conn."----selecting\n\n";
while (ocifetch($stmt))
echo $conn." <".ociresult($stmt,"TEST").">\n\n";
echo $conn."----done\n\n";
}
# start Main program
echo "<h3> Start :: Simple oci8 extension functions test </h3><p><hr><p>";
create_table($c1);
insert_data($c1); // Insert a row using c1
insert_data($c2); // Insert a row using c2
select_data($c1); // Results of both inserts are returned
select_data($c2);
rollback($c1); // Rollback using c1
select_data($c1); // Both inserts have been rolled back
select_data($c2);
insert_data($c2); // Insert a row using c2
commit($c2); // commit using c2
select_data($c1); // result of c2 insert is returned
delete_data($c1); // delete all rows in table using c1
select_data($c1); // no rows returned
select_data($c2); // no rows returned
commit($c1); // commit using c1
select_data($c1); // no rows returned
select_data($c2); // no rows returned
drop_table($c1);
print "</PRE></HTML>";
echo "<hr><h3> End :: Simple oci8 extension functions test </h3>";
?>
Date :
5 พ.ย. 2551 14:22:36
By :
Fd,bomiN
No. 5
Guest
ถ้า php ยังไม่รองรับ Oci ไห้ stop service Apache แล้วเปิดไฟล์ php.ini แล้วแก้บรรทัดนี้ extension=php_oci8.dll โดยเอาเครื่องหมาย ; ที่อยู่ข้างหน้าออกแล้ว start service ถ้ายังไม่ได้ไห้เปลี่ยน version ของ AppServ เพราะบาง Version ผมลองแล้วมันก็ยังไม่รัน Oci ไห้
Load balance : Server 04
