X
<?php
class db {
protected static $dbh = false;
function connect() {
self::$dbh = new PDO('mysql:host=localhost;dbname=test','user','pass');
self::$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
}
class user extends db {
function load($name) {
if(!self::$dbh) $this->connect();
try {
if(!self::$dbh) $this->connect();
$stmt = self::$dbh->prepare("SELECT * FROM user WHERE firstname=:name");
$ret = $stmt->execute(array('name'=>$name));
} catch (PDOException $e) {
die($e->getMessage());
}
return $ret;
}
}
$db = new items;
$result = $db->load("jens");
foreach($result->fetch(PDO::FETCH_ASSOC) as $row) {
echo $row['fullname'] . "<br />";
echo $row['address'] . "<br />";
}
?>