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

1 vote293 views1 answer
Php artisan services
PHP
0 vote296 views1 answer
Message mkdir() invalid path filename drivers/session_files_driver.php
PHP
0 vote314 views1 answer
Php add element to beginning of associative array
PHP
0 vote269 views1 answer
Yum install php-mysql
PHP
0 vote362 views6 answers
Create symfony project
PHP Symfony
0 vote341 views2 answers
Send email php smtp hostinger
PHP
0 vote319 views1 answer
Get records from Sunday to Sunday laravel
PHP Laravel
1 vote260 views1 answer
Php confirm box
PHP
-1 vote270 views1 answer
Php remove control characters from string
PHP
0 vote305 views2 answers
Sweet alert confirm box laravel
PHP