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 vote119 views1 answer
Check php-fpm version ubuntu
PHP
0 vote126 views1 answer
See all php version debian
PHP
1 vote135 views1 answer
Merge two objects in php
PHP
0 vote128 views2 answers
Php round nearest half
PHP
1 vote153 views2 answers
Use multiple database in laravel
PHP Laravel
7 votes180 views6 answers
Laravel loop index
PHP Laravel
7 votes121 views3 answers
Php combine values of two arrays
PHP
0 vote134 views2 answers
Get custom post type taxonomy value
PHP
0 vote131 views1 answer
PHP: Count a stdClass object
PHP
2 votes131 views1 answer
Php pow
PHP