note 111823 added to pdostatement.execute
| From: | Ramijamleh | Date: | Tue, 02 Apr 2013 11:09:17 +0000 |
| Subject: | note 111823 added to pdostatement.execute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-194289@lists.php.net to get a copy of this message | ||
simplified $placeholder form
<?php
$data = ['a'=>'foo','b'=>'bar'];
$keys = array_keys($data);
$fields = '
'.implode(', ',$keys).'';
#here is my way
$placeholder = substr(str_repeat('?,',count($keys),0,-1));
$pdo->prepare("INSERT INTO baz($fields)
VALUES($placeholder)")->execute(array_values($data));
----
Server IP: 69.147.83.199
Probable Submitter: 168.187.148.19
----
Manual Page -- http://php.net/manual/en/pdostatement.execute.php
Edit -- https://master.php.net/note/edit/111823
Del: integrated -- https://master.php.net/note/delete/111823/integrated
Del: useless -- https://master.php.net/note/delete/111823/useless
Del: bad code -- https://master.php.net/note/delete/111823/bad+code
Del: spam -- https://master.php.net/note/delete/111823/spam
Del: non-english -- https://master.php.net/note/delete/111823/non-english
Del: in docs -- https://master.php.net/note/delete/111823/in+docs
Del: other reasons-- https://master.php.net/note/delete/111823
Reject -- https://master.php.net/note/reject/111823
Search -- https://master.php.net/manage/user-notes.php