prepare(" DELETE FROM enrolment_requests WHERE id=? AND user=? LIMIT 1 "); $stmt->bind_param("is",$deleteId,$user); $stmt->execute(); $stmt->close(); header("Location: admin_user_requests.php?user=".urlencode($user)."&search=".urlencode($search)); exit; } /* ================= HANDLE UPDATE ================= */ if ($_SERVER['REQUEST_METHOD']==='POST' && isset($_POST['id'])) { $id = (int)$_POST['id']; $nin = trim($_POST['nin']); $trackingId = trim($_POST['tracking_id']); $status = trim($_POST['status']); /* ===== UPDATE ===== */ $stmt = $conn->prepare(" UPDATE enrolment_requests SET nin=?, tracking_id=?, status=? WHERE id=? AND user=? "); $stmt->bind_param("sssis",$nin,$trackingId,$status,$id,$user); $stmt->execute(); $stmt->close(); header("Location: admin_user_requests.php?user=".urlencode($user)."&search=".urlencode($search)); exit; } /* ================= FETCH REQUESTS ================= */ if ($search != '') { $stmt = $conn->prepare(" SELECT id, tracking_id, type, nin, status, created_at FROM enrolment_requests WHERE user=? AND ( nin LIKE ? OR tracking_id LIKE ? ) ORDER BY id DESC "); $like = "%".$search."%"; $stmt->bind_param("sss",$user,$like,$like); } else { $stmt = $conn->prepare(" SELECT id, tracking_id, type, nin, status, created_at FROM enrolment_requests WHERE user=? ORDER BY id DESC "); $stmt->bind_param("s",$user); } $stmt->execute(); $result = $stmt->get_result(); ?> User Requests
← Back to Summary

📄 Requests for:

fetch_assoc()): ?>
ID Tracking ID Type NIN Status Date Update Delete