PHP+Oracle+HELP!!!!

[ronaldo9]

hi,
i'm a fourth year student.
i have the following

PHP 4,
Oracle 8i Personal Edition,
Windows 2000,

for the love of god has anyone implemented PHP with Apache and Oracle on a Windows machine,i've seen the php manuali was hoping you could give me some help on installing
PHP to run with Oracle and vica versa, and how to
connect to Oracle,

any help is appreciated

HELP!!!!!!
richard howlin

[pinoy]

I have implemented Oracle 8i Personal Edition + APache+PHP4 on windows platform.

Edit the your php.ini under windows/system uncomment (😉the ;extension=php_oci8.dll. under window extensions section

Edit the extension_dir section, point it where your php extensions modules are.
mine is C:\php\php4\extensions

restart your apache.

Hope this might help

[ronaldo9]

thanks got it working,have another problem though,,,

i just want to display the contents of a Oracle table,i know how to query the database using OCIParse and OCIEXecute but how do i actually display the results,,,echo?tried it and doesnt work should OCIExecute display the records...

thanks

[pinoy]

try to use my code.

$db = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOST)(PORT = 1521))
(CONNECT_DATA = (SID = SIDNAME)))";
$conn = ocilogon("login","password",$db);

$sql ="select * from TABLENAME";
$stmt = OCIParse($conn, $sql);
OCIexecute($stmt);

while(OCIFetchInto($stmt, $row, OCI_ASSOC))
{
echo $row['columname']; /columname on your DATABASE TABLE /
}