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

3 votes128 views2 answers
Two condition in one laravel query
PHP
0 vote140 views1 answer
PHP how to skip file upload if file already exist
PHP
-2 votes174 views1 answer
How to append one array to another array in php
PHP
10 votes174 views3 answers
Convert array to json online
PHP
0 vote125 views1 answer
Keep line breaks in textarea
PHP
0 vote137 views1 answer
Autoload_namespaces.php failed to open stream: Permission denied
PHP
6 votes102 views1 answer
Php dynamic property name
PHP
8 votes148 views3 answers
Php join
PHP
0 vote173 views1 answer
Reverse array laravel
PHP Laravel
1 vote135 views3 answers
Php convert to boolean
PHP