Re: [PHP-DB] Re: PHP and table/view names with '$'

With PHP 5.3 the "nowdocs" syntax will make quoting SQL easier: http://blogs.oracle.com/opal/2008/02/php_53_nowdocs_make_sql_escapi.html Chris Mark Casson wrote: i was absolutely convinced that i tried to escape the $ and it hadn't worked and got side tracked looking at other options . . . bu

Re: [PHP-DB] Prepared Statement Insert Problem

kesavan trichy rengarajan wrote: > could be rewritten as: > mysqli_stmt_bind_param($submitadmin, "isss", $numrows, $admin, > sha1($password), $email); Turning on E_STRICT in PHP 5.3 will show PHP Strict Standards: Only variables should be passed by reference This is also true in earlier v

Re: [PHP-DB] Fedora 9-->10 ..now "oracle connect error"

Fred Silsbee wrote: Oracle Connect Error What error? What Oracle client libraries do you have? Where are they located just upgraded Fedora 9->10 using new php.ini file containing: ; Note: packaged extension modules are now loaded via the .ini files ; found in the directory /etc/php

Re: [PHP-DB] Fedora 9-->10 ..now "oracle connect error"

Fred Silsbee wrote: >> 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 lmk

Re: [PHP-DB] What's the number scheme for 'colno' for Select call in PDO driver

Sanjeev Kumar wrote: > Hi, > > In the implemetation of Pdo-driver (extension) , what's the Sequence/Index > scheme for parameter: 'colno' ? > > This param 'colno' is input in driver calls (of PDO statement) : > > int SKEL_stmt_describe_col(pdo_stmt_t *stmt, int colno TSRMLS_DC) > > int SKEL_st

[PHP-DB] Potential changes for the OCI8 extension for Oracle 11.2

Now that Oracle Database 11.2 has been released (http://blogs.oracle.com/opal/2009/09/oracle_database_11gr2_enhancem.html), we'd like to make some enhancements to PHP OCI8 for PHP 5.3.2 & PHP 6: 1. Allow the oci_set_prefetch() count to be 0, i.e. just fetch/buffer one row at a time and don't

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

Andy Shellam (Mailing Lists) wrote: > "First, when connecting, the function would first try to find a > (persistent) link that's already open with the same host, username > and password. If one is found, an identifier for it will be returned > instead of opening a new connection." > > Therefore,

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

et > running, but perhaps it would be worth waiting for 5.3. > > -Sara The mysqli extension appears to use "mysqli_" as the hash key prefix so there won't be PHP connection structure sharing here either. Chris > > > Christopher Jones wrote: >> >>

Re: [PHP-DB] dl () problem

Check the notes: http://www.php.net/manual/en/function.dl.php#function.dl.notes Christoph Rosse wrote: stupid question ... but did you restart apache after editing php.ini ? Sent from my iPhone On 26.01.2010, at 16:02, Murat Beyhan wrote: Dear All, I have updated apache2 and php5 then I h

Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g

At a guess, there is a clash with the SSL libraries or it is a libpthread problem - google around for background. Chris Andre LAGADEC wrote: Hello, I am on Solaris 10 X86 with DELL IP , and I compile Php-5.2.9 with Apache2, Mysql6 and Oracle10g with success. But when I want to connect to Ora

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

ZeYuan Zhang wrote: > Hi there. > > Why oci_commit function always returns true even when the transaction fails. > I just copied the code in the php manual [Example 1636. oci_commit() example], > and runned it, the situation is as follows: > > * The statements do commit at the moment when oci_comm

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

Chris wrote: > ZeYuan Zhang wrote: >> Hi there. >> >> Why oci_commit function always returns true even when the transaction >> fails. >> I just copied the code in the php manual [Example 1636. oci_commit() >> example], >> and runned it, the situation is as follows: >> >> * The statements do comm

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

Chris wrote: Christopher Jones wrote: Chris wrote: > ZeYuan Zhang wrote: >> Hi there. >> >> Why oci_commit function always returns true even when the transaction >> fails. >> I just copied the code in the php manual [Example 1636. oci_commit() &g

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

> echo "Second Insert\n"; > $s = oci_parse($c, "insert into t_tab values ( 1,-1)"); > $r = oci_execute($s, OCI_DEFAULT); // Explore the difference with and without OCI_DEFAULT > if (!$r) { > $m = oci_error($s); > trigger_error('Could not execute: '. $m['message'], E_USER_ERROR); > } > $

Re: [PHP-DB] Oracle PDO UTF-8 problem

Glad you resolved it. Overall, I have to recommend the OCI8 extension over the unmaintained (like much of PDO) PDO_OCI extension. Chris On 01/13/2011 11:36 PM, Karsten Lehmann wrote: I found out that the error depends on the wrong character set of the Oracle Database. In my case this was a W

Re: [PHP-DB] Oracle NClobs

On 08/05/2011 09:08 AM, Lester Caine wrote: n.a.mor...@brighton.ac.uk wrote: Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. It may not be related, but there were a number of issues with BLOB ids in Firebird which were not fixed until 5.2.7, I don't have anything tha

Re: [PHP-DB] Oracle NClobs

On 08/05/2011 08:55 AM, n.a.mor...@brighton.ac.uk wrote: Guys, Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. The following piece of code works with a CLOB, but not with an NCLOB. Can anyone shed any light please? There is no support for NCLOB in PHP OCI8. Chr

Re: [PHP-DB] Debugger

On 10/24/2012 05:02 PM, Ethan Rosenberg, PhD wrote: Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and allow input? B. Aptana gives the following message: 'Launching Firefox' internal server has

Re: [PHP-DB] Probleme upper accents

On 4/5/13 7:23 AM, Matijn Woudt wrote: On Fri, Apr 5, 2013 at 3:19 PM, Toby Hart Dyke wrote: It looks similar to this bug: http://bugs.php.net/bug.php?**id=54379- possibly fixed in a later version? Your PHP is pretty elderly. Toby I would sugg

Re: [PHP-DB] Re: PHP 7 and sqlsrv

On 4/10/15 3:20 PM, Jim Giner wrote: On 4/10/2015 4:03 PM, John Hermsen wrote: I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't been able to get it compiled yet. Thanks, John php 7?? I didn't even see php 6 go past me! Her

Re: [PHP-DB] Getting PDO-OCI to work in PHP 7

Possibly try a two stage build: - build your main PHP without PDO_OCI - build PDO_OCI as a shared library with a simplified configure command that doesn't have ldap. Then move the resulting PDO_OCI library to your first PHP install and update php.ini. Then test thoroughly. I have had to do

[PHP-DB] Re: [External] : [PHP-DB] PDO to Oracle db and secure external password store aka wallet for authentication

On 28/9/21 6:59 pm, Mathias Zarick wrote: Hi there, I am wondering how it would be possible to use authentication using a secure external password store aka wallet with PDO OCI. See Oracle external authentication and OCI_CRED_EXT in the underground php oracle manual. and https://docs.orac

<    1   2