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 vote100 views1 answer
Display rows brought back by query php
PHP
0 vote126 views1 answer
Laravel adding new items to config run time
PHP Laravel
12 votes115 views4 answers
Laravel return redirect to named route
PHP
3 votes143 views2 answers
Max execution time exceeded php
PHP
29 votes102 views4 answers
Php else
PHP
-1 vote141 views1 answer
Laravel edit form select don't repeat a selected value
PHP Laravel
0 vote102 views1 answer
Alias wipedb='php artisan db:wipe'
PHP
7 votes139 views6 answers
Laravel loop index
PHP Laravel
10 votes119 views4 answers
Laravel table data types
PHP Laravel
0 vote116 views1 answer
Ajax pagination with search and filter in php
PHP