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 vote182 views1 answer
Magento 2 laravel valet 502 bad gateway
PHP Laravel
0 vote193 views1 answer
Laravel where search like with space
PHP Laravel
6 votes164 views6 answers
Php mysql connection
PHP
0 vote159 views1 answer
How do I test a website using XAMPP?
PHP
6 votes171 views1 answer
Laravel Route::group definition
PHP
5 votes174 views3 answers
Laravel permission denied storage log
PHP Laravel
0 vote157 views1 answer
Php array_diff_assoc
PHP
0 vote157 views1 answer
Php json pretty print and slash
PHP
0 vote174 views1 answer
Small echo php
PHP
4 votes217 views4 answers
Raw queries in laravel
PHP Laravel