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 vote100 views1 answer
How to fix Undefined variable: product (View: C:\xampp\htdocs\ecommerce\resources\views\livewire\shop-component.blade.php)
PHP
0 vote98 views1 answer
Php parse url get path
PHP
0 vote95 views1 answer
Distance between two locations in php
PHP
5 votes105 views3 answers
Enum table in laravel
PHP Laravel
0 vote141 views1 answer
How to add multiple images in php
PHP
3 votes98 views2 answers
Clear log file laravel command
PHP
2 votes112 views3 answers
Laravel subdays
PHP Laravel
0 vote117 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel
0 vote113 views1 answer
How to uninstall php 8 in windows 10
PHP
1 vote91 views2 answers
Php curl add user agent
PHP