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 vote135 views1 answer
How to pass comma separated value in new line .csv in php\
PHP
4 votes136 views1 answer
Composer is operating significantly slower than normal because you do not have the PHP curl extension enabled
PHP
1 vote128 views3 answers
Laravel eloquent bulk insert
PHP Laravel
0 vote146 views1 answer
Last login date time in wordpress
PHP Wordpress
0 vote120 views1 answer
Php fpm config file location
PHP
0 vote113 views2 answers
Wordpress get post author link
PHP
0 vote131 views1 answer
How to set application key in lumen
PHP
0 vote125 views1 answer
WP_Query
PHP
24 votes149 views6 answers
Laravel get auth user id
PHP Laravel
0 vote224 views2 answers
Yii2 get params from url
PHP Yii