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 vote182 views1 answer
CausesActivity trait
PHP
8 votes330 views5 answers
Codeigniter 4 redirect with data
PHP CodeIgniter
0 vote196 views1 answer
Php get first digit of number
PHP
0 vote175 views1 answer
Composer Fatal error: Call to undefined function Symfony\Polyfill\Mbstring\iconv() in phar
PHP
5 votes204 views5 answers
Unique laravel migration
PHP
0 vote217 views2 answers
Laravel file path
PHP Laravel
-1 vote188 views1 answer
Php csv to array with headers
PHP
5 votes176 views3 answers
Mobile number validation in laravel 8
PHP
0 vote189 views1 answer
Excel date format in php
PHP
2 votes275 views3 answers
Get custom field
PHP