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

4 votes362 views3 answers
Laravel use config
PHP
14 votes124 views3 answers
Why use ob_start() in php
PHP
7 votes137 views1 answer
Php artisan passport install command
PHP
1 vote152 views1 answer
Laravel remove apostrophe variables
PHP Laravel
1 vote168 views1 answer
How validate if one parameter is exist another parameter must exist in laravel
PHP
1 vote156 views1 answer
Why storage link do not work in host for laravel
PHP Laravel
0 vote136 views2 answers
Php get all array keys in json
PHP
1 vote145 views1 answer
Regex php password
PHP
0 vote191 views2 answers
Laravel has one through relationship
PHP Laravel
2 votes127 views2 answers
Read pdf text in php
PHP