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 vote218 views1 answer
Array to strng sepreated by comma
PHP
3 votes294 views2 answers
What is the use of migration file in laravel
PHP
1 vote268 views1 answer
Assign php array into javascript
PHP
0 vote271 views1 answer
Php composer copy library to public vendor folder
PHP
1 vote290 views1 answer
Htaccess cakephp
PHP
0 vote276 views1 answer
Php check if query succeeded
PHP
0 vote291 views1 answer
Get object tyhpe php
PHP
0 vote310 views1 answer
String length laravel validation
PHP Laravel
1 vote364 views1 answer
Break and continue in laravel
PHP Laravel
8 votes274 views3 answers
What is route namespace in laravel
PHP