Oracle - PHP connection problem

[Anon]

I need some help please.

I got following code in my PHP:

---

<?
$conn=ora_logon("Daniel","daniel");
if ($conn){

ora_parse($query,"SELECT NAME,ADDRESS,PHONE FROM AGENDA");
ora_exec($query);
echo "<table>";
echo "<tr><th>Name</th><th>Address</th><th>Phone</th></tr>";
while (ora_fetch($query)){
echo "<tr>";
echo "<td>";
echo ora_getcolumn($query,1);
echo "</td>";
echo "<td>";
echo ora_getcolumn($query,2);
echo "</td>";
echo "<td>";
echo ora_getcolumn($query,3);
echo "</td>";
echo "</tr>";
} // while

echo "</table>";
ora_Logoff($conn);
}
else
echo "Connection fails";
?>

---

When I try to run my PHP file an error appears:

Fatal error: Call to undefined function: ora_logon() in D:\Projects\PHP\ConsultasOra.php on line 8

Do I need to install a special support for Oracle?
Do I need to get a Oracle's function library?

If my questions are true, Where can I find that libraries?

Thanks a lot

Daniel Baylon
Infolink Applications
[e-mail]

[Anon]

What was your compile flags when you did php? You can use the phpinfo() function to find out what your compile options were. Also, the use of this function will show what support you have. If it does not show support for Oracle, then that could be the problem. If you used --with-oci8, then you need to use the oci functions, not the ora_ functions.

[Anon]

Yo need to recompile php. If you are using it in Linux/Unix try with this:

./configure --with-oci8={$ORACLE_HOME} --with-oracle= {$ORACLE_HOME} ... and the other options you used.

Remember to use the
putenv() function to export the $ORACLE_HOME var before use the ora_logon() function.

Good look

[Anon]

Hi,

recompile your php with following command
./configure --with-oracle=$ORACLE_HOME --with-apache=/...pathof apache/ --enable-track-vars --enable-sigchild

to use ora_* functions

./configure --with-OCI = $ORACLE_HOME --with-apache=/...pathof apache/ --enable-track-vars --enable-sigchild

to use OCI* functions.

then make and make install.

IF you have to apply some library patches to your oracle installation , it must be done before you recompile PHP;

Check whether ora or OCI is enabled using
the code <? echo phpinfo(); ?> code in a file.

Hope it works
Ranjith

[Anon]

hi

I am getting exactly the same problem

I am using the --with-oci8 configuration option,
but I am unable to use the oci functions in my script.

can you please tell me where in phpinfo() should i look
for to know if oci is enabled.

thanks a lot in advance

-rehan

[Anon]

Hi,
hope you have applied the library patches availble with the oracle 8i CD.

did you setup the db name in tnsnames.ora?? it is at
$ORACLE_HOME/network/admin/tnsnames.ora file

If your php configuration is OCI enabled,
in phpinfo() you can see a table .. oci 8
saying.. oci8 support enabled

also make sure that you have set
$ORACLE_HOME, $ORACLE_SID variables ( this will also be listed somewhere below with title Environment.)

If every thing is there the problem is probably with your Oracle installation

Ranjith

[Anon]

What do I have to do to have the Oracle 8 support within PHP4 and Apache 1.3.12 ???

I do not have any DLL for PHP/Oracle and I don't know how to install it with Windows...

Thank you for helping me.

hervé

[Anon]

hello
i have some problem about oracle connection
please give me all source for connection
thanks

[Anon]

hi:

Try with this code

putenv( ORACLE_HOME="your $ORACLE_HOME");
$conn = ocilogon("user","pwd","sid");

$stmt = ociparse($conn, "SELECT NAME FROM ...");
ociexecute($stmt);