query("DELETE FROM `students` WHERE `id` = '$id' "); echo ''; } $get = $con->query("SELECT * FROM students"); if($_GET['action'] == 'changeStatus'){ $val = $_GET['val']?0:1; $id = $_GET['id']; $con->query("UPDATE `students` SET `status`= '$val' WHERE id = '$id'"); echo ''; } ?>
All Students
Date
Photo
Enrollment No.
Name
Father's Name
Center
Course
Status
Details
Delete
fetch_assoc()) { $c = $con->query("SELECT * FROM courses where id = '".$g['course_id']."'")->fetch_assoc(); $ce = $con->query("SELECT * FROM centers where id = '".$g['center_id']."'")->fetch_assoc(); $statusBtn = $g['status'] ? 'success' : 'danger'; $statusIcon = $g['status'] ? 'on' : 'off'; echo '
'.date('d-M-y',strtotime($g['timestamp'])).'
'.$g['enrollment_no'].'
'.$g['name'].'
'.$g['father'].'
'.$ce['institute_name'].'
'.$c['course_name'].'
'; } ?>
