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 vote133 views1 answer
Php session get data
PHP
0 vote133 views1 answer
Php send 204
PHP
0 vote121 views1 answer
Twig\Error\SyntaxError: Unknown "file_uri" function. Did you mean "file_url"?
PHP
-2 votes124 views3 answers
Centos update php 7 to php 8
PHP
3 votes130 views1 answer
How to modify a string that’s passed by reference in php
PHP
2 votes169 views2 answers
Laravel blade auth check
PHP Laravel
12 votes137 views6 answers
Run seeder in migration laravel
PHP
7 votes128 views2 answers
Reset wordpress password in database
PHP
11 votes141 views6 answers
Table laravel
PHP
0 vote123 views2 answers
Php form detect if number has decimals
PHP