 |
ocilogon (PHP 3 >= 3.0.4, PHP 4, PHP 5) ocilogon -- `E·'Ac`O>>,"ou 1/2 Oracle u"A'Anot 1/2 'O ~Aè^E"oresource ocilogon ( string username, string password [, string db] )
ocilogon() ·u>>O`O>>,"oOCI u÷'O~ADè`Oau"A'Anot 1/2 'O±ê"O 3/4 ·^u!lb
?'E~N!u"Au'U3,"o^2^I^E'yonot'OD"A~a"I"e`Oa'Anot 1/2 'Ou"A^E'y 3/4 'Y?^au"A~A^u×"Olbnot,~A~A^u×"O^Ia± 3/4 uO Oracle
^Eu'ADu"A~A^u×"O>>ò~Oss^O'U tnsnames.ora u"A`I~o"A?"ODu"A~A^u×"O!lb
`Ec^1^uu'U3,"o^2^I^E'y~A>>'ODP¨`Oalbnot PHP ^E^1'O~A>>· 3/4 ^3±"a'A? ORACLE_SID (Oracle ^Eu'AD)
>>ò TWO_TASK (tnsnames.ora) `A'`E·P¨'Anot 1/2 'O"A"A`O>>,"o^E'y 3/4 'Y?^a!lb
u±^E^1'O~A ocilogon() u"A^E±oòlbnot
'Anot 1/2 'O^O'U`O^3"E(R)AE 1/2 'E"I±>>^1^2"Ií!lb
~O^a`O^a^IP×A`Iá 1/2 >>o'I>>O^1"o'O|'O~Au 1/2 ,~A`O^3"Eù'OD?a·Au"A^E^A^I~nlbnot'E~o"O'A^O'U"A~a`O~N 3/4 -'' 1/2 ¨
Pà,"o'Anot 1/2 'Ou"ACé?"o"I^A!lb
~O^a,"o`A'y×'O~N'Y^E 3/4 'Anot 1/2 'O^EC^O~o~Nù±>>^1^2"Iíu"A!lb
例子 1. ocilogon()
<?php
echo "<pre>";
$db = "";
$c1 = ocilogon("scott", "tiger", $db);
$c2 = ocilogon("scott", "tiger", $db);
function create_table($conn)
{
$stmt = ociparse($conn, "create table scott.hallo (test varchar2(64))");
ociexecute($stmt);
echo $conn . " created table\n\n";
}
function drop_table($conn)
{
$stmt = ociparse($conn, "drop table scott.hallo");
ociexecute($stmt);
echo $conn . " dropped table\n\n";
}
function insert_data($conn)
{
$stmt = ociparse($conn, "insert into scott.hallo
values('$conn' || ' ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'))");
ociexecute($stmt, OCI_DEFAULT);
echo $conn . " inserted hallo\n\n";
}
function delete_data($conn)
{
$stmt = ociparse($conn, "delete from scott.hallo");
ociexecute($stmt, OCI_DEFAULT);
echo $conn . " deleted hallo\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.hallo");
ociexecute($stmt, OCI_DEFAULT);
echo $conn."----selecting\n\n";
while (ocifetch($stmt)) {
echo $conn . " [" . ociresult($stmt, "TEST") . "]\n\n";
}
echo $conn . "----done\n\n";
}
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);
echo "</pre>";
?>
|
|
^2^I 1/4 ^u ociplogon() o'I
ocinlogon()!lb
| |