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

0 vote249 views1 answer
Wp order archive page post by title
PHP
0 vote241 views1 answer
Turn off error printing php
PHP
22 votes247 views6 answers
Php get array key
PHP
0 vote252 views1 answer
Php array differ
PHP
0 vote293 views1 answer
Encryp with codeigniter 3
PHP CodeIgniter
0 vote250 views2 answers
Laravel db insert get last id
PHP Laravel
0 vote318 views6 answers
Create symfony project
PHP Symfony
0 vote266 views1 answer
Display data from two dimensional array in vew laravel
PHP Laravel
0 vote274 views1 answer
Laravel delete index
PHP Laravel
1 vote213 views2 answers
Wp cli generate plugin
PHP