props[$prop];
}
public function __set($prop, $val) {
$this->props[$prop] = $val;
}
public static function executeRequest($req) {
global $pdo;
$request = $pdo->prepare($req);
if (!$request) {
myDump(debug_backtrace());
die('Error while doing request ' . $sqlRequest);
}
$request->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, get_called_class());
$request->execute();
return $request->fetchAll();
}
public static function getAllUsers() {
return static::executeRequest('select * from `users`');
}
// instance-side method to render a User object to HTML
public function toHtml() {
// print_r($this);
echo ""
. "| ". $this->id . " | "
. "". $this->name . " | "
. "" . $this->email . " |
";
}
// class-side method to render an array of users as an HTML table
public static function showUsersAsTable($users) {
echo '
| Id | Nom | Email |
|---|
';
foreach($users as $u) {
print_r($u);
$u->toHtml();
}
echo '
';
}
public static function showAllUsersAsTable() {
static::showUsersAsTable(static::getAllUsers());
}
}
?>
Users