<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php

class DB {
    private static function getConnection() {
        $con = new PDO('mysql:host=localhost;dbname=Test', 'root', 'hemmeligt');
        $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
        return $con;
    }
    public static function getAll() {
        $con = DB::getConnection();
        $stmt = $con->prepare('SELECT f1,f2,f3 FROM t1demo');
        $stmt->execute(array());
        $res = array();
        while($row = $stmt->fetch()) {
            $res[] = new T1($row['f1'], $row['f2'], $row['f3']);
        }
        return $res;
    }
    public static function saveOne($o) {
        $con = DB::getConnection();
        $stmt = $con->prepare('INSERT INTO t1demo(f1,f2,f3) VALUES(:f1,:f2,:f3)');
        $stmt->execute(array(':f1' => $o->f1, ':f2' => $o->f2, ':f3' => $o->f3));
    }
}

?>