/home/u764571690/domains/savitrfoundation.com/public_html
Edit:
prepare("SELECT * FROM applicants WHERE application_id = ? AND aadhar_number = ? AND dob = ? LIMIT 1");
$stmt->execute([$applicationId, $aadharNumber, $dob]);
$applicant = $stmt->fetch(PDO::FETCH_ASSOC);
if ($applicant) {
$showApplication = true;
// Fetch user details if applicant is approved
if ($applicant['status'] === 'Approved') {
$userStmt = $pdo->prepare("SELECT * FROM users WHERE applicant_id = ? LIMIT 1");
$userStmt->execute([$applicant['applicant_id']]);
$user = $userStmt->fetch(PDO::FETCH_ASSOC);
}
// Fetch all documents
$docStmt = $pdo->prepare("SELECT * FROM documents WHERE applicant_id = ? ORDER BY uploaded_at DESC");
$docStmt->execute([$applicant['applicant_id']]);
$documents = $docStmt->fetchAll(PDO::FETCH_ASSOC);
// Fetch rejected documents separately
$rejectedDocStmt = $pdo->prepare("SELECT * FROM documents WHERE applicant_id = ? AND status = 'rejected' ORDER BY uploaded_at DESC");
$rejectedDocStmt->execute([$applicant['applicant_id']]);
$rejectedDocuments = $rejectedDocStmt->fetchAll(PDO::FETCH_ASSOC);
}
} catch (Exception $e) {
$error_message = $e->getMessage();
}
}
// Handle bank information update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_bank'])) {
$applicantId = $_POST['applicant_id'];
$bankName = trim($_POST['bank_name']);
$accountHolderName = trim($_POST['account_holder_name']);
$accountNumber = trim($_POST['account_number']);
$ifscCode = trim($_POST['ifsc_code']);
$branchName = trim($_POST['branch_name']);
try {
$stmt = $pdo->prepare("
UPDATE applicants
SET bank_name = ?, account_holder_name = ?, account_number = ?, ifsc_code = ?, branch_name = ?
WHERE applicant_id = ?
");
$stmt->execute([$bankName, $accountHolderName, $accountNumber, $ifscCode, $branchName, $applicantId]);
// Refresh applicant data
if ($applicationId && $aadharNumber && $dob) {
$stmt = $pdo->prepare("SELECT * FROM applicants WHERE application_id = ? AND aadhar_number = ? AND dob = ? LIMIT 1");
$stmt->execute([$applicationId, $aadharNumber, $dob]);
$applicant = $stmt->fetch(PDO::FETCH_ASSOC);
}
$message = "Bank information updated successfully!";
$messageType = "success";
} catch (Exception $e) {
$message = "Error updating bank information: " . $e->getMessage();
$messageType = "error";
}
}
?>
/home/u764571690/domains/savitrfoundation.com/public_html/application.php (41647B)
Scholarship Application Status
Check Application Status
Application Details
Application ID:
Name:
Email:
Phone:
Applied Date:
Application Status:
Scholarship Status:
Scholar ID:
Bank Verification:
Bank Information
Bank Name:
Account Holder Name:
Account Number:
IFSC Code:
Branch Name:
Bank Information
Bank Name:
Account Holder Name:
Account Number:
IFSC Code:
Branch Name:
Bank Information
Bank Name:
Account Holder Name:
Account Number:
IFSC Code:
Branch Name:
Rejected Documents
REJECTED
Rejected on:
All Documents
No documents found.
Uploaded: