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

7 votes269 views4 answers
Many to many relationship laravel
PHP Laravel
0 vote262 views1 answer
Comment supprimer les avis sur les produits de votre boutique WooCommerce
PHP
3 votes205 views1 answer
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add index `users_userable_type_userable_id_index`(`userable_type`, `userable_id`)
PHP
1 vote314 views1 answer
Laravel profile migration tool
PHP Laravel
0 vote225 views2 answers
Dd php
PHP
2 votes210 views1 answer
Php see if undefined
PHP
0 vote224 views1 answer
Laravel query with optional filter
PHP
5 votes265 views2 answers
Php count array elements with specific key
PHP
8 votes256 views6 answers
Wordpress error log
PHP Wordpress
3 votes226 views2 answers
Laravel collection find duplicates
PHP Laravel