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

0 vote279 views1 answer
Xampp php ini
PHP
33 votes269 views6 answers
Migrate specific migration laravel
PHP Laravel
0 vote294 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
2 votes272 views1 answer
Laravel get subdomain
PHP Laravel
30 votes265 views6 answers
Artisan make auth
PHP
0 vote257 views2 answers
Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:\newxammp\htdocs\learn\index.php on line 11
PHP
2 votes257 views2 answers
Where is php.ini file in ubuntu
PHP
0 vote247 views1 answer
Php get property with ~
PHP
4 votes362 views6 answers
How to remove index.php in codeigniter
PHP CodeIgniter
2 votes245 views1 answer
Print exact sql statement executed
PHP