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 vote174 views1 answer
Register sidebar wordpress
PHP
0 vote189 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel
1 vote273 views1 answer
Laravel profile migration tool
PHP Laravel
0 vote124 views1 answer
Symony type request
PHP
2 votes162 views1 answer
Php filter only numbers
PHP
0 vote190 views1 answer
Laravel flutter save image in data
PHP Laravel
0 vote175 views1 answer
Setup phpmyadmin to show create statement query
PHP
0 vote174 views1 answer
Mysql_fetch_array php
PHP
0 vote198 views1 answer
Laravel DB facade relations
PHP Laravel
0 vote221 views1 answer
Laravel collection min
PHP