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

13 votes165 views6 answers
How to create model in laravel
PHP Laravel
0 vote124 views1 answer
Method 'App\Exports\TarefasExport::headings()' is not compatible with method
PHP
6 votes150 views4 answers
Laravel blade foreach index value
PHP
1 vote132 views1 answer
Laravel plural
PHP
0 vote130 views1 answer
Cakephp 4 authentication
PHP
34 votes140 views6 answers
Php random number generator
PHP
0 vote139 views1 answer
Php afosto / yaac urn:ietf:params:acme:error:malformed 405
PHP
0 vote169 views1 answer
Laravel blade all syntex description
PHP
8 votes147 views3 answers
Create migration with model laravel 8
PHP Laravel
3 votes156 views1 answer
Convert base64 string to pdf in php
PHP