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 vote182 views1 answer
Php monolog
PHP
3 votes301 views2 answers
Two condition in one laravel query
PHP Laravel
0 vote186 views1 answer
Laravel collection flip
PHP Laravel
0 vote150 views2 answers
Update pdo mysql php
PHP
3 votes210 views1 answer
Laravel check if array is empty
PHP Laravel
0 vote186 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP Laravel
33 votes217 views5 answers
Switch case php
PHP
0 vote186 views2 answers
How to Redirect Website to a Mobile Version when Accessed on a Mobile Device
PHP
1 vote155 views1 answer
Missing view cakephp
PHP
1 vote190 views3 answers
Laravel api enable cors
PHP Laravel