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 vote168 views1 answer
How to save data from api to laravel
PHP
0 vote216 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP Laravel
0 vote224 views1 answer
Check current pages is a child page wordpress
PHP Wordpress
9 votes230 views6 answers
 Notice: Undefined variable: username in G:\xampp\htdocs\Online Class Platform\students_register.php on line 166 
PHP
0 vote178 views2 answers
Sorry, This File Type Is Not Permitted for Security Reasons
PHP
1 vote247 views1 answer
Xdebug won't step over in phpstorm
PHP
1 vote295 views2 answers
Laravel 8 selecet the 2nd to the last record
PHP Laravel
1 vote183 views1 answer
Get DAYS absent from working days from given date range
PHP
0 vote225 views1 answer
Simplesaml php logout
PHP
6 votes205 views1 answer
Laravel Route::group definition
PHP Laravel