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 | Actions |
';
foreach($allUsers as $user){
$result.= $user->toHtml();
}
$result .= "
";
echo $result;
}
private function toHtml(){
$result = '| '.$this->id.' | '.$this->name.' | '.$this->email;
$result.=' | ';
$result.=' |
';
return($result);
}
}
// 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