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 vote345 views1 answer
If home else php wordpress
PHP Wordpress
0 vote306 views1 answer
Php error check
PHP
0 vote304 views1 answer
Remove controller cache laravel
PHP
2 votes342 views2 answers
Laravel blade auth check
PHP Laravel
0 vote327 views1 answer
Hide my echo from page php
PHP
109 votes537 views6 answers
Add array to array php
PHP
0 vote312 views1 answer
Convert stdclass to json in php
PHP
2 votes324 views3 answers
Create new user fortify action how it work laravel 8
PHP
7 votes310 views3 answers
How to remove public from url in laravel 8
PHP
0 vote261 views1 answer
Acf get all checkbox options
PHP