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 vote406 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP Laravel
2 votes344 views1 answer
Proper permission webserver laravel
PHP
1 vote325 views2 answers
Array unicode php
PHP
0 vote376 views1 answer
H1 wordpress theme php
PHP Wordpress
0 vote387 views1 answer
Sass download for windows
PHP
4 votes316 views2 answers
Date_default_timezone_set for india in php
PHP
3 votes330 views2 answers
Smarty assign var
PHP
0 vote310 views1 answer
How to add a clock in laravel
PHP
0 vote333 views1 answer
Laravel array length
PHP
0 vote276 views2 answers
Pluck only category name and id from model in laravel
PHP