ociconnect php,PHP oci_new_connect 用法 手册 | 示例代码

";$db="";$c1=oci_connect("scott","tiger",$db);$c2=oci_new_connect("scott","tiger",$db);

functioncreate_table($conn)

{$stmt=oci_parse($conn,"create table scott.hallo (test

varchar2(64))");oci_execute($stmt);

echo$conn." created tablenn";

}

functiondrop_table($conn)

{$stmt=oci_parse($conn,"drop table scott.hallo");oci_execute($stmt);

echo$conn." dropped tablenn";

}

functioninsert_data($conn)

{$stmt=oci_parse($conn,"insert into scott.hallo

values('$conn'   ' '   to_char(sysdate,'DD-MON-YY HH24:MI:SS'))");oci_execute($stmt,OCI_DEFAULT);

echo$conn." inserted hallonn";

}

functiondelete_data($conn)

{$stmt=oci_parse($conn,"delete from scott.hallo");oci_execute($stmt,OCI_DEFAULT);

echo$conn." deleted hallonn";

}

functioncommit($conn)

{oci_commit($conn);

echo$conn." committednn";

}

functionrollback($conn)

{oci_rollback($conn);

echo$conn." rollbacknn";

}

functionselect_data($conn)

{$stmt=oci_parse($conn,"select * from scott.hallo");oci_execute($stmt,OCI_DEFAULT);

echo$conn."----selectingnn";

while (oci_fetch($stmt)) {

echo$conn." nn";

}

echo$conn."----donenn";

}create_table($c1);insert_data($c1);select_data($c1);select_data($c2);rollback($c1);select_data($c1);select_data($c2);insert_data($c2);commit($c2);select_data($c1);delete_data($c1);select_data($c1);select_data($c2);commit($c1);select_data($c1);select_data($c2);drop_table($c1);

echo"