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

3 votes356 views4 answers
Laravel cors enable
PHP Laravel
3 votes300 views3 answers
Clear laravel.log
PHP
3 votes323 views2 answers
Laravel first or fail
PHP Laravel
1 vote332 views1 answer
Docx file validation laravel 8
PHP
0 vote334 views1 answer
Php check if variable is resource
PHP
5 votes364 views3 answers
Wordpress get_permalink
PHP Wordpress
0 vote327 views1 answer
Give @s potion off weekness
PHP
1 vote301 views2 answers
Php get class name without namespace from string
PHP
0 vote305 views1 answer
Remove % sign from string php
PHP
0 vote316 views2 answers
Laravel livewire-datatable delete column pop up issue
PHP