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

16 votes306 views6 answers
Console log in php
PHP
1 vote291 views2 answers
Laravel eloquent with query extra parameter
PHP
3 votes335 views2 answers
Php ellipsis
PHP
2 votes299 views1 answer
Php migrate comand
PHP
1 vote322 views2 answers
Remove All Spaces Out of a String in PHP
PHP
13 votes413 views2 answers
Wp get logged in user id
PHP Wordpress
0 vote393 views1 answer
Post type taxonomy loop wordpress
PHP Wordpress
32 votes294 views2 answers
How add new column in larevel with migration
PHP
1 vote354 views1 answer
The token has been blacklisted laravel jwt
PHP Laravel
1 vote286 views1 answer
How handle the number with k in laravel balde
PHP