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

2 votes220 views1 answer
Laravel Call to a member function diffForHumans() on string
PHP Laravel
0 vote183 views3 answers
Php command get ini params
PHP
0 vote270 views1 answer
Get the current datetime in php when button is clicked
PHP
18 votes193 views6 answers
Laravel routes
PHP
0 vote228 views1 answer
Laravelda cortollerga keladigan zaproslarni cheklash
PHP
0 vote188 views1 answer
Push to aws instance ssh without using laravel
PHP
0 vote262 views1 answer
Magento2 set session timeout cia cli
PHP
0 vote226 views1 answer
Add to cart, link to product page
PHP
0 vote213 views3 answers
Laravel query builder get last insert id
PHP
1 vote310 views4 answers
Laravel create multiple rows
PHP Laravel