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 vote255 views1 answer
Php date with out 0
PHP
28 votes254 views5 answers
Laravel whereRaw
PHP
0 vote252 views1 answer
Class 'Spatie\YamlFrontMatter\YamlFrontMatter' not found
PHP
2 votes344 views1 answer
Wordpress get post time
PHP Wordpress
0 vote317 views1 answer
Comment installer laravel avec docker
PHP Laravel
0 vote259 views1 answer
Double where condition in laravel
PHP
0 vote304 views1 answer
Check laravel first null
PHP Laravel
0 vote270 views1 answer
Return last inserted id mysql opencart
PHP
0 vote262 views1 answer
How to select and deselect all items without use name in laravel
PHP
6 votes245 views5 answers
How to create object in php
PHP