Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1
Fred Silsbee wrote:
while ($newArray = oci_fetch_assoc($result)) {
foreach ($fields as $field){
${$field} = $newArray[$field];// values not making it into variable
}
print_r($newArray);
what is here?
Oracle uppercases all fields, tablenames by default (per sql spec).
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] works under mysql 5 but not under Oracle 11g1
//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;
/* Create and execute query. */
// $query = "select * from log_book_id";
// $result = mysql_query($query);
// Loop through each row, outputting the actype and name
echo <<
checked
rowID
fdate
actype
acid
nlandings
nhours
HTML;
//get log_book_id table information
$user = "select * from log_book_id";
$result = oci_parse($conn, $user);
$r = oci_execute($result);
//display log_book_id information
$count = 0;
while ($newArray = oci_fetch_assoc($result)) {
foreach ($fields as $field){
${$field} = $newArray[$field];// values not making it into
variable
}
$rowID = $newArray['rowID'];
//note that we do not rely on the checkbox value as not all browsers
submit it
//instead we rely on the name of the checkbox.
echo <<
Check
to delete record
$rowID
$fdate
$actype
$acid
$nlandings
$nhours
HTML;
}// while
echo <<
HTML;
}//close function
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work
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 the sql statement (not what the message says). http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work
--- 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"
> Date: Sunday, November 23, 2008, 10:41 PM
> 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 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) 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
> >>>
> >>> >>>
> >>> 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/'),'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
>
>
>
> --
I put back errors on purpose to teach myself how to handle errors!
I looked in the book and corrected my code to no avail!
still no browser output
I did the command you suggested:
[EMAIL PROTECTED] html]# php -l try_logid.php
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib/php/modules/php_oci8.dll' - /usr/lib/php/modules/php_oci8.dll: cannot
open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib/php/modules/php_oracle.dll' - /usr/lib/php/modules/php_oracle.dll:
cannot open shared object file: No such file or directory in Unknown on line 0
PHP Parse error: syntax error, unexpected T_LNUMBER in try_logid.php on line 21
Errors parsing try_logid.php
the route I traveled:
install 11g1
install pecl and phize in Fedora
install oci8 (according to your great instructions)
apache already installed
then I had to add environment variables to httpd and httpd.conf
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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: 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:
[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) 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
= 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/'),'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/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] why didn't errors show up
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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work
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) 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 RTFM. $err = OCIError($r); echo "Oracle insert error " . $err['message']; -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry
--- 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
> --- 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 sql in a seperate variable that you
> can
> > than echo to
> > screen (debugging sql)
> >
> > Because I think your sql string does not go across
> properly
> > unless you
> > escape the single quotes you need to send across as
> single
> > quotes.
> > <<
> > $sql='insert into log_book values (
> >
> TO_DATE(\'08/12/1973\',\'MM/dd/\'),\'B-17\',\'N5787G\',1,1.8)';
> > echo $sql;
> >
> > $stid = oci_parse($conn,$sql );
> > <<
> > Jack
> >
> > 2008/11/23 Fred Silsbee <[EMAIL PROTECTED]>
> >
> > > The following code doesn't do the insert.
> > >
> > > I've tried the insert statement in a session:
> > >
> > > [EMAIL PROTECTED] log_book]$ sqlplus
> landon/
> > >
> > > 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
> > >
> > >
> > > > >
> > > 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/'),'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!
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit:
> http://www.php.net/unsub.php
> > >
> > >
> >
> >
> > --
> > J.A. van Zanen
>
>
> this is bad! good thing the script is simple
>
> thanks for your code
>
> I have 43 years of programming experience and you'd
> think I'd know better.
>
> This is however so simple (2 lines right out of the book) I
> expected it to work right out of the book!
>
> With this code, however, I do not even get the following:
>
> Successfully connected to Oracle. end
>
> This is however a great clue!
>
> Strange that yesterday I was running this and started
> sqldeveloper to find
>
> it showing the table NOT existing!
>
> I shut off the browser and bingo the table showed existing.
>
> It didn't show busy...but non existent!
>
> It happened again:
>
> It didn't show busy...but non existent!
>
> I shut off the browser and bingo the table showed existing.
the last problem (whew!): you mentioned this-> THANKS
$stid = oci_parse($conn, 'insert into log_book values (
TO_DATE('08/12/1973','MM/dd/'),'B-17','N5787G',1,1.8)');
should be changed to :
$stid = oci_parse($conn, "insert into log_book values (
TO_DATE('08/12/1973','MM/dd/'),'B-17','N5787G',1,1.8)");
in other places this makes no difference
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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: php-db@lists.php.net
> 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:
> >
> > [EMAIL PROTECTED] log_book]$ sqlplus landon/
> >
> > 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
> >
> >
> > >
> > 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/'),'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/'),'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/'),'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 Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry
--- 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
> --- 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 sql in a seperate variable that you
> can
> > than echo to
> > screen (debugging sql)
> >
> > Because I think your sql string does not go across
> properly
> > unless you
> > escape the single quotes you need to send across as
> single
> > quotes.
> > <<
> > $sql='insert into log_book values (
> >
> TO_DATE(\'08/12/1973\',\'MM/dd/\'),\'B-17\',\'N5787G\',1,1.8)';
> > echo $sql;
> >
> > $stid = oci_parse($conn,$sql );
> > <<
> > Jack
> >
> > 2008/11/23 Fred Silsbee <[EMAIL PROTECTED]>
> >
> > > The following code doesn't do the insert.
> > >
> > > I've tried the insert statement in a session:
> > >
> > > [EMAIL PROTECTED] log_book]$ sqlplus
> landon/
> > >
> > > 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
> > >
> > >
> > > > >
> > > 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/'),'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!
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit:
> http://www.php.net/unsub.php
> > >
> > >
> >
> >
> > --
> > J.A. van Zanen
>
>
> this is bad! good thing the script is simple
>
> thanks for your code
>
> I have 43 years of programming experience and you'd
> think I'd know better.
>
> This is however so simple (2 lines right out of the book) I
> expected it to work right out of the book!
>
> With this code, however, I do not even get the following:
>
> Successfully connected to Oracle. end
>
> This is however a great clue!
>
> Strange that yesterday I was running this and started
> sqldeveloper to find
>
> it showing the table NOT existing!
>
> I shut off the browser and bingo the table showed existing.
>
> It didn't show busy...but non existent!
>
> It happened again:
>
> It didn't show busy...but non existent!
>
> I shut off the browser and bingo the table showed existing.
BINGO!
It was the ";" at the end of the select staement!
this works:
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry
--- 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 sql in a seperate variable that you can
> than echo to
> screen (debugging sql)
>
> Because I think your sql string does not go across properly
> unless you
> escape the single quotes you need to send across as single
> quotes.
> <<
> $sql='insert into log_book values (
> TO_DATE(\'08/12/1973\',\'MM/dd/\'),\'B-17\',\'N5787G\',1,1.8)';
> echo $sql;
>
> $stid = oci_parse($conn,$sql );
> <<
> Jack
>
> 2008/11/23 Fred Silsbee <[EMAIL PROTECTED]>
>
> > The following code doesn't do the insert.
> >
> > I've tried the insert statement in a session:
> >
> > [EMAIL PROTECTED] log_book]$ sqlplus landon/
> >
> > 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
> >
> >
> > >
> > 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/'),'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!
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> J.A. van Zanen
this is bad! good thing the script is simple
thanks for your code
I have 43 years of programming experience and you'd think I'd know better.
This is however so simple (2 lines right out of the book) I expected it to work
right out of the book!
With this code, however, I do not even get the following:
Successfully connected to Oracle. end
This is however a great clue!
Strange that yesterday I was running this and started sqldeveloper to find
it showing the table NOT existing!
I shut off the browser and bingo the table showed existing.
It didn't show busy...but non existent!
It happened again:
It didn't show busy...but non existent!
I shut off the browser and bingo the table showed existing.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry
--- 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 the semicolon from the sql string
>
> Brgds
>
> Jack
>
> 2008/11/23 Fred Silsbee <[EMAIL PROTECTED]>
>
> > The following code doesn't do the insert.
> >
> > I've tried the insert statement in a session:
> >
> > [EMAIL PROTECTED] log_book]$ sqlplus landon/
> >
> > 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
> >
> >
> > >
> > 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/'),'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!
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
Thanks! I'll try that. Something strange happened yesterday! I ran the script
via the browser and then brought up sqldeveloper!
The table appeared NOT to be there until I closed the browser!
This is worrisome!
Logging in via sqlplus doesn't show the table busy
I must remember the rules here to NOT top post!
Forgive me if I forget once in a while!
> --
> J.A. van Zanen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry
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/
>
> 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
>
>
>
> 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/'),'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/'),'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/'),'B-17','N5787G',1,1.8);");
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
