public function getRoles()
{
$query = "SELECT\n roles.id AS role_id,\n roles.role\n From\n roles\n ";
try {
$stmnt = $this->db->prepare($query);
$stmnt->execute();
$result = $stmnt->fetchAll();
$stmnt->closeCursor();
foreach ($result as $r) {
$roles[$r['role_id']] = $r['role'];
}
return $roles;
} catch (PDOException $e) {
Database::display_db_error($e->getMessage());
exit;
}
}
public function deleteUser($user_id)
{
$query = "DELETE\n From\n users\n Where\n (users.id = :user_id ) \n ";
try {
$stmnt = $this->db->prepare($query);
$stmnt->bindValue(':user_id', $user_id, PDO::PARAM_INT);
$stmnt->execute();
$stmnt->closeCursor();
} catch (PDOException $e) {
Database::display_db_error($e->getMessage());
exit;
}
}
