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 vote299 views1 answer
How to use custome functions in laravel
PHP
0 vote295 views1 answer
Php compare strings case insensitive
PHP
0 vote328 views1 answer
Php hash list
PHP
1 vote274 views1 answer
Highlight search text in php
PHP
15 votes393 views2 answers
Php get type of object
PHP
1 vote334 views2 answers
How to delete image from aws using laravel 8
PHP Laravel
0 vote276 views1 answer
Check value falls between in two range in php
PHP
1 vote338 views3 answers
Laravel function to check if image exist or not
PHP Laravel
0 vote361 views1 answer
Laravel - access file from storage path - alternative to symlink
PHP Laravel
0 vote295 views1 answer
Controller class does not exist laravel
PHP