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

2008-11-23 Thread Micah Gersten
Fred Silsbee wrote: The following code doesn't do the insert. I've tried the insert statement in a session: [EMAIL PROTECTED] 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.

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

2008-11-23 Thread Fred Silsbee
--- On Sun, 11/23/08, Jack van Zanen [EMAIL PROTECTED] wrote: From: Jack van Zanen [EMAIL PROTECTED] Subject: Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry To: [EMAIL PROTECTED] Date: Sunday, November 23, 2008, 7:04 AM HI of the top of my head, remove

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

2008-11-23 Thread Fred Silsbee
--- On Sun, 11/23/08, Jack van Zanen [EMAIL PROTECTED] wrote: From: Jack van Zanen [EMAIL PROTECTED] Subject: Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry To: [EMAIL PROTECTED] Date: Sunday, November 23, 2008, 7:09 AM a few things really I would stick the

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

2008-11-23 Thread Fred Silsbee
--- On Sun, 11/23/08, Fred Silsbee [EMAIL PROTECTED] wrote: From: Fred Silsbee [EMAIL PROTECTED] Subject: Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry To: Jack van Zanen [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Sunday, November 23, 2008, 6:16 PM ---

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

2008-11-23 Thread Fred Silsbee
--- 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: php-db@lists.php.net Date: Sunday, November 23, 2008, 9:26 AM Fred Silsbee

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

2008-11-23 Thread Fred Silsbee
--- On Sun, 11/23/08, Fred Silsbee [EMAIL PROTECTED] wrote: From: Fred Silsbee [EMAIL PROTECTED] Subject: Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry To: Jack van Zanen [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Sunday, November 23, 2008, 6:16 PM ---

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

2008-11-23 Thread Chris
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: [EMAIL PROTECTED] log_book]$ sqlplus landon/rumprocella SQL*Plus: Release 11.1.0.6.0 - Production on Sat Nov 22 16:01:39 2008 Copyright (c)

[PHP-DB] why didn't errors show up

2008-11-23 Thread Fred Silsbee
OK I had to (thanks to Jack Nav Zanen) (1) remove the ; off the sql statement (2) change ' to but why did NOTHING appear on the browser screen? ?php // File: anyco.php $db = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID =

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

2008-11-23 Thread Chris
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: php-db@lists.php.net Date: Sunday, November 23, 2008, 9:43 PM Fred Silsbee wrote: The following

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

2008-11-23 Thread Fred Silsbee
--- 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], PHP DB php-db@lists.php.net Date: Sunday, November 23, 2008, 10:41 PM Fred Silsbee wrote: --- On Sun, 11/23/08,

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

2008-11-23 Thread Chris
PHP Parse error: syntax error, unexpected T_LNUMBER in try_logid.php on line 21 Errors parsing try_logid.php You have a parse error. PHP cannot work out what to do in the file. It's a fatal error. It's because on line 21 (like the message says) you are using single quotes for in out of

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

2008-11-23 Thread Fred Silsbee
//construct a global variable for the form profile $fields = array(fdate, actype, acid, nlandings, nhours); problem down in while loop .. . . . . . function displayDeleteForm(){ //get $fields into the function namespace global $fields; global $conn;

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

2008-11-23 Thread Chris
Fred Silsbee wrote: while ($newArray = oci_fetch_assoc($result)) { foreach ($fields as $field){ ${$field} = $newArray[$field];// values not making it into variable }