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

Fred Silsbee wrote:
> 
> 
> --- On Sun, 11/23/08, Chris <[email protected]> wrote:
> 
>> From: Chris <[email protected]>
>> Subject: Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work
>> To: [email protected]
>> Cc: [email protected]
>> 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/