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

2 votes177 views1 answer
Is php still used
PHP
0 vote196 views1 answer
Php geolocation package
PHP
1 vote179 views1 answer
Mysqli_query insert in laravel
PHP
1 vote193 views3 answers
Create new laravel project with specific version
PHP Laravel
0 vote187 views1 answer
Checks whether the session is set or not, if not it will redirect the user to login page.
PHP
0 vote219 views1 answer
Laravel pass multipale provider
PHP
1 vote189 views1 answer
MySQL phpMyAdmin with Google Chrome: stuck on loading
PHP
3 votes184 views6 answers
Convertir datetime a string en php
PHP
0 vote223 views2 answers
Php regex non printable characters
PHP
3 votes234 views1 answer
Check file size validation laravel
PHP