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

0 vote143 views1 answer
Laravel 404 not found not showing error
PHP Laravel
0 vote134 views1 answer
Php rounded to the nearest degree time with ms calculator
PHP
3 votes140 views2 answers
Using laravel back function on blade
PHP
0 vote152 views1 answer
Woocommerce default search.php page
PHP
1 vote157 views3 answers
Df
PHP
0 vote114 views1 answer
Tailwindcss - bootstrap - vue - react
PHP
1 vote163 views2 answers
Index the string php
PHP
4 votes177 views3 answers
Delete all records from table using button laravel Eloquent
PHP Laravel
12 votes247 views3 answers
Wordpress embed shortcode in php
PHP Wordpress
0 vote201 views2 answers
Shop page url woocommerce
PHP