Hello,
New to the list and have a PHP-sized headache.
I'm attempting to connect to an Oracle DB and, being totally new to PHP, was
looking for a pre-built script. What I have been finding doesn't seem to
want to run. I keep getting ORA-03121 - no interface driver connected.
Below is the snippit I've been playing with:
<?php
// load enviornment variables
putenv("ORACLE_SID=PROD");
putenv("ORACLE_HOME=C:\ORAWIN95");
// create connection
$conn = Ora_Logon("uid", "password")
or die("Couldn't logon.");
// create SQL statement
$sql = "SELECT CUSTOMER_ORDER_TAB.CUSTOMER_NO,
CUSTOMER_ORDER_TAB.CUSTOMER_PO_NO, CUSTOMER_ORDER_TAB.DATE_ENTERED,
CUSTOMER_ORDER_TAB.ORDER_NO, CUSTOMER_ORDER_TAB.WANTED_DELIVERY_DATE
FROM IFSAPP.CUSTOMER_ORDER_TAB CUSTOMER_ORDER_TAB
WHERE (CUSTOMER_ORDER_TAB.DATE_ENTERED=SYSDATE)";
// parse SQL statement
$sql_statement = Ora_Parse($connection,$sql)
or die("Couldn't parse statement.");
// execute SQL query
Ora_Execute($sql_statement)
or die("Couldn't execute statement.");
// get number of columns for use later
$num_columns = Ora_NumCols($sql_statement);
// start results formatting
echo "<TABLE BORDER=1>";
echo "<TR>
<TH>Customer Number</TH>
<TH>PO</TH>
<TH>Date</TH>
<TH>Oder Number</TH>
<TH>Wanted Delivery</TH>
</TR>
";
// format results by row
while (Ora_Fetch($sql_statement)) {
echo "<TR>";
for ($i = 0; $i < $num_columns; $i++) {
$column_value = Ora_Result($sql_statement,$i);
echo "<TD>$column_value</TD>";
}
echo "</TR>";
}
echo "</TABLE>";
// free resources and close connection
Ora_FreeStatement($sql_statement);
Ora_Logoff($connection);
?>
TIA for any assistance,
Jeff Lutes
I.S. Support Specialist
MOUS Word/Excel Expert
Hopkins Mfg. Corp.
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
