/home/u764571690/domains/savitrfoundation.com/public_html/scholar/pages
Edit: /home/u764571690/domains/savitrfoundation.com/public_html/scholar/pages/invite.php (26223B)
'/',
'domain' => '', // Empty for localhost compatibility
'secure' => false, // Allow HTTP for localhost
'httponly' => true,
'samesite' => 'Lax',
'lifetime' => 2592000 // 30 days cookie lifetime
]);
session_start();
}
// Correct path to db.php
require_once __DIR__ . '/../db.php';
// ✅ PERFORMANCE: Local cache class for pages/cache directory
class LocalSimpleCache extends SimpleCache {
private static $cacheDir = __DIR__ . '/cache';
private static $defaultTTL = 300;
public static function init() {
if (!file_exists(self::$cacheDir)) {
@mkdir(self::$cacheDir, 0755, true);
}
}
public static function get($key) {
self::init();
$file = self::$cacheDir . '/' . md5($key) . '.cache';
if (!file_exists($file)) return false;
$data = @unserialize(file_get_contents($file));
if ($data === false) return false;
if (time() > $data['expires']) {
@unlink($file);
return false;
}
return $data['value'];
}
public static function set($key, $value, $ttl = null) {
self::init();
$ttl = $ttl ?? self::$defaultTTL;
$file = self::$cacheDir . '/' . md5($key) . '.cache';
$data = ['value' => $value, 'expires' => time() + $ttl, 'created' => time()];
$fp = @fopen($file, 'c+');
if ($fp === false) return @file_put_contents($file, serialize($data)) !== false;
$lockAcquired = false;
for ($i = 0; $i < 10; $i++) {
if (flock($fp, LOCK_EX | LOCK_NB)) {
$lockAcquired = true;
break;
}
usleep(500000);
}
if ($lockAcquired) {
ftruncate($fp, 0);
fwrite($fp, serialize($data));
flock($fp, LOCK_UN);
fclose($fp);
return true;
} else {
fclose($fp);
return @file_put_contents($file, serialize($data)) !== false;
}
}
public static function delete($key) {
self::init();
$file = self::$cacheDir . '/' . md5($key) . '.cache';
return @unlink($file);
}
}
if (!isset($_SESSION['user_logged_in']) || $_SESSION['user_logged_in'] !== true) {
header('Location: ../student');
exit();
}
$applicantId = (int)($_SESSION['applicant_id'] ?? 0);
$userId = $_SESSION['user_id'] ?? '';
$userName = $_SESSION['user_name'] ?? 'Student';
try {
// ✅ PERFORMANCE: Cache invite page data for 2 minutes
$inviteCacheKey = 'invite_data_' . $applicantId;
$inviteData = LocalSimpleCache::get($inviteCacheKey);
if ($inviteData === false) {
// ✅ OPTIMIZED: Single query to fetch applicant and user data together
$stmt = $pdo->prepare("
SELECT
a.*,
u.user_id,
u.bank_verified
FROM applicants a
LEFT JOIN users u ON a.applicant_id = u.applicant_id
WHERE a.applicant_id = ?
LIMIT 1
");
$stmt->execute([$applicantId]);
$applicant = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$applicant) {
throw new Exception('Application not found');
}
$bankVerified = $applicant['bank_verified'] ?? null;
$scholarId = $applicant['user_id'] ?? ($_SESSION['user_id'] ?? '');
// Referral: build referral link and load referred applicants
$referralLink = '';
$referredApplicants = [];
if (!empty($scholarId)) {
$baseUrl = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'];
$referralLink = $baseUrl . '/scholarshipapply?ref=' . urlencode($scholarId);
try {
// ✅ OPTIMIZED: Limit results and only fetch essential fields
$refStmt = $pdo->prepare("SELECT applicant_id, application_id, name, status, applied_at FROM applicants WHERE referred_by_user_id = ? ORDER BY applied_at DESC LIMIT 100");
$refStmt->execute([$scholarId]);
$referredApplicants = $refStmt->fetchAll(PDO::FETCH_ASSOC);
// Build simple counts for status summary
$refApproved = 0; $refPending = 0; $refRejected = 0;
foreach ($referredApplicants as $ra) {
$status = isset($ra['status']) ? strtoupper($ra['status']) : '';
if ($status === 'APPROVED') { $refApproved++; }
elseif ($status === 'REJECTED') { $refRejected++; }
else { $refPending++; }
}
} catch (Exception $e) {
$referredApplicants = [];
}
}
$inviteData = [
'applicant' => $applicant,
'bankVerified' => $bankVerified,
'scholarId' => $scholarId,
'referralLink' => $referralLink,
'referredApplicants' => $referredApplicants,
'refApproved' => $refApproved ?? 0,
'refPending' => $refPending ?? 0,
'refRejected' => $refRejected ?? 0
];
LocalSimpleCache::set($inviteCacheKey, $inviteData, 120); // Cache for 2 minutes
} else {
$applicant = $inviteData['applicant'];
$bankVerified = $inviteData['bankVerified'];
$scholarId = $inviteData['scholarId'];
$referralLink = $inviteData['referralLink'];
$referredApplicants = $inviteData['referredApplicants'];
$refApproved = $inviteData['refApproved'];
$refPending = $inviteData['refPending'];
$refRejected = $inviteData['refRejected'];
}
} catch (Exception $e) {
$error_message = $e->getMessage();
}
?>
Invite New Applicants - Student Dashboard - Savitr Foundation Scholarship
Welcome,
Scholar ID:
Your Applicants
No joined applicants yet.
| Application ID |
Name |
Status |
Applied |
|
|
|
|
|