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 vote158 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel
0 vote173 views1 answer
Php echo "<style>" posts css text
PHP
0 vote156 views1 answer
Wp table with hostname setup
PHP Wordpress
0 vote93 views1 answer
Laravel: Session message exist while click on browser back button
PHP
0 vote170 views1 answer
Laravel db ssh
PHP Laravel
0 vote162 views1 answer
Object of class Illuminate\\Database\\Eloquent\\Builder could not be converted to string
PHP
0 vote134 views1 answer
Back end
PHP
0 vote137 views2 answers
Laravel collection every
PHP
1 vote155 views2 answers
Displaying variables in blade laravel
PHP
2 votes136 views2 answers
Link to another page php
PHP