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 votes188 views1 answer
For loop php continue to next item
PHP
0 vote176 views1 answer
Wordpress disable xmlrpc
PHP
0 vote240 views4 answers
Laravel get last created id
PHP Laravel
0 vote195 views1 answer
Install bcmath php 7.3 ubuntu
PHP
2 votes230 views4 answers
Pasar datetime a string php
PHP
0 vote301 views3 answers
Best wordpress functions to include
PHP
0 vote189 views1 answer
Ci db query error
PHP
1 vote201 views1 answer
Advanced custom field image array
PHP
0 vote231 views1 answer
Target class admin homecontroller does not exist laravel 8
PHP
0 vote221 views1 answer
Laravel migrate test environment
PHP Laravel