$pdo = new PDO('mysql:host=localhost;dbname=thinkphptest;port=3306','root','');
$pdo->exec('set names utf8');
$sql = 'SELECT * FROM fruit WHERE calories < :calories AND color = :color';
$result = $pdo->query($sql);
print_r($result);
