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

8 votes236 views4 answers
Php print to console
PHP
5 votes192 views3 answers
Crrate model in laravel
PHP
7 votes207 views2 answers
Laravel unique multiple columns
PHP Laravel
1 vote194 views1 answer
How to use bootstrap in laravel 8 remove tailwind
PHP Laravel
0 vote171 views1 answer
Get min value from array php
PHP
0 vote215 views7 answers
Debugger in laravel
PHP Laravel
0 vote196 views1 answer
Discord.py Levels
PHP
0 vote178 views1 answer
Php return a header 200
PHP
23 votes178 views6 answers
Carbon datetime test online
PHP
4 votes166 views5 answers
Laravel db inserr
PHP