Re: [PHP-DB] oci_connect

2008-11-19 Thread Daniel Brown
On Wed, Nov 19, 2008 at 8:15 PM, Fred Silsbee <[EMAIL PROTECTED]> wrote: [snip!] "Fred," Please keep all of your posts in the same thread with the same subject. You're making it very difficult for others to follow along with your ramblings, and seem to even be confusing yourself a bit. C

Re: [PHP-DB] oci_connect

2008-11-19 Thread Christopher Jones
Fred Silsbee wrote: > I have the following in /etc/httpd/conf/httpd.conf > > SetEnv ORACLE_HOSTNAME localhost.localdomain > SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin > SetEnv ORACLE_BASE /u01/app/oracle > SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 > SetEnv OR

[PHP-DB] oci_connect

2008-11-19 Thread Fred Silsbee
I have the following in /etc/httpd/conf/httpd.conf SetEnv ORACLE_HOSTNAME localhost.localdomain SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin SetEnv ORACLE_BASE /u01/app/oracle SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 SetEnv ORACLE_SID lmkiiiGDNSID SetEnv ORACLE_

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Chris wrote: > Micah Gersten wrote: >> Chris wrote: >>> Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli >>> Either mysqli or pdo since they'd deal with the mysql client directly. >>> >>> ADODB is a php library, so it's not going to be as fast because

Re: [PHP-DB] close clue?

2008-11-19 Thread Christopher Jones
Fred Silsbee wrote: http://bugs.php.net/bug.php?id=43186 Why do you think it's a clue? Are you getting a crash? Does your PHP command line work? So far we have almost zero information about your configuration in particular we don't have phpinfo() output (despite suggestions you check it).

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
YVES SUCAET wrote: How does the "default" php_mysql.dll compare to these? Is mysqli faster than mysql? I'd call that a native driver. No idea about mysqli vs mysql. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. ADODB is precompi

[PHP-DB] oci8

2008-11-19 Thread Fred Silsbee
oci8 OCI8 Supportenabled Version 1.3.4 Revision$Revision: 1.269.2.16.2.38.2.20 $ Active Persistent Connections 0 Active Connections 0 Compile-time ORACLE_HOMEno value Libraries Used no value Temporary Lob support enabled Collections support enabled Direc

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Chris wrote: > Micah Gersten wrote: >> Which is the fastest driver for this? >> ADODB >> PDO >> mysqli > > Either mysqli or pdo since they'd deal with the mysql client directly. > > ADODB is a php library, so it's not going to be as fast because you > have php code overhead. > ADODB is precompiled

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread YVES SUCAET
How does the "default" php_mysql.dll compare to these? Is mysqli faster than mysql? tia, Yves -- Original Message -- Received: Wed, 19 Nov 2008 04:00:46 PM CST From: Chris <[EMAIL PROTECTED]> To: Micah Gersten <[EMAIL PROTECTED]>Cc: PHP DB Subject: Re: [PHP-DB] PHP MySQL Driver Choice -

[PHP-DB] close clue?

2008-11-19 Thread Fred Silsbee
http://bugs.php.net/bug.php?id=43186 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-19 Thread Fred Silsbee
there is no problem with my 11g1 system I also have a number of similar "impossible" unix/solaris/Linux installs under my belt! right now I am editing my /etc/httpd/conf/httpd.conf file from a php site: http://us.php.net/manual/en/oci8.setup.php ORACLE_HOME ORACLE_SID LD_PRELOA

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. -- Postgresql & php tutorials http://www.designmagic

[PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Which is the fastest driver for this? ADODB PDO mysqli Anything else? -- 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

Re: [PHP-DB] Multiple Update SQL Statements Execution

2008-11-19 Thread Fergus Gibson
On Wed, Nov 19, 2008 at 5:55 AM, Alice Wei <[EMAIL PROTECTED]> wrote: > I am inquiring on this list to see if it is possible to create a script that > takes multiple update statements without my having to write one "SQL" > statement for each of the updates. I'm not sure I understand your questi

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-19 Thread Christopher Jones
Fred Silsbee wrote: > GREAT!!but how! How what? > http://us.php.net/manual/en/oci8.setup.php What about it? >> [phpinfo output of] > Compile-time ORACLE_HOME no value >> The lack of a value here is an artifact aka buglet of >> installing from >> the PECL package. I'll a

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-19 Thread Fred Silsbee
here is where the error occurs:oci8.c /* use NLS_LANG if no or invalid charset specified */ if (!charsetid) { size_t rsize = 0; sword result; // here PHP_OCI_CALL_RETURN(result, OCINlsEnvironmentVariableGet, (&charsetid_nls_lang, 0, O

Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache environment

2008-11-19 Thread Fred Silsbee
GREAT!!but how! http://us.php.net/manual/en/oci8.setup.php --- On Wed, 11/19/08, Christopher Jones <[EMAIL PROTECTED]> wrote: > From: Christopher Jones <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] what sets the ORACLE_HOME variable and sets PHP/Apache > environment > To: [EMAIL

[PHP-DB] Multiple Update SQL Statements Execution

2008-11-19 Thread Alice Wei
Hi, I am inquiring on this list to see if it is possible to create a script that takes multiple update statements without my having to write one "SQL" statement for each of the updates. I have a scenario of which I create a table of some sort with some existing information using Flex, a