Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:100053
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.128.171 as permitted sender)
Date: Wed, 26 Jul 2017 21:09:40 +0100
User-Agent: K-9 Mail for Android
In-Reply-To: <84.D6.49004.EC298795@pb1.pair.com>
References: <6B.63.49004.FFD68795@pb1.pair.com> <F7215A26-7D22-42E7-8ED8-F94939182B49@gmail.com> <84.D6.49004.EC298795@pb1.pair.com>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
To: internals@lists.php.net,=?UTF-8?Q?Micha=C5=82?= <aaatoja@o2.pl>
Message-ID: <BF2B9DA1-CCE8-483C-B078-64CF5E5EDE9A@gmail.com>
Subject: Re: [PHP-DEV] PDO native JSON / array support
From: rowan.collins@gmail.com (Rowan Collins)

On 26 July 2017 14:02:03 BST, "Micha=C5=82" <aaatoja@o2=2Epl> wrote:
>JSON should be automatically converted to proper type(s)=2E
>
>$data =3D ['name' =3D> 'John'];
>$sth =3D $dbh->prepare('INSERT INTO table (json_column) values (:data)');
>$sth->bindParam(':data', $data, PDO::PARAM_JSON); // new parameter
>
>
>SELECT json_column FROM table;
>$stmt->fetch(PDO::FETCH_ASSOC) should return
>
>array(
>     [json_column] =3D> array('name' =3D> 'John')
>)


This feels like unnecessary magic to me, when you can already write this, =
and have all the power and flexibility of the existing JSON functions:

$data =3D ['name' =3D> 'John'];
$sth =3D $dbh->prepare('INSERT INTO table (json_column) values (:data)');
$sth->bindParam(':data', json_encode($data), PDO::PARAM_STRING);


As I say, array types are much more fiddly, so support for those would be =
great - that could just be well-tested encode /decode functions=2E

Regards,

--=20
Rowan Collins
[IMSoP]