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 votes136 views3 answers
Laravel where closure
PHP Laravel
1 vote150 views1 answer
Define("ROOT PATH", __DIR__);
PHP
0 vote235 views1 answer
Laravel db query log string replacements
PHP
0 vote149 views1 answer
Not get child all data in relationship with parent laravel eloquent
PHP Laravel
1 vote91 views1 answer
Laravel request integer
PHP
18 votes141 views6 answers
Laravel carbon create date from string
PHP Laravel
0 vote140 views1 answer
Import class route laravel
PHP Laravel
0 vote151 views1 answer
Install php-8
PHP
3 votes120 views3 answers
Check input value is integer or not in php
PHP
0 vote153 views1 answer
Php versions and features
PHP