oop methoduyla yazdığım var şöyle bırakıyorum yardımı olursa r10+ verirsiniz artık
public function adminsLogin($adminsusername,$adminspass){
try {
$stmt=$this->db->prepare("SELECT * FROM admins WHERE admins_username=? AND admins_pass=? AND admins_status=?");
$stmt->execute([$adminsusername,
md5($adminspass),1]);
if ($stmt->rowCount()==1) {
$row=$stmt->fetch(PDO::FETCH_ASSOC);
$_SESSION["admins"] = [
"admins_username" => $adminsusername,
"admins_namesurname" => $row['admins_namesurname'],
"admins_file" => $row['admins_file'],
"admins_id" => $row['admins_id']
];
return ['status' => TRUE ];
}else{
return ['status' => FALSE ];
}
} catch (Exception $e) {
return ['status' => FALSE,'error' => $e->getMessage()];
}
}