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

0 vote315 views1 answer
Getting the closest string match using php
PHP
0 vote344 views1 answer
Provenienza geografica di un utente php webmaster
PHP
2 votes327 views1 answer
Cmd run powershell command
PHP
1 vote338 views1 answer
Laravel unique title except id on edit
PHP Laravel
0 vote371 views2 answers
Mixed Content heroku laravel
PHP Laravel
0 vote343 views1 answer
Php select disable submit no value
PHP
0 vote326 views2 answers
How to get just the first row from a table in laravel
PHP
2 votes358 views1 answer
Laravel delete confirm link
PHP Laravel
0 vote316 views1 answer
Curl error (code 3) url malformed laravel
PHP
7 votes391 views3 answers
Call table name in model laravel
PHP Laravel