<h3>SQL FETCH using bindValue and named place holders</h3>

<?php

//SQL fetch using bindValue
//paul@paulvgibbs.com

error_reporting( E_ALL | E_STRICT | E_DEPRECATED );

$dbname = 'databasename';
$user = 'databseusername';
$pass = 'databasepassword';

$department = "music";
$first_name = "paul";

$dbh = new PDO("mysql:host=localhost;dbname=$dbname", $user, $pass);

$stmt = $dbh->prepare("SELECT * FROM staff where department = :dept and first_name = :forename");

$stmt->bindValue(":dept", $department, PDO::PARAM_STR);
$stmt->bindValue(":forename", $first_name, PDO::PARAM_STR);

if ($stmt->execute()) {
  while ($row = $stmt->fetch()) {
    print_r($row);
  }
}
?>