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 vote192 views2 answers
Wp include image inside theme folder
PHP
4 votes137 views2 answers
Php slice last arrat
PHP
0 vote156 views1 answer
Link acf
PHP
8 votes143 views2 answers
Laravel drop multiple columns
PHP
0 vote131 views1 answer
Php utc time
PHP
0 vote156 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP Laravel
0 vote150 views1 answer
Messagebird php curl send sms example
PHP
0 vote164 views6 answers
Pass all data to all pages laravel
PHP Laravel
-1 vote146 views2 answers
Random number laravel faker
PHP Laravel
0 vote159 views2 answers
Laravel FileManager Display Blank pop up page
PHP