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

85 votes229 views6 answers
Php replace string
PHP
2 votes269 views1 answer
Laravel generate env
PHP Laravel
0 vote202 views1 answer
Seeder name singular or plural laravel
PHP
2 votes200 views2 answers
Laravel dropIndex
PHP
1 vote237 views5 answers
Laravel eloquent batch insert
PHP Laravel
1 vote247 views1 answer
Wordpress escape string
PHP Wordpress
0 vote203 views1 answer
Php build query from array
PHP
0 vote202 views4 answers
Genrate Random Integer 10 digits in php
PHP
0 vote253 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
0 vote214 views1 answer
$name = $name; "Robert" echo;
PHP