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 vote186 views1 answer
Mac os down upgrade php version
PHP
0 vote205 views1 answer
Order table in laravel
PHP
1 vote191 views1 answer
Php echo and array to consle
PHP
0 vote180 views1 answer
Php get file created date
PHP
35 votes194 views6 answers
Laravel make auth
PHP
0 vote606 views1 answer
Failed opening required 'PHPMailer\PHPMailer\PHPMailer'
PHP
0 vote230 views1 answer
Last page url in php laravel
PHP Laravel
0 vote184 views1 answer
Laravel Http client retry request if fail
PHP
0 vote182 views1 answer
What does defined do in php
PHP
0 vote181 views2 answers
Old codestar text field
PHP