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 vote315 views1 answer
Laravel check if form has errors
PHP Laravel
0 vote283 views1 answer
Php foreach alternative syntax
PHP
-1 vote254 views2 answers
Toast in php
PHP
-1 vote278 views1 answer
Php get error
PHP
0 vote300 views1 answer
Laravel reroute 419
PHP Laravel
0 vote272 views1 answer
Artisan command on live server
PHP
0 vote243 views1 answer
Add class to row laravel
PHP
1 vote267 views1 answer
SQLSTATE[HY000]: General error: 1005 Can't create table ``.`labels` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table `labels` add constraint
PHP
0 vote297 views2 answers
Laravel eloquent without relation
PHP
2 votes253 views3 answers
Laravel web php request to redirect to another page
PHP