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 vote175 views1 answer
Strtotime laravel
PHP
0 vote176 views1 answer
How to exclude csrf in a route laravel
PHP
3 votes175 views2 answers
How to get category from post id
PHP
0 vote230 views1 answer
Php get header language
PHP
0 vote215 views5 answers
How to validate phone number in php procedural programming
PHP
1 vote181 views3 answers
Php check if some string contains from array
PHP
1 vote147 views1 answer
Php word wrap
PHP
0 vote299 views1 answer
Format uang rupiah di php
PHP
0 vote201 views1 answer
Create fake users on click laravel
PHP
1 vote669 views1 answer
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql.so'
PHP