Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:57828
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain lsces.co.uk from 213.123.26.184 cause and error)
Message-ID: <4F393CBD.4000907@lsces.co.uk>
Date: Mon, 13 Feb 2012 16:39:25 +0000
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0.1) Gecko/20111220 Firefox/9.0.1 SeaMonkey/2.6.1
MIME-Version: 1.0
To: PHP Developers Mailing List <internals@lists.php.net>
References: <CAPv8svWum2VBqoVyM+5nY8_yE_FyJh9hJvVamddVMKU7eNq12Q@mail.gmail.com> <1329148807.2621.785.camel@guybrush>
In-Reply-To: <1329148807.2621.785.camel@guybrush>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [PHP-DEV] Warning: PDOStatement after the output
From: lester@lsces.co.uk (Lester Caine)

Johannes Schlüter wrote:
> On Mon, 2012-02-13 at 11:37 +0200, marius adrian popa wrote:
>> >  I have this weird bug where the warning is printed after the query is
>> >  executed and printed
>> >
>> >  http://gcov.php.net/viewer.php?version=PHP_5_4&func=tests&file=ext%2Fpdo_firebird%2Ftests%2Fbug_43130.phpt
>> >
>> >  Result is correct , warning is correct only the order is out of order
> Is it? - The output is
>     string(5) "test1"
> which is not expected. The test assumes that :id-value is not
> interpreted as a place holder, but  interpreted as :id -value so the
> placeholder's name is :id, only.
> I don't know about firebird ... does it handle the named parameters
> itself and interpret :id-value as name? Then that's where the difference
> comes from.

Firebird only has positional parameters, so any linkage to names is external to 
the query or the return.There are a few areas at PDO expects responces that a 
number of the engines do not actually provide, and emulating them in extra code 
does seem to be a little excessive?

I've just proted piwik to work with the generic Firebird driver, when the core 
code has only been designed for pdo_mysql. Not to difficult once I'd extended 
the Zend Firebird driver, and quite happily simply supplying arrays of 
parameters to the query execution.

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php