PHP 连接 oracle 数据库并查询

[rmtjp]

“host”=> "web",
"user" => "www",
"passwd" => "2014"
配置如上，求一个php脚本，连接并进行管理.
非程序员，不懂PHp，万分感谢~

[Sunyanzi]

需求說的不清不楚的 ... 不懂 php 至少要看下吧 ...

我猜 ... 這個大概能幫到你 http://php.net/oci_connect ...

[rmtjp]

@Sunyanzi 嗯，之前有看，环境的话是osx连局域网内的另外一台机器
这个需要有‘SID’我从服务器上没有看到这个...

[raincious]

@rmtjp 装好那个之后，试试看 http://www.php.net/manual/en/ref.pdo-oci.php 不过貌似是实验性的。

http://blog.csdn.net/heiyeshuwu/article/details/400268

[smblog]

没 SID 就这样配置

$hostname = 'localhost';
$username = 'user';
$password = 'pass';
$database = 'db';

$datastr = "(description=(address=(protocol=tcp)
(host=".$hostname.")(port=1521))
(connect_data=(service_name=".$database.")))";

if(!$link = oci_connect($username,$password,$datastr)) {
die('Can not connect to Oracle server');
}

$sql = "select * from uset_tabs";
$result = oci_parse($link,$sql);
oci_execute($result);
$res = oci_fetch_array($result, OCI_ASSOC);
print_r($res);

[zencoding]

@rmtjp 最佳解决方案 https://github.com/catfan/Medoo 不谢

[zhanglp888]

<?php
$c = oci_connect('用户名', '密码', '地址/sid','UTF8');
if (!$c) {
$m = oci_error();
trigger_error('Could not connect to database: '. $m['message'], E_USER_ERROR);
}
$s = oci_parse($c, "SELECT * FROM employees");
if (!$s) {
$m = oci_error($c);
trigger_error('Could not parse statement: '. $m['message'], E_USER_ERROR);
}
$r = oci_execute($s);
if (!$r) {
$m = oci_error($s);
trigger_error('Could not execute statement: '. $m['message'], E_USER_ERROR);
}
$r = oci_fetch_all($s, $res);
if (!$r) {
$m = oci_error($s);
trigger_error('Could not fetch rows: '. $m['message'], E_USER_ERROR);
}
echo "<table border='1'>\n";
foreach ($res as $row) {
echo "<tr>\n";
foreach ($row as $item) {
echo " <td>".($item!==null?htmlentities($item, ENT_QUOTES):"&nbsp;")."</td>\n";
}
echo "</tr>\n";
}
echo "</table>\n";
?>