php连mysql的代码:
<?php $db_server = "localhost";
$db_login = "admin";
$db_password = "password";
$db_name = "testtime";
$con = mysql_connect($db_server, $db_login, $db_password);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db_name, $con);
?>
试问,在同样的情况下连接oracle怎么写?注:oracle为远程服务器,本机通过pl/sql操作。
<?php $db_server = "localhost";
$db_login = "admin";
$db_password = "password";
$db_name = "testtime";
$con = mysql_connect($db_server, $db_login, $db_password);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db_name, $con);
?>
试问,在同样的情况下连接oracle怎么写?注:oracle为远程服务器,本机通过pl/sql操作。
VALUES (:mykey, EMPTY_CLOB())
RETURNING myclob INTO :myclob";$stid = oci_parse($conn, $sql);
$clob = oci_new_descriptor($conn, OCI_D_LOB);
oci_bind_by_name($stid, ":mykey", $mykey, 5);
oci_bind_by_name($stid, ":myclob", $clob, -1, OCI_B_CLOB);
oci_execute($stid, OCI_DEFAULT);
$clob->save("A very long string");oci_commit($conn);
手册上的,仅供参考
$db_server = "localhost";
$db_login = "admin";
$db_password = "password";
$db_name = "testtime"; // $db_name应该是oracle的instance名(可能和MySQL有点区别)。
$con = oci_connect($db_login, $db_password, $db_name);
?>