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 vote146 views1 answer
Laravel vendor publish all files
PHP Laravel
0 vote135 views2 answers
Laravel allow all fillable
PHP Laravel
5 votes137 views2 answers
Refresh a specific migration laravel
PHP Laravel
1 vote123 views1 answer
Str_ireplace
PHP
0 vote134 views1 answer
Dequeue recaptcha wordpress
PHP
8 votes225 views3 answers
Cakephp 2 with customize link
PHP CakePHP
2 votes166 views1 answer
Laravel difference between current time and created time
PHP Laravel
1 vote135 views1 answer
Convert php array to javascript json laravel
PHP Laravel
9 votes153 views3 answers
Laravel enum migration example
PHP Laravel
0 vote131 views2 answers
Obtener rol de usuario registrado en WordPress
PHP Wordpress