Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:113299
To: internals@lists.php.net
References: <499c2591-fb11-1b9d-d402-39f7ec1c6b85@themad.com.au>
 <6EC89E9A-035D-4D2B-97D7-845DC4FF3E32@koalephant.com>
 <CA+p1FaYJbD5Yyximj5LDdZmeCaxV_p1wnqyb9mfe=Bz9E-LVoA@mail.gmail.com>
Message-ID: <e6a89e88-bbb3-91b7-e138-66719ba1f8c4@processus.org>
Date: Sat, 27 Feb 2021 15:03:43 +0100
MIME-Version: 1.0
In-Reply-To: <CA+p1FaYJbD5Yyximj5LDdZmeCaxV_p1wnqyb9mfe=Bz9E-LVoA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Subject: Re: [PHP-DEV] PDO integer changes in 8.1 will stop many websites I
 support
From: pierre-php@processus.org (Pierre)

Le 27/02/2021 à 14:18, David Gebler a écrit :
> Apologies, in respect of point 1 in my reply, I misread your original
> message and didn't realise you were referring to the upcoming 8.1 change,
> thought you were referring to the current 8.0.1 release.
>
> This change AFAIK only affects emulated prepares and is an improvement, as
> previously you needed to have emulation off to get the correct data types.
> With modern PHP, MySQL and mysqnd there is not really a reason for anyone
> to be using emulated prepares anyway so my advice on points 2-5 remains the
> same.
>
> Dave

Hello,

I'm curious, why are you stating that emulated prepares are not useful 
anymore ?

Using the prepare() function as I remember correctly seems to be the 
only way to execute a query that allows you to pass an array of 
parameters instead of having to call PDOStatement::bindParam() for each 
parameter. That's the only reason I use emulated prepares anyway, it 
allows to use this API without actually preparing the queries, which is 
what I want most of the time. Did I miss an improvement on that side ?

After reading twice what I said, I'm thinking that calling many times 
bindParam() in a naive foreach would work anyway. Is there any actual 
downside using emulated prepares this way ? Performance wise ? Feature 
wise ?

--

Pierre