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

62 votes237 views5 answers
Convert string to int php 7
PHP
2 votes259 views2 answers
Increase memory laravel controller
PHP Laravel
0 vote203 views1 answer
Call a blade from a blade in laravel 8
PHP
0 vote255 views1 answer
Italic text in laravel notification
PHP Laravel
0 vote208 views1 answer
How assign current date to input type date html in php
PHP
0 vote200 views1 answer
Open a file in a new window phpstorm
PHP
22 votes257 views6 answers
Php artisan make:auth laravel 8
PHP Laravel
8 votes255 views4 answers
Laravel unique validation on multiple columns
PHP
0 vote212 views1 answer
Nova resource title function
PHP
2 votes225 views1 answer
Set session after login with laravel
PHP