Pdo prepare

<?php
/* Execute a prepared statement by passing an array of values */
$sql = 'SELECT name, colour, calories
    FROM fruit
    WHERE calories < :calories AND colour = :colour';
$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute(array(':calories' => 150, ':colour' => 'red'));
$red = $sth->fetchAll();
$sth->execute(array(':calories' => 175, ':colour' => 'yellow'));
$yellow = $sth->fetchAll();
?>

Source: php.net

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

7 votes221 views3 answers
Random digit with seed php
PHP
5 votes153 views2 answers
Laravel groupby and latest
PHP
2 votes179 views2 answers
Get message validator failed laravel
PHP
0 vote178 views1 answer
Comparison of two tables in laravel using model
PHP
16 votes161 views6 answers
Session laravel
PHP
0 vote179 views1 answer
Optimize clear laravel not working
PHP Laravel
0 vote152 views2 answers
Php access key stdClass object
PHP
1 vote177 views1 answer
Php artisan services
PHP
0 vote198 views7 answers
Debugger in laravel
PHP Laravel
0 vote182 views1 answer
Argument 1 passed to Symfony\Component\HttpFoundation\Response::setContent() must be of the type string or null, object given, called in
PHP