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

2 votes95 views1 answer
Php code to increase maximum execution time
PHP
0 vote122 views1 answer
Laravel make migration controller resource mcr
PHP Laravel
0 vote116 views1 answer
Null check nested object laravel
PHP Laravel
1 vote112 views3 answers
Print query statement in laravel
PHP
0 vote110 views1 answer
If is gutenberg page php wp
PHP Wordpress
0 vote100 views2 answers
Download multiple files as zip in PHP
PHP
2 votes88 views3 answers
Php insert array into mysql
PHP
1 vote116 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
1 vote55 views1 answer
Woocommerce search form <?php get_search_form(); ?>
PHP
0 vote134 views2 answers
Wordpress truncate text
PHP Wordpress