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

7 votes231 views3 answers
Wordpress get date of post
PHP Wordpress
1 vote203 views2 answers
Remove product from cart by id woocommerce
PHP
1 vote178 views4 answers
Where('created_at', '=', date('Y-m-d'));
PHP
7 votes214 views4 answers
Laravel blade uppercase
PHP Laravel
0 vote227 views1 answer
Check session php
PHP
3 votes184 views1 answer
Carbon parse subday
PHP
9 votes182 views2 answers
Json_encode()
PHP
0 vote224 views1 answer
Php storm can't write
PHP
1 vote184 views1 answer
Copy php array to javascript
PHP
10 votes263 views4 answers
Laravel table data types
PHP Laravel