php与oracle连接

[littlebirds]

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操作。

[littlebirds]

$db_name应该是oracle的instance名(可能和MySQL有点区别)

请问这是个什么意思？

[CunningBoy]

[Quote=引用 3 楼 lazygc520 的回复:]
$db_name应该是oracle的instance名(可能和MySQL有点区别)

请问这是个什么意思？
[/Quote]
Oracle中，database和Instance是两个概念，客户端连接查询数据库都是和Instance交互的，具体你要看Oracle相关的文档。

[程序猿之殇]

$conn = oci_connect('scott', 'tiger', 'orcl');

$mykey = 12343;  // arbitrary key for this example;

$sql = "INSERT INTO mytable (mykey, myclob)
        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);

手册上的,仅供参考

[CunningBoy]

<?php
$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); 
?>