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

28 votes215 views6 answers
Laravel change column type
PHP Laravel
6 votes197 views2 answers
Generate application key laravel
PHP
9 votes201 views6 answers
Laravel 8 date format
PHP
0 vote189 views1 answer
Laravel get current action name
PHP Laravel
0 vote205 views2 answers
Laravel collection search
PHP Laravel
0 vote152 views1 answer
Get url parameter laravel 5.2 constructor
PHP
0 vote216 views1 answer
Token delete laravel
PHP Laravel
8 votes178 views3 answers
Serve in localhost using php
PHP
0 vote194 views1 answer
Quiz
PHP
1 vote156 views2 answers
Laravel log to console
PHP