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

18 votes94 views3 answers
Php pop off the first character of string
PHP
0 vote103 views1 answer
Wp wc php use comma separated thousands
PHP
0 vote101 views1 answer
Declaration of App\Exports\TarefasExport::headings() must be compatible with Maatwebsite\Excel\Concerns\WithHeadings::headings(): array
PHP
2 votes135 views2 answers
Laravel migration remove unique
PHP Laravel
0 vote106 views2 answers
Loop foreach laravel with number
PHP
0 vote119 views2 answers
Wp get post content by id
PHP Wordpress
1 vote128 views1 answer
Php if negative make positive
PHP
4 votes104 views3 answers
Wp+get feature image
PHP
0 vote95 views2 answers
Php to javascript converter
PHP
39 votes118 views6 answers
Create table laravel
PHP Laravel