Re: ???PHP and Oracle???

From: Jerzy Gulczynski <Jerzy.Gulczynski_at_Hub.Interia.pl>
Date: 2000/04/12
Message-ID: <38F49A2F.4DACE27@Hub.Interia.pl>#1/1

small example

<?php

$db = "fm";
$conn = OCIPLogon("a","b",$db);

$stmt_tytul = OCIParse($conn,"select ing_tytul from gp_informacje");
$stmt_lead = OCIParse($conn,"select ing_lead from gp_informacje");
$stmt_tresc = OCIParse($conn,"select ing_tresc from gp_informacje");

OCIExecute($stmt_tytul);

OCIExecute($stmt_lead);
OCIExecute($stmt_tresc);

$tytul_rows = OCIFetchStatement($stmt_tytul,$results_tytul); $lead_rows = OCIFetchStatement($stmt_lead,$results_lead);

   for ( $i = 0; $i < 3; $i++ ) {

      reset($results_tytul);
      reset($results_lead);
      print "<TR>\n";
      while ( $column = each($results_tytul) ) {
         $data = $column['value'];
         print "<TD>$data[$i]</TD>\n";
         print "<br\n>";
        }
      print "</TR>\n";

   }
# print "</TABLE>\n";

OCIFreeStatement($stmt_tytul);
OCILogoff($conn);

?>

Jerry

Kristy wrote:

> Hi everybody! <--Dr. Nick voice-->

>

> Are there any good PHP + Oracle examples out there? I just need the
> basics:

>

> 0) how to connect and login

>

> 1) how to execute a select statement

>

> 2) how to execute a stored procedure or package

>

> So far, all the books and online stuff talks about MySQL which does me
> no good.

>

> A little help please,
> Kristy
Received on Wed Apr 12 2000 - 00:00:00 CDT