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 vote282 views1 answer
Php howto
PHP
5 votes286 views2 answers
Laravel group by with where clause
PHP
0 vote258 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP
0 vote267 views1 answer
Blade check user role laravel
PHP
0 vote355 views1 answer
Latavel attach method
PHP
5 votes279 views4 answers
Php get time in milliseconds
PHP
1 vote271 views1 answer
Invalid datetime format 1292
PHP
0 vote318 views2 answers
DB::raw update query in laravel
PHP
2 votes315 views1 answer
Laravel delete relationship data
PHP Laravel
0 vote274 views1 answer
Php reload after env
PHP