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

7 votes318 views2 answers
Laravel field types from database field type
PHP Laravel
3 votes333 views2 answers
Laravel add values to request
PHP Laravel
1 vote277 views1 answer
Where () mayor que laravel Eloquent
PHP
0 vote307 views1 answer
Ubuntu install lamp and phpmyadmin
PHP
0 vote309 views1 answer
Php retrieve data from database and show in text area greeper
PHP
1 vote334 views1 answer
Disable edit-link storefront
PHP
0 vote326 views1 answer
Wordpress get the main url
PHP
0 vote309 views1 answer
Php if form fails keep data
PHP
2 votes305 views4 answers
Pasar datetime a string php
PHP
0 vote333 views1 answer
Comment acceder à la base de données phpmyadmin sur mac ave
PHP