query("UPDATE students SET is_deleted = 1 WHERE id = '$id'"); echo ''; } // Permanent delete if (isset($_GET['action']) && $_GET['action'] == 'delete' && isset($_GET['id'])) { $id = $_GET['id']; $con->query("DELETE FROM students WHERE id = '$id'"); echo ''; } // Restore student if (isset($_GET['action']) && $_GET['action'] == 'recycle' && isset($_GET['id'])) { $id = $_GET['id']; $con->query("UPDATE students SET is_deleted = 0 WHERE id = '$id'"); echo ''; } // Get active students $get = $con->query("SELECT * FROM students WHERE center_id = '".$_SESSION['center']['id']."' AND status = 1 AND is_deleted = 0"); $active_count = $get->num_rows; // Get deleted students $deleted_get = $con->query("SELECT * FROM students WHERE center_id = '".$_SESSION['center']['id']."' AND status = 1 AND is_deleted = 1"); $deleted_count = $deleted_get->num_rows; ?>

Active Students

Deleted Students

Active Students

Students
0) { while($g = $get->fetch_assoc()) { $c = $con->query("SELECT * FROM courses where id = '".$g['course_id']."'")->fetch_assoc(); echo ' '; } } else { echo ''; } ?>
Date Photo Enrollment No. Name Father's Name E-Mail ID Course Actions
'.date('d-M-Y', strtotime($g['timestamp'])).' '.$g['name'].' '.$g['enrollment_no'].' '.$g['name'].' '.$g['father'].' '.$g['email'].' '.$c['course_name'].'

No active students found

Recycle Bin

Students
0) { while($g = $deleted_get->fetch_assoc()) { $c = $con->query("SELECT * FROM courses where id = '".$g['course_id']."'")->fetch_assoc(); echo ' '; } } else { echo ''; } ?>
Date Photo Enrollment No. Name Father's Name E-Mail ID Course Actions
'.date('d-M-Y', strtotime($g['timestamp'])).' '.$g['name'].' '.$g['enrollment_no'].' '.$g['name'].' '.$g['father'].' '.$g['email'].' '.$c['course_name'].'

Recycle bin is empty