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

1 vote286 views1 answer
Maximum execution time of 60 seconds exceeded laravel 8
PHP Laravel
23 votes275 views6 answers
Laravel model insert
PHP Laravel
0 vote305 views1 answer
Laravel belongstomany prevent duplicates attach
PHP Laravel
29 votes297 views3 answers
Laravel clear page cache
PHP Laravel
5 votes261 views4 answers
Php echo arry
PHP
0 vote251 views1 answer
String date less than now php
PHP
0 vote289 views1 answer
Laravel on cascade set null
PHP Laravel
0 vote389 views1 answer
Définir un nombre maximum de mots sur les titres des publications WordPress
PHP Wordpress
0 vote231 views1 answer
Laravel touches
PHP
6 votes242 views2 answers
When will betelgeuse explode
PHP