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 vote166 views1 answer
How to Limit Excerpt Length in WordPress
PHP
0 vote130 views1 answer
Fetch Multiple Rows in PHP
PHP
2 votes155 views3 answers
Laravel many to many relationship with pivot table
PHP Laravel
0 vote144 views1 answer
Editing items in collection in laravel
PHP
100 votes194 views6 answers
Php substr_replace
PHP
0 vote169 views1 answer
Php set timezone italy
PHP
0 vote165 views1 answer
Laravel observer check if field changed
PHP Laravel
0 vote165 views1 answer
Php string only letters
PHP
0 vote140 views2 answers
Laravel logout all users
PHP
8 votes132 views1 answer
Laravel show routes artisan
PHP