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

21 votes108 views5 answers
Laravel 7 auth command
PHP
0 vote132 views1 answer
Creating thumbnail in codeigniter
PHP CodeIgniter
0 vote106 views1 answer
Laravel curl request
PHP Laravel
1 vote117 views2 answers
Laravel update email unique
PHP Laravel
0 vote86 views1 answer
Eloquent update row response
PHP
0 vote129 views1 answer
Yii2 GridView Filtering on Relational Column
PHP Yii
8 votes104 views3 answers
Session value not removed php
PHP
0 vote91 views1 answer
How to add to array in single without repetation
PHP
1 vote93 views1 answer
Bindparam php
PHP
0 vote96 views1 answer
Combine 2 columns search query laravel
PHP