Ask a Question related to PHP Development, Design and Development.
-
Orlando Pozo #1
Oracle8i PEAR Connection problem
Hello, mailing-list people, I need help about connect
the RDBMS Oracle8i through PEAR library, look this code
<html><head><title>Test DB Class - PEAR</title></head>
<body>
<table border=1>
<tr><th>NAME</th><th>PHONE</th><th>ADDRESS</th></tr>
<?php
//connect
require_once('DB.php');
$db
=DB::connect("oci8://system:manager@localhost/orcl");
// message
if (DB::iserror($db)) {
die($db->getMessage());
}
//issue the query
$sql ="SELECT *
FROM S_CUSTOMER";
$q =$db->query($sql);
// message
if (DB::iserror($q)) {
die($q->getMessage());
}
//generate table
while ($q->fetchInto($row)) {
?>
<tr><td><?= $row[0] ?></td>
<td><?= $row[1] ?></td>
<td><?= $row[2] ?></td>
</tr>
<?php
}
?>
</table>
</body></html>
When I execute this code, I receive this output:
DB Error: extension not found
NAME PHONE ADDRESS
I think that is a problem with the DSN in the
connection (oci8://system:manager@localhost/orcl)
I put oci8 for the db type, user: system, pass: manager,
and db: orcl
I could connect oracle8i with PHP, but using ODBC methods,
I want now connect oracle8i through the PEAR library.
If someone know, please give me a hand, thanks.
Orlando Pozo Guest
-
Problem to start ORACLE8i Management Server
I was trying to connect from Enterprise manager but its says you must select managment server. i was trying with default username / password but... -
#39733 [NEW]: PEAR installation errors due to wrong go-pear.phar file
From: jonathan dot martens at gmx dot net Operating system: Win XP SP 2 PHP version: 5.2.0 PHP Bug Type: Unknown/Other... -
Oracle 8i problem connection with pear
Hello, mailing-list people, I need help about connect the RDBMS Oracle8i through PEAR library, look this code <html><head><title>Test DB Class -... -
#24870 [Fbk->NoF]: Pear segfaults on install-pear-installer (db_open symbol conflicts?)
ID: 24870 Updated by: sniper@php.net Reported By: jbyrne at thegrid dot net -Status: Feedback +Status: ... -
#24870 [Opn->Fbk]: Pear segfaults on install-pear-installer (db_open symbol conflicts?)
ID: 24870 Updated by: sniper@php.net Reported By: jbyrne at thegrid dot net -Status: Open +Status: ...



Reply With Quote

