Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:99117
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain marcodor.com designates 93.115.138.71 as permitted sender)
To: "'Adam Baratz'" <adambaratz@php.net>
Cc: <internals@lists.php.net>
References: <CADxrgCN5Y5dieZEoP2bfM7fSD5UpUt4s6oVNT95etE-VDsQpbw@mail.gmail.com> <000601d2cff3$bbffc5f0$33ff51d0$@marcodor.com> <CADxrgCNChrCSAeAmnM_iQ=q6BR_CBO8z6Q5E1f17qUwXDBf1oQ@mail.gmail.com>
In-Reply-To: <CADxrgCNChrCSAeAmnM_iQ=q6BR_CBO8z6Q5E1f17qUwXDBf1oQ@mail.gmail.com>
Date: Fri, 19 May 2017 14:52:38 +0300
Organization: Marcodor
Message-ID: <001001d2d096$69fa0330$3dee0990$@marcodor.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0011_01D2D0AF.8F47FE80"
Thread-Index: AQKui4TWyrBa+Xk+uOoGXxI7mVHe7wIi1HjYAym2+eWgGa+LcA==
Content-Language: ro
Subject: RE: PDO Parameter types // PDO::PARAM_AUTO
From: dorin.marcoci@marcodor.com ("Dorin Marcoci")

------=_NextPart_000_0011_01D2D0AF.8F47FE80
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi Adam,

=20

From: Adam Baratz [mailto:adambaratz@php.net]=20
Sent: Friday, May 19, 2017 1:26 PM



Maybe even a better way is just to change default param type from =
PARAM_STR to PARAM_AUTO in bindValue family routines, without any driver =
options or configs.
So if drivers supports server prepares with type hinting, OK: treat it =
better, if not, push it as a string like is now.

=20

I'm not sure that changes the proposal too much. My position is still =
that I'd like PDO to be less "magical," to put more of the burden on =
providing the right content to the user.=20

=20

=20

=20

=20

=20

=20

=20

Much of PHP internals are about providing a light layer on a third-party =
library (in this case, all the DB libraries). You can then compose them =
as needed to get the right functionality for your application. We get a =
lot of power and flexibility from that. Making APIs that are too =
"opinionated" makes it harder for users to control their destiny.

=20

I haven't tested this, but I think you could implement the functionality =
you need in userland. You could write a class like this:

=20

class MyPDOStatement extends \PDOStatement {

  public function bindValue($parameter, $value, $data_type =3D -1) { // =
or define a const somewhere for an AUTO type

    if ($data_type =3D=3D -1) {

      switch (gettype($value) {

        case 'boolean':

          $data_type =3D \PDO::PARAM_BOOL;

          break;

        default:

          $data_type =3D \PDO::PARAM_STR;

          break;

=20


------=_NextPart_000_0011_01D2D0AF.8F47FE80--