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 vote264 views1 answer
Call to undefined function App\Http\Controllers\curl_init()
PHP
5 votes294 views2 answers
Php copy
PHP
0 vote278 views2 answers
Php form detect if number has decimals
PHP
7 votes333 views5 answers
Laravel remove public from url
PHP Laravel
1 vote281 views1 answer
Nested resources laravel
PHP
2 votes321 views1 answer
Laravel's collection pagination
PHP Laravel
2 votes288 views1 answer
Php create file if not exist
PHP
10 votes304 views3 answers
Session flush laravel
PHP
47 votes376 views6 answers
How to add new column in laravel migration
PHP Laravel
7 votes386 views3 answers
Wp get post id by slug
PHP Wordpress