RE: [PHP] Oracle and PHP
| From: | Dunaway, Brian | Date: | Tue, 26 Jun 2001 14:25:12 +0000 |
| Subject: | RE: [PHP] Oracle and PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-55245@lists.php.net to get a copy of this message | ||
>I'm a newbie in PHP, what should I do to connect to Oracle Database.
>Do I have to install a library to do that?
>Please anyone, help.
http://www.phpbuilder.com/manual/ref.oracle.php
I usually do something similiar to this.
(psuedo code follows):
// Define Oracle_Home and Oracle_Sid
putenv("ORACLE_HOME=/opt/ORACLE/product");
putenv("ORACLE_SID=MYDATA");
// Connect To Oracle Server/Else Return Error(s)
if($connection = ora_logon(my-login,my-pass))
{
// Open Cursor
$cursor = ora_open($connection);
$query = "SELECT * FROM table ";
$query .= "ORDER BY date1";
// Parse Cursor
ora_parse($cursor, $query);
if ( ora_exec($cursor) )
{
$data = array();
$field = array();
while(ora_fetch_into($cursor, &$field))
{
reset ($field);
$data[ $field[0] ] = $field[1];
}
}
else
{
print("** While Attempting To Open Cursor On Query
** <br><br>\n\n");
print("Oracle Returned The Following Error:
<br>\n");
print(ora_error($cursor));
print("<br><br>\n\n");
print("Oracle Error Code: ");
print(ora_errorcode($cursor));
}
// Close Cursor
Ora_Close($cursor);
}
else
{
print("** While Attempting To Open Connection ** <br><br>\n\n");
print("Oracle Returned The Following Error: <br>\n");
print(ora_error($connection));
print("<br><br>\n\n");
print("Oracle Error Code: ");
print(ora_errorcode($connection));
}
// Disconnect
Ora_Logoff($connection);