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

-1 vote355 views4 answers
Laravel create command tutorial
PHP
0 vote346 views1 answer
Laravel validation get failed rules
PHP Laravel
14 votes361 views3 answers
Convert number to 2 decimal places in php
PHP
0 vote335 views1 answer
Provide difference between interface and abstract class php
PHP
0 vote279 views0 answer
PHP
1 vote337 views1 answer
Laravel migration add datetime column with default
PHP
3 votes366 views2 answers
Wordpress loop permalink
PHP Wordpress
8 votes385 views3 answers
Create migration with model laravel 8
PHP Laravel
0 vote349 views1 answer
Laravel array to string error
PHP Laravel
0 vote399 views1 answer
How use same method in another class in laravel
PHP Laravel