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 vote132 views1 answer
What is the hashmap like in php
PHP
2 votes216 views2 answers
Laravel get random number of data from database
PHP
0 vote138 views1 answer
Wc create new category
PHP
0 vote181 views1 answer
Php array of states in Nigeria
PHP
26 votes154 views4 answers
Where is cache file in laravel
PHP Laravel
12 votes141 views3 answers
How to remove composer package in laravel
PHP
5 votes161 views2 answers
Php count array elements with specific key
PHP
1 vote155 views1 answer
Php optional parameters
PHP
-1 vote109 views1 answer
Quotes api
PHP
0 vote153 views1 answer
Laravel passport generate key
PHP