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

4 votes183 views3 answers
Composer detected issues in your platform: your composer dependencies require the following php extensions to be installed: xml
PHP
0 vote187 views3 answers
How to convert youtube url to embed code in php
PHP
1 vote181 views2 answers
Url segment in laravel
PHP
0 vote189 views1 answer
Running a laravel app locally
PHP
52 votes225 views6 answers
Php redirect
PHP
1 vote186 views2 answers
Yii1 set flash
PHP
0 vote170 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP
7 votes200 views4 answers
Max_execution_time php
PHP
0 vote185 views1 answer
The requested url was not found on this server. apache/2.4.46 (win64) openssl/1.1.1h php/8.0.1 server at localhost port 80
PHP
0 vote181 views1 answer
Php extract email address from string
PHP