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

2 votes103 views2 answers
Symfony schema update
PHP
0 vote161 views1 answer
Double where condition in laravel
PHP
0 vote107 views1 answer
Get deleted value laravel
PHP
0 vote112 views1 answer
Laravel eloquent only today
PHP
9 votes115 views3 answers
Make controller laravel 8 with resource
PHP Laravel
0 vote116 views1 answer
Laravel database engine innodb
PHP Laravel
0 vote112 views1 answer
Laravel datatable columnDefs
PHP Laravel
0 vote103 views1 answer
Add class to row laravel
PHP
2 votes108 views3 answers
How to get a whole number from decimal in php
PHP
3 votes110 views1 answer
Column not found: 1054 Unknown column 'updated_at'
PHP