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 vote108 views1 answer
Lumen redirect in controller
PHP
1 vote69 views1 answer
Woocommerce search form <?php get_search_form(); ?>
PHP
34 votes116 views6 answers
Format date in php
PHP
2 votes117 views1 answer
Return back in blade laravel
PHP
4 votes123 views2 answers
Signup API in laravel
PHP Laravel
13 votes320 views5 answers
Laravel add item to array
PHP Laravel
0 vote124 views1 answer
Php mktemp
PHP
0 vote114 views1 answer
Last item coma replace and php
PHP
0 vote117 views1 answer
Laravel redirect to previous page
PHP
-1 vote110 views2 answers
Wordpress https too many redirects
PHP Wordpress