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

7 votes182 views2 answers
Laravel seeder with relationships
PHP
9 votes153 views3 answers
Pass variable to blade laravel
PHP
3 votes271 views2 answers
Two condition in one laravel query
PHP Laravel
0 vote254 views1 answer
Yii2 modules commands are not showing in console
PHP Yii
0 vote181 views2 answers
Symfony get query param
PHP Symfony
0 vote185 views1 answer
Tinyinteger laravel +size
PHP Laravel
9 votes164 views3 answers
Image validate in laravel validater
PHP Laravel
0 vote142 views1 answer
Wp-config.php repair
PHP
0 vote152 views1 answer
Laravel withcount change name
PHP Laravel
13 votes134 views4 answers
Write in a file using php
PHP