📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/admin/interview.php
<?php // Include the database connection include('dbconnect.php'); // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $applicant_id = $_POST['applicant_id']; $interview_date = $_POST['interview_date']; $selection_status = $_POST['selection_status']; $sql = "INSERT INTO candidate_selection (applicant_id, interview_status, selection_status, interview_date, selection_date) VALUES (?, 'Completed', ?, ?, NOW()) ON DUPLICATE KEY UPDATE interview_status = 'Completed', selection_status = ?, interview_date = ?, selection_date = NOW()"; if ($stmt = $con->prepare($sql)) { $stmt->bind_param("isssss", $applicant_id, $selection_status, $interview_date, $selection_status, $interview_date); if ($stmt->execute()) { header("Location: " . $_SERVER['PHP_SELF']); exit(); } else { echo "<p style='color:red; font-weight:700;'>❌ Error: " . $stmt->error . "</p>"; } $stmt->close(); } else { echo "<p style='color:red; font-weight:700;'>❌ Error preparing query: " . $con->error . "</p>"; } } // Fetch applicants $applicants_sql = "SELECT * FROM job_applicants"; $applicants_result = $con->query($applicants_sql); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Interview Status Update</title> <meta name="viewport" content="width=device-width, initial-scale=1" /> <!-- FontAwesome CDN for icons --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" /> <style> /* Reset */ * { box-sizing: border-box; } body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background: linear-gradient(135deg, #2980b9, #6dd5fa); margin: 0; padding: 0; min-height: 100vh; display: flex; flex-direction: column; } header { background-color: #1c3f6d; color: #fff; padding: 15px 25px; display: flex; justify-content: space-between; align-items: center; box-shadow: 0 4px 8px rgba(0,0,0,0.2); } header h2 { margin: 0; font-weight: 700; font-size: 1.8rem; letter-spacing: 1.5px; user-select: none; } .logout-btn { background-color: #e74c3c; border: none; padding: 10px 22px; border-radius: 5px; color: #fff; font-weight: 700; font-size: 0.9rem; cursor: pointer; display: flex; align-items: center; gap: 8px; transition: background-color 0.3s ease; } .logout-btn i { font-size: 1.1rem; } .logout-btn:hover { background-color: #c0392b; } .container { background: #fff; max-width: 600px; margin: 40px auto 60px auto; border-radius: 12px; padding: 30px 35px 40px; box-shadow: 0 12px 30px rgba(0,0,0,0.15); flex-grow: 1; } h3 { text-align: center; margin-bottom: 30px; font-weight: 700; color: #34495e; font-size: 1.9rem; letter-spacing: 1px; user-select: none; } form label { display: flex; align-items: center; gap: 10px; font-weight: 600; margin-bottom: 6px; color: #2c3e50; font-size: 1rem; } form label i { color: #3498db; font-size: 1.2rem; min-width: 22px; text-align: center; } select, input[type="datetime-local"] { width: 100%; padding: 14px 16px; margin-bottom: 20px; border-radius: 8px; border: 1.8px solid #bdc3c7; font-size: 1rem; color: #2c3e50; transition: border-color 0.3s ease; outline-offset: 2px; } select:focus, input[type="datetime-local"]:focus { border-color: #2980b9; outline: none; box-shadow: 0 0 8px rgba(41, 128, 185, 0.5); } input[type="submit"] { background-color: #2980b9; border: none; padding: 16px 0; width: 100%; border-radius: 10px; color: #ecf0f1; font-weight: 700; font-size: 1.1rem; cursor: pointer; letter-spacing: 1.1px; display: flex; justify-content: center; align-items: center; gap: 12px; transition: background-color 0.35s ease; user-select: none; } input[type="submit"]:hover { background-color: #1b669d; } input[type="submit"] i { font-size: 1.2rem; } /* Responsive */ @media (max-width: 768px) { .container { margin: 25px 20px 40px; padding: 25px 20px 30px; } header { flex-direction: column; align-items: flex-start; gap: 10px; padding: 15px 20px; } .logout-btn { width: 100%; justify-content: center; } } </style> </head> <body> <header> <h2><i class="fa-solid fa-clipboard-list"></i> Interview Panel</h2> <form action="logout.php" method="post" aria-label="Logout Form"> <button class="logout-btn" type="submit" aria-label="Logout"> <i class="fa-solid fa-right-from-bracket"></i> Logout </button> </form> </header> <div class="container" role="main" aria-labelledby="updateTitle"> <h3 id="updateTitle"><i class="fa-solid fa-pen-to-square"></i> Update Interview Status</h3> <form method="POST" action="interview.php" aria-describedby="formInstructions"> <p id="formInstructions" style="display:none;"> Select applicant, interview date and update the selection status, then submit the form. </p> <label for="applicant_id"><i class="fa-solid fa-user"></i> Select Applicant:</label> <select name="applicant_id" id="applicant_id" required aria-required="true" aria-describedby="applicantHelp"> <option value="">-- Select Applicant --</option> <?php while ($row = $applicants_result->fetch_assoc()) { ?> <option value="<?php echo htmlspecialchars($row['id']); ?>"> <?php echo htmlspecialchars($row['name']); echo " (Passport: " . htmlspecialchars($row['passport_no']) . ")"; echo " - Position: " . htmlspecialchars($row['position']); echo " - Country: " . htmlspecialchars($row['job_country']); echo " - Ref: " . htmlspecialchars($row['reference']); ?> </option> <?php } ?> </select> <label for="interview_date"><i class="fa-solid fa-calendar-days"></i> Interview Date:</label> <input type="datetime-local" id="interview_date" name="interview_date" required aria-required="true" /> <label for="selection_status"><i class="fa-solid fa-list-check"></i> Selection Status:</label> <select name="selection_status" id="selection_status" required aria-required="true"> <option value="">-- Select Status --</option> <option value="Selected">Selected</option> <option value="Rejected">Rejected</option> </select> <input type="submit" value="Update Interview Status" aria-label="Update Interview Status"> </form> </div> </body> </html>
Save
Cancel