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 vote284 views2 answers
Php set 404 page
PHP
3 votes281 views2 answers
Laravel first or fail
PHP
7 votes311 views4 answers
UUIDs LARAVEL
PHP Laravel
3 votes326 views2 answers
How to change laravel port
PHP Laravel
0 vote270 views5 answers
PHP detect spam name
PHP
0 vote275 views1 answer
How to display the responce of curl in php
PHP
28 votes298 views3 answers
Seed date laravel
PHP
0 vote290 views1 answer
Composer remove phpmailer
PHP
3 votes319 views1 answer
How to change add to cart button in wordpress
PHP Wordpress
0 vote259 views1 answer
Wp main menu
PHP