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

1 vote203 views2 answers
Php bulk insert mysql
PHP
13 votes227 views3 answers
Laravel string
PHP
1 vote213 views2 answers
Laravel collection isNotEmpty
PHP Laravel
0 vote235 views1 answer
Laravel collection average
PHP
3 votes234 views2 answers
Download xampp php 7.3
PHP
0 vote246 views2 answers
Request get query string laravel
PHP
0 vote234 views1 answer
Form validation nullable laravel
PHP
0 vote243 views1 answer
Codeigniter abort 404
PHP CodeIgniter
0 vote242 views1 answer
How to get all the records with same ID in laravel
PHP
21 votes230 views6 answers
Laravel route parameters
PHP Laravel