Pdo prepare

<?php
/* Execute a prepared statement by passing an array of values */
$sql = 'SELECT name, colour, calories
    FROM fruit
    WHERE calories < :calories AND colour = :colour';
$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute(array(':calories' => 150, ':colour' => 'red'));
$red = $sth->fetchAll();
$sth->execute(array(':calories' => 175, ':colour' => 'yellow'));
$yellow = $sth->fetchAll();
?>

Source: php.net

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 vote209 views1 answer
Laravel model increase the value by one
PHP Laravel
11 votes178 views4 answers
Php str starts with
PHP
19 votes167 views5 answers
Php artisan auth in laravel 8
PHP
0 vote219 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP Laravel
1 vote194 views2 answers
How to get data from a table in laravel
PHP
3 votes185 views3 answers
Php stdclass to array
PHP
0 vote162 views1 answer
Enqueue WP scripts and styles from a single action hook.
PHP
1 vote187 views3 answers
Required_if laravel
PHP
-2 votes160 views1 answer
Export html table data to excel in php
PHP
0 vote181 views1 answer
Mr deepfakes forum
PHP