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

4 votes313 views5 answers
Get numbers from string php
PHP
0 vote158 views1 answer
Laravel How to access imagen uploaded in storage
PHP Laravel
0 vote144 views2 answers
Php check undefined offset
PHP
0 vote143 views2 answers
What is composer in laravel
PHP
0 vote134 views2 answers
Php replace all text from string with associate array values
PHP
8 votes129 views1 answer
Laravel link storage to public
PHP Laravel
3 votes217 views3 answers
Wordpress notice
PHP
0 vote139 views1 answer
Get romawi number php
PHP
29 votes148 views6 answers
Where like laravel
PHP Laravel
12 votes122 views4 answers
Php timestamp to seconds
PHP