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 votes501 views4 answers
Codeigniter 4 redirect to home
PHP CodeIgniter
2 votes378 views1 answer
Laravel migration with primary key
PHP Laravel
0 vote340 views1 answer
Hash not found laravel
PHP
0 vote329 views2 answers
Percentage in php
PHP
3 votes341 views2 answers
Laravel first or fail
PHP Laravel
1 vote387 views1 answer
How to use plugin shortcode in wordpress template
PHP
0 vote369 views1 answer
Laravel create pivot migration
PHP
1 vote402 views2 answers
Wordpress login user programmatically
PHP Wordpress
0 vote333 views1 answer
Regenerate session ID and remove all session data
PHP
1 vote391 views1 answer
Array_last in laravel 8
PHP Laravel