Pdo prepare

<?php
/* Execute a prepared statement by passing an array of values */
$sql = 'SELECT name, colour, calories
    FROM fruit
    WHERE calories < :calories AND colour = :colour';
$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute(array(':calories' => 150, ':colour' => 'red'));
$red = $sth->fetchAll();
$sth->execute(array(':calories' => 175, ':colour' => 'yellow'));
$yellow = $sth->fetchAll();
?>

Source: php.net

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

16 votes249 views6 answers
Target class does not exist.
PHP
1 vote272 views1 answer
Laravel end date greater than start date validation
PHP
0 vote268 views2 answers
Mixed Content heroku laravel
PHP Laravel
3 votes274 views2 answers
Laravel carbon created_at date in current month
PHP Laravel
0 vote240 views1 answer
Phpspreadsheet
PHP
0 vote262 views2 answers
Laravel FileManager Display Blank pop up page
PHP
0 vote279 views1 answer
Wp wc php if not is single product page
PHP Wordpress
2 votes297 views1 answer
Laravel 8 delete by id
PHP Laravel
0 vote276 views2 answers
Laravel collection intersect
PHP Laravel
43 votes262 views6 answers
Laravel create migration add column
PHP Laravel