Preared request pdo

<?php
/* Exécute une requête préparée en passant un tableau de valeurs */
$sql = 'SELECT nom, couleur, calories
    FROM fruit
WHERE calories < :calories AND couleur = :couleur';
$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute(array(':calories' => 150, ':couleur' => 'red'));
$red = $sth->fetchAll();
$sth->execute(array(':calories' => 175, ':couleur' => 'yellow'));
$yellow = $sth->fetchAll();
?>

Source: php.net

Similar codes

2 votes190 views4 answers
Laravel where in array
PHP
0 vote212 views1 answer
Php afosto / yaac urn:ietf:params:acme:error:malformed 405
PHP
7 votes170 views1 answer
Passport generate key
PHP
-2 votes155 views1 answer
Php curl_exec get response json
PHP
1 vote194 views1 answer
Laravel route fallback
PHP Laravel
0 vote159 views1 answer
Creating thumbnail in codeigniter
PHP
50 votes162 views3 answers
Show display error php
PHP
23 votes267 views6 answers
Make auth in laravel 7
PHP Laravel
7 votes177 views5 answers
Laravel if else condition in blade file
PHP
0 vote199 views3 answers
Laravel has many deep
PHP Laravel