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 vote216 views1 answer
How validate if one parameter is exist another parameter must exist in laravel
PHP Laravel
0 vote232 views1 answer
Wordpress get posts by multiple authors
PHP Wordpress
5 votes221 views6 answers
Php get only numbers from string
PHP
0 vote229 views2 answers
Reload page laravel
PHP Laravel
0 vote198 views1 answer
Write if and else in one line laravel
PHP
-1 vote267 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote207 views1 answer
Dequeue recaptcha wordpress
PHP Wordpress
0 vote222 views2 answers
How to back the page laravel where the scorll is
PHP Laravel
0 vote210 views1 answer
Laravel list get x amount in a collection
PHP Laravel
1 vote193 views2 answers
Url segment in laravel
PHP