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 vote160 views1 answer
Laravel eloquent many to many query using whereHas
PHP
4 votes178 views2 answers
Laravel pass variables to view
PHP Laravel
0 vote167 views1 answer
Woocommerce change sale text
PHP
0 vote146 views1 answer
Php mail in localhost wamp
PHP
1 vote190 views1 answer
How to add title to wordpress php
PHP Wordpress
12 votes175 views6 answers
Return redirect with message laravel
PHP Laravel
2 votes171 views2 answers
Update laravel 7 to 8
PHP Laravel
7 votes162 views2 answers
Artisan in route in laravel
PHP
0 vote157 views1 answer
How to find number between different ranges in php
PHP
0 vote147 views1 answer
Php date fomat
PHP