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

1 vote218 views1 answer
Drupal 8 show php errors settings.php
PHP Drupal
3 votes161 views2 answers
Destroy php variable
PHP
19 votes184 views3 answers
Check if array is empty php
PHP
5 votes183 views3 answers
Laravel blade for if
PHP
0 vote206 views1 answer
Drupal 9 check if UUD is valid
PHP Drupal
0 vote154 views1 answer
Most complicated task ina array in php
PHP
0 vote164 views2 answers
Get email with preg grep php
PHP
0 vote211 views1 answer
Laravel blade all syntex description
PHP
1 vote160 views3 answers
Laravel 6 orderby
PHP
0 vote168 views1 answer
Why phpunit don't work in commend laravel
PHP