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 vote243 views1 answer
Advanced Custom Fields get sub field image
PHP
2 votes248 views1 answer
Laravel clear everything
PHP
3 votes302 views5 answers
Laravel set env to production
PHP Laravel
0 vote249 views2 answers
If condition in laravel blade in select option
PHP
0 vote263 views1 answer
Filter child table data from parent laravel eloquent
PHP Laravel
0 vote256 views1 answer
Laravel get query in normal sql without bindings
PHP
2 votes315 views1 answer
Get name custom post type wordpress
PHP
0 vote254 views1 answer
Php header x-powered-by
PHP
19 votes230 views6 answers
Laravel 8 make model with migration and controller
PHP
1 vote286 views1 answer
Laravel child relation order by desc
PHP Laravel