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 vote151 views1 answer
Php reset mysql array
PHP
0 vote149 views1 answer
Php unsupported file types
PHP
2 votes152 views2 answers
Laravel pagination with get parameters
PHP Laravel
10 votes156 views2 answers
Same password check in laravel
PHP Laravel
23 votes166 views6 answers
Php echo array
PHP
0 vote162 views2 answers
How to pass bearer token in swagger in laravel
PHP Laravel
0 vote106 views1 answer
Laravel has many insert
PHP Laravel
24 votes130 views4 answers
Laravel query not null
PHP
1 vote153 views1 answer
Laravel select all except some columns
PHP Laravel
2 votes133 views1 answer
How to set field type of date of birth in laravel
PHP