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 vote288 views1 answer
Save error cakephp 2
PHP CakePHP
0 vote213 views1 answer
Adding data dynamically to empty array in php
PHP
1 vote218 views2 answers
Laravel model set new attribute
PHP
0 vote235 views1 answer
Chart trong laravel
PHP Laravel
29 votes226 views6 answers
Where like laravel
PHP
11 votes255 views3 answers
How to remove composer package in laravel
PHP Laravel
0 vote253 views1 answer
Laravel 7 create-project
PHP Laravel
-1 vote231 views3 answers
Delete rows by migration laravel
PHP Laravel
0 vote218 views3 answers
Laravel - How to create custom configuration variables and access
PHP
0 vote257 views1 answer
Wp automatic-feed-links
PHP Wordpress