note 128597 added to pdostatement.execute
| From: | Sbastien at main dot php dot net | Date: | Thu, 08 Jun 2023 07:48:27 +0000 |
| Subject: | note 128597 added to pdostatement.execute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-220554@lists.php.net to get a copy of this message | ||
Strangely the manual doesn't give a full SELECT example.
<?php
$sql = <<<SQL
SELECT ALL name, calories, colour
FROM fruit
WHERE calories < :calories AND colour = :colour
SQL;
$select = $pdo->prepare($sql);
$select->execute(['calories' => 150, 'colour' => 'red']);
$data = $select->fetchAll();
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.13.130 (proxied: 2a01:e0a:968:1840:8423:75f5:e117:b0ce)
----
Manual Page -- https://php.net/manual/en/pdostatement.execute.php
Edit -- https://main.php.net/note/edit/128597
Del: integrated -- https://main.php.net/note/delete/128597/integrated
Del: useless -- https://main.php.net/note/delete/128597/useless
Del: bad code -- https://main.php.net/note/delete/128597/bad+code
Del: spam -- https://main.php.net/note/delete/128597/spam
Del: non-english -- https://main.php.net/note/delete/128597/non-english
Del: in docs -- https://main.php.net/note/delete/128597/in+docs
Del: other reasons-- https://main.php.net/note/delete/128597
Reject -- https://main.php.net/note/reject/128597
Search -- https://main.php.net/manage/user-notes.php