<!-- Collection of code snippets by Arne Vajhøj -->
<!-- posted to eksperten.dk, usenet and other places (2002-now) -->
<?php
function load($con, $sqlstr, $vals) {
    $stmt = $con->prepare($sqlstr);
    $stmt->execute($vals);
    return $stmt->fetchAll();   
}

function test($con, $sqlstr,$vals) {
    $arr = load($con, $sqlstr, $vals);
    foreach($arr as $row) {
        echo $row['f1'] . ' ' . $row['f2'] . "\r\n";
    }
}

try {
    $con = new PDO('mysql:host=localhost;dbname=Test', 'root', '');
    $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    test($con, 'SELECT f1,f2 FROM t1 WHERE f1=:v1', array(':v1' => 2));
    test($con, 'SELECT f1,f2 FROM t1 WHERE f1=:v1 OR f1=:v2', array(':v1' => 1,':v2' => 3));
} catch (PDOException $ex) {
    die($ex->getMessage());
}
?>