Oracle 8i - PEAR - Problem
| From: | orlandopozo at icnet dot com dot ve | Date: | Wed, 01 Oct 2003 15:43:41 +0000 |
| Subject: | Oracle 8i - PEAR - Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-164564@lists.php.net to get a copy of this message | ||
Hello, I have been trouble about to connect Oracle 8i through PEAR db class, I think it is the
connection argument, any suggestion could help me, thanks in advanced, here you are the code:
<html><head><title>Test DB Class - PEAR</title></head>
<body>
<table border=1>
<tr><th>Id</th><th>Name</th></tr>
<?php
//connect
require_once('DB.php');
$db =DB::connect("oci8://system:manager@localhost/orcl");
if (DB::iserror($db)) {
die($db->getMessage());
}
//issue the query
$sql ="SELECT *
FROM test ORDER BY id ASC";
$q =$db->query($sql);
if (DB::iserror($q)) {
die($q->getMessage());
}
//generate table
while ($q->fetchInto($row)) {
?>
<tr><td><?= $row[0] ?></td>
<td><?= $row[1] ?></td>
</tr>
<?php
}
?>
</table>
</body></html>