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 vote285 views0 answer
PHP
0 vote351 views1 answer
Reset internal pointer mysql query
PHP
0 vote320 views1 answer
Object of class stdclass could not be converted to string php laravel
PHP
1 vote430 views2 answers
Laravel request all except
PHP
121 votes569 views6 answers
Check if a String Contains a Substring in PHP
PHP
0 vote337 views1 answer
Recuperer des informations d'une table parent en sql
PHP
0 vote378 views1 answer
Wordpress get particular page content programmatically
PHP
9 votes321 views3 answers
Laravel image validation
PHP
0 vote364 views1 answer
Php set timezone italy
PHP
0 vote328 views1 answer
Set null on foreign key deletion in laravel
PHP