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

5 votes151 views4 answers
Wordpress get plugin root directory
PHP Wordpress
0 vote163 views1 answer
How to run database Query in WordPress?
PHP Wordpress
0 vote167 views1 answer
Laravel count soft delete data
PHP Laravel
1 vote146 views1 answer
Install tymon jwt laravel
PHP
0 vote195 views1 answer
Get upload error codeigniter
PHP CodeIgniter
0 vote155 views1 answer
Create a exporter in laravel command
PHP
0 vote152 views1 answer
Post with count greater than 1 laravel
PHP
0 vote182 views1 answer
Use font awesome in laravel 8
PHP Laravel
1 vote166 views1 answer
Moodle webservice create user phone2
PHP
5 votes133 views3 answers
Laravel model limit
PHP