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

1 vote193 views2 answers
Laravel collection
PHP
1 vote245 views3 answers
Function default value
PHP
0 vote227 views1 answer
Désinfecte email php
PHP
-1 vote250 views2 answers
Restart php windows
PHP
1 vote240 views5 answers
Laravel collection methods
PHP Laravel
0 vote236 views1 answer
If condtion in varibale value how to change in loop in php
PHP
0 vote315 views1 answer
Wordpress loop over posts but exclude current post
PHP Wordpress
9 votes234 views3 answers
Prepend 0 to number php
PHP
0 vote260 views1 answer
Laravel request img
PHP Laravel
2 votes220 views2 answers
Php file_get_contents follow redirect
PHP