Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ???PHP and Oracle???

Re: ???PHP and Oracle???

From: Kristy <nobody_at_home.com>
Date: 2000/04/12
Message-ID: <38f4e699.91758842@client.sw.news.psi.net>#1/1

Repeat after me, "Jerzy Gulczynski is god".

Thanks,
Kristy

On Wed, 12 Apr 2000 17:45:51 +0200, Jerzy Gulczynski <Jerzy.Gulczynski_at_Hub.Interia.pl> wrote:

>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US