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

8 votes300 views3 answers
Linux delete php sessions
PHP
0 vote291 views1 answer
SQLSTATE[22023]: Invalid parameter value:
PHP
0 vote325 views1 answer
Laravel doesn't work update
PHP Laravel
0 vote306 views1 answer
If home else php wordpress
PHP
5 votes313 views3 answers
Laravel drop column if exists
PHP
0 vote315 views1 answer
Laravel eloquent get x number of results
PHP
0 vote293 views1 answer
How to show login user name in php
PHP
-1 vote280 views1 answer
Laravel orderby with relation
PHP
0 vote297 views1 answer
Php delete json object from a collection object
PHP
20 votes309 views6 answers
Cmd run php file
PHP