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 vote172 views1 answer
If file is not selected in file input type php
PHP
5 votes189 views2 answers
A non well formed numeric value encountered laravel
PHP Laravel
3 votes171 views3 answers
Php remove duplicates from string
PHP
1 vote168 views1 answer
Recursive function in php
PHP
0 vote162 views1 answer
Codeigniter form validation datetime
PHP
0 vote203 views2 answers
Reload page laravel
PHP Laravel
1 vote219 views1 answer
$posts- links() laravel design error
PHP Laravel
0 vote163 views2 answers
Php radians to degrees
PHP
0 vote176 views2 answers
Image upload in cake 2
PHP
0 vote174 views1 answer
Strpos() expects parameter 1 to be string, object given
PHP