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 votes223 views1 answer
Php get day diff
PHP
0 vote255 views1 answer
How to display image from aws s3 in laravel blade
PHP Laravel
0 vote268 views2 answers
Check if string contains only whitespace php
PHP
0 vote223 views3 answers
Php command get ini params
PHP
7 votes226 views2 answers
Laravel field types from database field type
PHP Laravel
4 votes357 views6 answers
Laravel jwt
PHP
0 vote289 views4 answers
Laravel upload image
PHP Laravel
0 vote247 views1 answer
Drupal 9 cache killer kill switch
PHP
0 vote261 views1 answer
Laravel get mysql column datatype
PHP Laravel
0 vote251 views1 answer
Old function use in checkbox selected in laravel blade
PHP Laravel