real_escape($_GET['val']);
$recode_id = $db->real_escape($_GET['id']);
if(!empty($val) && $val == "del"){
$rec = $db->fetch_array($db->query("SELECT photo FROM member WHERE id = '$recode_id'"));
$query = $db->query("DELETE FROM member WHERE id = '$recode_id'");
if($query){
unlink($rec['photo']);
$msg = "Record Deleted Successfully";
}else{
$error = "Network Error.";
}
}
$member_type = $db->real_escape($_POST['member_type']);
$session = $db->real_escape($_POST['session']);
$department = $db->real_escape($_POST['department']);
if(!empty($member_type)){
$where .= " AND member_type = '$member_type'";
}
if(!empty($session)){
$where .= " AND session = '$session'";
}
if(!empty($department)){
$where .= " AND department = '$department'";
}
?>
Success :
Error :
Search
Books Listing
#
Member Type
Member Id
Member Name
Department
Subject
Member Card No
query("SELECT * FROM member WHERE 1 $where ORDER BY id DESC");
$count = $db->num_rows($record);
while($result = $db->fetch_array($record)){
$subject = $db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$result['subject']."'"));
$department = $db->fetch_array($db->query("SELECT department FROM department WHERE department_id = '".$result['department']."'"));
$type = $db->fetch_array($db->query("SELECT member_type FROM member_type WHERE member_type_id = '".$result['member_type']."'"));
?>