Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

--- On Mon, 11/24/08, Fred Silsbee <[email protected]> wrote:

> From: Fred Silsbee <[email protected]>
> Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1
> To: "Chris" <[email protected]>
> Cc: [email protected]
> Date: Monday, November 24, 2008, 10:31 PM
> --- On Mon, 11/24/08, Chris <[email protected]> wrote:
> 
> > From: Chris <[email protected]>
> > Subject: Re: [PHP-DB] works under mysql 5 but not
> under Oracle 11g1
> > To: [email protected]
> > Cc: [email protected]
> > Date: Monday, November 24, 2008, 10:00 PM
> > > fixed the problem but am not fully sure of the
> optimum
> > code one should use!
> > > 
> > > I like the association idea but must change the
> > $fields array
> > > 
> > > There is a better way than using count!
> > > 
> > > 67     //get log_book_id table information
> > >      68     $user = "select * from
> > log_book_id";
> > >      69     $result = oci_parse($conn, $user);
> > >      70         $r = oci_execute($result);
> > >      71
> > >      72     //display log_book_id information
> > >      73
> > >      74     while ($newArray =
> oci_fetch_row($result))
> > {
> > >      75 //      print_r($newArray);
> > 
> > What does line 75 show and what do you expect it to
> show?
> > 
> > 
> > >      85         //note that we do not rely on the
> > checkbox value as not all browsers submit it
> > >      86         //instead we rely on the name of
> the
> > checkbox.
> > 
> > Well, that's wrong. The value is submitted IF the
> > checkbox is ticked. If it is not ticked, it is not
> submitted
> > (this is the same in any language, it's not a php
> > specific thing).
> > 
> > -- Postgresql & php tutorials
> > http://www.designmagick.com/
> 
> Array ( [LOG_ID] => 405 [FDATE] => 15-JUL-01 [ACTYPE]
> => C172 [ACID] => N17SJ [NLANDINGS] => 1 [NHOURS]
> => 1.2 ) 
> 

You will not beleiev this!

That great print_rt tip you gave me showed upper case keys in the association.....so

74     $count = 0;
     75     while ($newArray = oci_fetch_assoc($result)) {
     76         if ($count == 0)        print_r($newArray);
     77     $count = 1;
     78         foreach ($fields as $field){
     79 $fieldx = strtoupper($field);                 fixed   <<<<<<<<<<<<<
     80             ${$field} = $newArray[$fieldx];
     81                 $count = $count +1;
     82 //              print($field);
     83 //              print_r($newArray[$field]);
     84         }
Not using count!