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

1 vote203 views4 answers
Codeigniter where_not_in
PHP CodeIgniter
3 votes158 views1 answer
Laravel mail and sms system
PHP Laravel
2 votes141 views3 answers
Multiple primary key defined laravel
PHP
0 vote138 views1 answer
Delete an array in multidimensional array php
PHP
21 votes146 views3 answers
Php delete array item by value
PHP
0 vote150 views1 answer
Joomla redirect
PHP
0 vote143 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP
0 vote161 views1 answer
Get data from stdclass object php
PHP
0 vote140 views1 answer
Php forbidden header
PHP
95 votes202 views6 answers
String to array php
PHP