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 vote362 views1 answer
Current date in codeigniter
PHP CodeIgniter
0 vote285 views1 answer
Laravel on cascade set null
PHP
19 votes295 views6 answers
Php sort array by specific key
PHP
16 votes306 views4 answers
Laravel auth helper function
PHP Laravel
16 votes407 views5 answers
Get user auth in laravel
PHP Laravel
0 vote285 views1 answer
Controller run
PHP
0 vote306 views1 answer
Download yii 1.1
PHP
0 vote330 views1 answer
Disable laravel passport
PHP
2 votes248 views2 answers
Php test object empty
PHP
0 vote335 views1 answer
Wordpress add to cart redirect php
PHP Wordpress