<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:[EMAIL PROTECTED]/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:[EMAIL PROTECTED]/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.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
