-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathadmin2.php
More file actions
43 lines (30 loc) · 1.1 KB
/
Copy pathadmin2.php
File metadata and controls
43 lines (30 loc) · 1.1 KB
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
39
40
41
42
43
<?php
require_once '../config/db_config.php';
require_once 'Database.php';
class Admin {
private $db;
public function _construct(){
$this->db = new Database;
}
public function createAdmin($full_name, $password) {
$sql = "INSERT INTO admin (full_name, password) VALUES ('$full_name', '$password')";
return $this->db->query($sql);
}
public function getAdminById($admin_id) {
$sql = "SELECT * FROM admin WHERE id = $admin_id";
return $this->db->query($sql)->fetch_assoc();
}
public function updateAdmin($admin_id, $newfull_name, $newPassword) {
$sql = "UPDATE admin SET username = '$newfull_name', password = '$newPassword' WHERE id = $admin_id";
return $this->db->query($sql);
}
public function getAllAdmins() {
$sql = "SELECT * FROM admin";
return $this->db->query($sql)->fetch_all(MYSQLI_ASSOC);
}
public function deleteAdmin($admin_id) {
$sql = "DELETE FROM admin WHERE id = $admin_id";
return $this->db->query($sql);
}
}
?>