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

7 votes193 views5 answers
Codeigniter get last query
PHP CodeIgniter
44 votes96 views6 answers
Php array size
PHP
0 vote128 views1 answer
Run new oroject laravel with idff port
PHP Laravel
0 vote98 views1 answer
Media library laravel maximum allowed size
PHP
23 votes106 views6 answers
Laravel logs
PHP Laravel
5 votes111 views6 answers
Array to string conversion php
PHP
1 vote121 views1 answer
Get random posts wordpress
PHP
2 votes62 views2 answers
Laravel dump
PHP Laravel
0 vote99 views2 answers
Php mysql update all rows in table random values
PHP
0 vote94 views1 answer
Php expire session for 1 month
PHP