Re: php5/oci8/oracle 11g1 insert doesn't work

Fred Silsbee wrote:

--- On Sun, 11/23/08, Chris <dmagick@gmail.com> wrote:

From: Chris <dmagick@gmail.com> Subject: Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work To: fredsilsbee@yahoo.com Cc: php-db@lists.php.net Date: Sunday, November 23, 2008, 9:43 PM Fred Silsbee wrote:

The following code doesn't do the insert. As is the connect message doesn't show. I've tried the insert statement in a session: [oracle@LMKIII log_book]$ sqlplus landon/rumprocella 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',

'rumprocella',$db))

{ echo "Successfully connected to

Oracle.\n";

// OCILogoff($conn); } else { $err = OCIError(); echo "Oracle Connect Error " .

$err['message'];

} // the connect shows a connect if I comment out the

following statements

$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 );

RTFM. $err = OCIError($r); echo "Oracle insert error " . $err['message']; -- Postgresql & php tutorials http://www.designmagick.com/

the code works now is the question why is there no display in the browser when the sql is bad?

Because you had a parse error and you most likely have all display_errors and other such useful things turned off. Save this code to a file. From the command line run: php -l filename.php (that's an "L" not a one). You will see: $ php -l test.php Parse error: syntax error, unexpected T_LNUMBER in test.php on line 21 Errors parsing test.php -- Postgresql & php tutorials http://www.designmagick.com/