<?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(); ?>
|