Unnamed place placeholders 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 vote276 views1 answer
Select selected fields in laravel join
PHP Laravel
0 vote246 views1 answer
Php array_walk_recursive
PHP
0 vote247 views1 answer
Send data with href
PHP
36 votes263 views5 answers
Php refresh page
PHP
1 vote268 views1 answer
Tailwind text vertical alignment doesn't work
PHP
10 votes269 views3 answers
How to get week start date in php
PHP
0 vote302 views3 answers
Add factory data laravel
PHP Laravel
2 votes281 views1 answer
Php send when user log in discord webhook
PHP
0 vote298 views1 answer
Check multiple roles with Blade directive @can?
PHP
42 votes250 views3 answers
Split Functions.php
PHP