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

28 votes294 views12 answers
Laravel middleware
PHP Laravel
2 votes383 views1 answer
Php array order by date
PHP
1 vote433 views1 answer
Not required a field when checked not applicable checkbox in laravel
PHP Laravel
0 vote348 views1 answer
Laravel eloquent return array where
PHP Laravel
20 votes318 views5 answers
Php convert string to json
PHP
1 vote349 views1 answer
Teruglopende for loop php
PHP
0 vote335 views1 answer
Php curl pass user:password
PHP
0 vote294 views1 answer
Laravel array cast
PHP
0 vote383 views1 answer
Laravel create new file if not exists
PHP Laravel
2 votes315 views2 answers
Shuffle php function
PHP