Error using Oracle OCILogon() function

[burkeja]

I am trying to connect to a remote Oracle database (biw.world in my TNSNAMES.ORA file) and get the following error:

Fatal error: Call to undefined function: ocilogon() in D:\Inetpub\wwwroot\oracle_test.php on line 10

PHP 4.2.3 and Oracle 8i Client is installed on the server.

Does a library have to be included in the file for this function to work?

Any help appreciated as this is a first attempt to connect to Oracle with PHP. I can connect to the Oracle database with ColdFusion.

Thanks.

[wilsonodk]

Could we see some of the code please?

[burkeja]

Here's the code for the OCILogon error I mentioned:

<?

$conn = OCILogon("login","password","biw.world");

function select_data($conn)
{
$stmt = OCIParse($conn,"SELECT activity.ship_hull, config.psdn, config.hsc, ref_cff.efd, config.ric, config.serial_number, config.rin, ref_ric_nom.ric_nomenclature
FROM ref_ric_nom, ref_cff, config, activity
WHERE (activity.uic = config.uic) and
(config.cff_sa_id = ref_cff.cff_sa_id (+)) and
(config.ric = ref_ric_nom.ric (+)) and
( (activity.uic = 'R21955') or
(activity.uic = 'R22999') or
(activity.uic = 'R22992') or
(activity.uic = 'R22993') or
(activity.uic = 'R22994') or
(activity.uic = 'R22995') or
(activity.uic = 'R22996') or
(activity.uic = 'R22997') or
(activity.uic = 'R23155') or
(activity.uic = 'R23145') or
(activity.uic = 'R23160') or
(activity.uic = 'R23146') or
(activity.uic = 'R23147') or
(activity.uic = 'R23148') or
(activity.uic = 'R23153') or
(activity.uic = 'R23154') ) and
( (config.psdn = '210199') ) and
( (config.rin like '0%') ) and
(( (config.action_cd <> 'D') or
(config.action_cd IS NULL ))) and
(( (config.del_flag_cd <> 'T') or
(config.del_flag_cd IS NULL ))) and
(nvl(config.ric_history_id, 0) = ref_ric_nom.ric_history_id (+))");
OCIExecute($stmt,OCI_DEFAULT);
echo $conn."----selecting\n\n";
while (OCIFetch($stmt))
echo $conn." <".OCIResult($stmt,"ship_hull").">\n\n";
echo $conn." <".OCIResult($stmt,"psdn").">\n\n";
echo $conn."----done\n\n";
}
?>

[wilsonodk]

Here is one problem fixed...

  while (OCIFetch($stmt)) 
  {
    echo $conn." <".OCIResult($stmt,"ship_hull").">\n\n";
    echo $conn." <".OCIResult($stmt,"psdn").">\n\n";
  } 
  echo $conn."----done\n\n";
}
?> 

That is quite some query, is there a way for you do reduce it?
maybe by setting a switch or something?
You've encased it in a function, which is good.
But, there isn't anything reuseable about that function, which is bad.

It seems that you could add and argument to the function for the activity.uic selection

function select_data($conn,$actuic) {...
  //... later in your query
activity.uic = '$actuic'

That would eliminate several lines and allow for a slightly smarter function.

[burkeja]

testing