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 vote403 views1 answer
Codeigniter how to know update failed
PHP CodeIgniter
0 vote308 views1 answer
Call to undefined function App\Models\str_slug()
PHP
0 vote287 views1 answer
Download html table to excel
PHP
1 vote313 views1 answer
Base64 encode username password php example
PHP
1 vote293 views2 answers
Array_unique multidimensional php
PHP
0 vote361 views2 answers
Php get html with special characters
PHP
22 votes324 views6 answers
Php artisan make:auth laravel 8
PHP Laravel
7 votes310 views2 answers
Laravel carbon get month number
PHP
0 vote282 views1 answer
Nova resource title function
PHP
0 vote319 views1 answer
/usr/local/bin/php /home/tbmholdingltd/public_html/tugent/php artisan schedule:run >> /dev/null 2>&1
PHP