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 vote176 views1 answer
TreeBuilder::getRootNode()" before creating the root node is not supported, migrate to the new constructor signature instead.
PHP
0 vote205 views1 answer
Php pass variable to anonymous function
PHP
3 votes220 views2 answers
Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.
PHP
63 votes187 views6 answers
Clear all cache in laravel
PHP
0 vote198 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP Laravel
5 votes208 views3 answers
Home url wordpress
PHP Wordpress
0 vote176 views1 answer
Php huruf besar di awal
PHP
0 vote172 views1 answer
Trim specific character from strin using php
PHP
0 vote185 views1 answer
Reindex array php
PHP
0 vote316 views1 answer
Echo require php
PHP