1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
class UserModel
{
public static function getAllUsers(){
$pdo = DatabaseConnector::current();
$request = $pdo->prepare("select * from users");
$request->execute();
$allUsers = $request->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, get_called_class());
return $allUsers;
}
public static function getUserById($id){
$pdo = DatabaseConnector::current();
$request = $pdo->prepare("select * from users where id=".$id);
$request->execute();
$allUsers = $request->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, get_called_class());
return $allUsers;
}
public static function createUser($name, $email){
$pdo = DatabaseConnector::current();
$request = $pdo->prepare("insert into users(id, name, email) values (NULL, '".$name."','".$email."')");
$request->execute();
}
public static function deleteUser($id){
$pdo = DatabaseConnector::current();
$request = $pdo->prepare("delete from users where id=".$id);
$request->execute();
}
public static function editUser($id, $name, $email){
$pdo = DatabaseConnector::current();
$request = $pdo->prepare("update users set name='".$name."', email='".$email."' where id=".$id);
$request->execute();
}
}