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 vote314 views2 answers
Php number format 2 decimal no comma
PHP
2 votes313 views2 answers
Laravel validation if data exists
PHP Laravel
10 votes268 views1 answer
Gmdate in php
PHP
2 votes251 views1 answer
Laravel carbon human readable
PHP
0 vote304 views1 answer
The Process class relies on proc_open, which is not available on your PHP installation cpanel
PHP
1 vote253 views4 answers
Laravel create multiple rows
PHP
0 vote260 views1 answer
Php include external directory path
PHP
0 vote273 views1 answer
An expression was expected phpmyadmin
PHP
0 vote286 views1 answer
Add auth middleware to route laravel
PHP Laravel
4 votes251 views2 answers
Date_default_timezone_set for india in php laravel
PHP