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 vote161 views1 answer
Php check if cli
PHP
0 vote196 views1 answer
Php clean all output buffers
PHP
0 vote168 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP
0 vote170 views1 answer
Search query codeigniter
PHP
4 votes178 views2 answers
Laravel migration table column nullable
PHP
0 vote198 views1 answer
Add to cart, link to product page
PHP
0 vote171 views2 answers
Php xml to json
PHP
0 vote182 views1 answer
Multi line dot match php
PHP
3 votes229 views1 answer
Laravel check if environment is production
PHP Laravel
7 votes216 views6 answers
Unique validation on update laravel
PHP Laravel