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 vote257 views1 answer
How to delete a row in phpmyadmin
PHP
0 vote265 views1 answer
Which programming languae does php resemble to?
PHP
0 vote256 views1 answer
Codeigniter set db prefix
PHP
0 vote359 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter
6 votes303 views1 answer
Laravel get client public ip
PHP Laravel
1 vote280 views1 answer
Php date loop
PHP
0 vote276 views1 answer
Php check if variable is resource
PHP
0 vote288 views1 answer
Php store session in cookie
PHP
0 vote273 views1 answer
Comparing floats php
PHP
0 vote262 views1 answer
Php array current
PHP