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

9 votes116 views4 answers
Mage log equivalent magento 2
PHP
0 vote111 views3 answers
Not Found The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/8.0.6 Server at localhost Port 80
PHP
0 vote122 views2 answers
What is composer in laravel
PHP Laravel
0 vote106 views1 answer
Gerar aquivo csv php
PHP
0 vote112 views1 answer
Displaying all table names in php from MySQL database
PHP
2 votes120 views2 answers
Php redirect seconds
PHP
0 vote108 views1 answer
Check null in laravel blade
PHP
0 vote103 views3 answers
Laravel disable Logging
PHP
15 votes75 views10 answers
Laravel pagination
PHP
0 vote133 views1 answer
Laravel Facades\DB update
PHP Laravel