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

6 votes167 views3 answers
Laravel get single column value
PHP
0 vote224 views1 answer
Laravel 8 jwt api authentication
PHP
1 vote165 views1 answer
Remove http / https from link php
PHP
2 votes236 views1 answer
Laravel get list of columns in a table
PHP
0 vote199 views6 answers
Laravel get last id
PHP
0 vote185 views1 answer
Yum install php-mysql
PHP
0 vote180 views2 answers
How to enable pretty url in yii2
PHP
0 vote158 views1 answer
Php check if string contains words from array
PHP
0 vote166 views1 answer
Alias wipedb='php artisan db:wipe'
PHP
0 vote185 views1 answer
Wordpress max post revision
PHP Wordpress