[PHP-DB] Multiple Update SQL Statements Execution

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,

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

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

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

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,

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

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 add it to the

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

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 question.

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

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] PHP MySQL Driver Choice -- Fastest?

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

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

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_PRELOAD

[PHP-DB] close clue?

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] PHP MySQL Driver Choice -- Fastest?

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 php-db@lists.php.net Subject: Re: [PHP-DB] PHP MySQL

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

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 for PHP5.

[PHP-DB] oci8

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

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

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

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

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] close clue?

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?

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 code overhead.

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

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-DB] oci_connect

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

Re: [PHP-DB] oci_connect

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

Re: [PHP-DB] oci_connect

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.