Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry

--- On Sun, 11/23/08, Micah Gersten <[email protected]> wrote:

> From: Micah Gersten <[email protected]>
> Subject: Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry
> To: [email protected]
> Cc: [email protected]
> Date: Sunday, November 23, 2008, 9:26 AM
> Fred Silsbee wrote:
> > The following code doesn't do the insert.
> >
> > I've tried the insert statement in a session:
> >
> > [oracle@LMKIII log_book]$ sqlplus landon/<PW>
> >
> > SQL*Plus: Release 11.1.0.6.0 - Production on Sat Nov
> 22 16:01:39 2008
> >
> > Copyright (c) 1982, 2007, Oracle.  All rights
> reserved.
> >
> >
> > Connected to:
> > Oracle Database 11g Enterprise Edition Release
> 11.1.0.6.0 - Production
> > With the Partitioning, OLAP, Data Mining and Real
> Application Testing options
> >
> > SQL> select * from log_book where
> actype='B-17';
> >
> > no rows selected
> >
> > SQL> quit
> > Disconnected from Oracle Database 11g Enterprise
> Edition Release 11.1.0.6.0 - Production
> > With the Partitioning, OLAP, Data Mining and Real
> Application Testing options
> >
> >
> > <?php // File: anyco.php
> >
> > require('anyco_ui.inc');
> >
> > $db = "(DESCRIPTION =
> >    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT
> = 1521))
> >    (CONNECT_DATA =
> >      (SERVER = DEDICATED)
> >      (SID = LMKIIIGDNSID)
> >    )
> > )";
> > if ($conn=oci_connect('landon',
> 'PWD',$db))
> > {
> > echo "Successfully connected to
> Oracle.\n";
> >
> > }
> > else
> > {
> > $err = OCIError();
> > echo "Oracle Connect Error " .
> $err['message'];
> > }
> >
> >
> >   $stid = oci_parse($conn, 'insert into log_book
> values (
> TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8);');
> >
> >   $r = oci_execute($stid );
> >
> >         oci_commit($conn);
> >         OCILogoff($conn);
> > echo "end";
> > ?>
> >
> > produces:  Successfully connected to Oracle.end 
> >
> >
> > This is my first php/oci8/oracle insert! What could be
> simpler! HELP!
> >
> > In desperation, I used em to give myself every
> possible privilege !
> >
> > Not good but after it works, I can go back and correct
> and learn privileges!
> >
> > I rebooted and tried this again to no avail.
> >
> > I suspected a commit problem but oci_execute has
> commit as default!
> >
> > The table has no primary key defined since no values
> are unique.
> >
> > I have a similar table with a row id!
> >
> >
> >       
> >
> >   
> One thing that jumps out at me is the insert query.  You
> have:
> 
> $stid = oci_parse($conn, 'insert into log_book values (
> TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8);');
> 
> which will probably not do what you want.  You probably
> mean to have the
> query in double quotes and the values in single quotes.
> 
> $stid = oci_parse($conn, "insert into log_book values
> (
> TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8);");
> 
> 
> Thank you,
> Micah Gersten
> onShore Networks
> Internal Developer
> http://www.onshore.com
......Thanks!
turned out it was the blasted    ";" at the end of the select statement

the following works GREAT:

<?php // File:

$db = "(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SID = LMKIIIGDNSID)
   )
 )";
// oci_internal_debug(1);
if ($conn=oci_connect('landon', 'rumprocella',$db))
{
 print "Successfully connected to Oracle.\n\n";
 // OCILogoff($conn);
}
else
{
 $err = OCIError();
 echo "Oracle Connect Error " . $err['message'];
}
  $stid = oci_parse($conn, "insert into log_book values ( TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8)");
  $r = oci_execute($stid );

        oci_commit($conn);
        OCILogoff($conn);
echo "end";

?>