Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:100049
Return-Path: <johannes@schlueters.de>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 48615 invoked from network); 26 Jul 2017 15:43:24 -0000
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 26 Jul 2017 15:43:24 -0000
Authentication-Results: pb1.pair.com smtp.mail=johannes@schlueters.de; spf=permerror; sender-id=unknown
Authentication-Results: pb1.pair.com header.from=johannes@schlueters.de; sender-id=unknown
Received-SPF: error (pb1.pair.com: domain schlueters.de from 84.19.169.162 cause and error)
X-PHP-List-Original-Sender: johannes@schlueters.de
X-Host-Fingerprint: 84.19.169.162 mail.experimentalworks.net  
Received: from [84.19.169.162] ([84.19.169.162:42422] helo=mail.experimentalworks.net)
	by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP
	id 62/E8-49004-998B8795 for <internals@lists.php.net>; Wed, 26 Jul 2017 11:43:22 -0400
Received: from kuechenschabe.fritz.box (ppp-46-244-186-98.dynamic.mnet-online.de [46.244.186.98])
	by mail.experimentalworks.net (Postfix) with ESMTPSA id 0ADC55F0DC;
	Wed, 26 Jul 2017 17:43:19 +0200 (CEST)
Message-ID: <1501083794.2759.11.camel@schlueters.de>
To: =?UTF-8?Q?Micha=C5=82?= <aaatoja@o2.pl>, internals@lists.php.net
Date: Wed, 26 Jul 2017 17:43:14 +0200
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>
Content-Type: text/plain; charset="UTF-8"
X-Mailer: Evolution 3.18.5.2-0ubuntu3.2 
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Subject: Re: [PHP-DEV] PDO native JSON / array support
From: johannes@schlueters.de (Johannes =?ISO-8859-1?Q?Schl=FCter?=)

On Mi, 2017-07-26 at 15:02 +0200, Michał wrote:
> 
> JSON should be automatically converted to proper type(s).
> 
> $data = ['name' => 'John'];
> $sth = $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] => array('name' => 'John')
> )

Mind that such conversions are not 100% reliable:

php > var_dump(json_decode('{"a": 10.0000000000000000001}'));
object(stdClass)#1 (1) {
  ["a"]=>
  float(10)
}

php > echo json_encode(json_decode('{"a": 10.0000000000000000001}'));
{"a":10}

php > var_dump(json_decode(json_encode(json_decode('{"a": 10.0000000000000000001}'))));
object(stdClass)#1 (1) {
  ["a"]=>
  int(10)
}


johannes