Pdo bindparam string

<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
    FROM fruit
    WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>

Source: php.net

Similar codes

0 vote330 views1 answer
Joomla redirect
PHP
0 vote367 views1 answer
Executer page php via boutton
PHP
1 vote400 views1 answer
Lumen jwt
PHP
2 votes306 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP
0 vote328 views2 answers
Check if $_files is empty php
PHP
8 votes308 views2 answers
Php get class name of this
PHP
0 vote323 views1 answer
Laravel sintax
PHP Laravel
0 vote430 views3 answers
In packagemanifest.php line 131 undefined index name
PHP
0 vote312 views1 answer
PHP-Like-System-with-Notification-using-Ajax-Jquery
PHP
0 vote365 views1 answer
How to excluse csrf in a route laravel
PHP Laravel