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 vote166 views1 answer
Yii1 anchor tag
PHP
9 votes148 views3 answers
Pass variable to blade laravel
PHP
3 votes177 views2 answers
Laravel check if laravel query is empty
PHP
2 votes142 views3 answers
Php change date format from d/m/y to y-m-d
PHP
0 vote143 views3 answers
Br2nl
PHP
0 vote155 views1 answer
Wordpress disable posts
PHP
0 vote182 views1 answer
Get basename without extension Laravel
PHP
33 votes143 views6 answers
Remove array element php
PHP
0 vote144 views1 answer
Laravel relationship retrieve data
PHP
2 votes134 views3 answers
Range in php
PHP