props = $props; }
// public function __get($prop) { return $this−>props[$prop]; }
// public function __set($prop, $val) { $this−>props[$prop] = $val; }
private static function getAllUsers(){
global $pdo;
$request = $pdo->prepare("select * from users");
$request->execute();
$allUsers = $request->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, get_called_class()
);
$pdo = null;
return $allUsers;
}
public static function showAllUsersAsTable(){
$allUsers = static::getAllUsers();
$result = '| Id | Nom | Email |
';
foreach($allUsers as $user){
$result.= $user->toHtml();
}
$result .= "
";
echo $result;
}
private function toHtml(){
return('| '.$this->id.' | '.$this->name.' | '.$this->email.' |
');
}
}
// POST
if(isset($_POST['name']) && isset($_POST['email'])) {
// ajout en POST
$addRequest = $pdo->prepare("INSERT INTO users(id, name, email) VALUES (NULL, '".$_POST["name"]."','".$_POST["email"]."')");
$addRequest->execute();
//SQL
}
// echo $allUsers;
/*** close the database connection ***/
?>
Users