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 vote377 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP Laravel
0 vote351 views1 answer
If condition view page of laravel
PHP Laravel
0 vote310 views2 answers
Mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
PHP
3 votes316 views3 answers
Blade capitalize first letter
PHP
0 vote317 views3 answers
Laravel how to fetch user from user model based on id from post
PHP Laravel
0 vote341 views1 answer
Editing items in collection in laravel 8
PHP Laravel
0 vote315 views1 answer
Small echo php
PHP
48 votes422 views6 answers
Laravel joins
PHP Laravel
4 votes341 views2 answers
Laravel eloquent sum column
PHP
0 vote357 views1 answer
Saber value ao escolher combobox php
PHP