Page 1 of 1

PHP/ Oracle

Posted: Wed Nov 10, 2004 2:45 pm
by Kingo
Hello,
How do I display the rows from the oracle databse.?
I know it for MYSQL

Code: Select all

$result = MYSQL_QUERY(" SELECT * from data WHERE UserName='$username' and PassWord='$password' ")
   or die ("Name and password not found or not matched");

$worked = mysql_fetch_array($result);

if($worked)
{

$S_Name 	=  $worked["School_Name"]; 
$P_Name 	=  $worked["Principal_Name"]; 
}
I want to implement the same thingh using the Oracle Database . Any help is really appreciated.

Posted: Wed Nov 10, 2004 2:46 pm
by Weirdan
[php_man]oracle[/php_man]

Posted: Wed Nov 10, 2004 2:56 pm
by Kingo
I'm not able to convert the above statements into the Oracle one. AS there are amny functions. Would appreciate if you could convert the above statemenst to the one with Oracle as back end