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

3 votes213 views3 answers
Php pi() function
PHP
0 vote201 views1 answer
Laravel sanctum Provoking tokens
PHP
3 votes234 views1 answer
Print session in laravel
PHP Laravel
13 votes198 views6 answers
Php object example
PHP
0 vote209 views1 answer
The `url` supplied for the path (./nova) repository does not exist
PHP
0 vote197 views2 answers
How to sent request in php
PHP
0 vote244 views2 answers
Fetch data based on month and year in laravel
PHP Laravel
0 vote202 views1 answer
Can we use 2 select in a query laravel
PHP
0 vote212 views1 answer
How to check confirm password in php
PHP
4 votes200 views2 answers
Php regex only numbers
PHP