Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/gadadhari.in/public_html/admin

Free Space:

8.27 TB

🔧 Quick Actions

✏️ Editing: application-view.php

<?php
session_start();
// 1. SECURITY
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit;
}

// 2. DB CONNECTION
$host = 'localhost';
$db   = 'u176134211_ihm123';
$user = 'u176134211_ihm123';
$pass = 'Ayushi@0337##';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$db;charset=utf8mb4", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) { die("DB Error: " . $e->getMessage()); }

// 3. FETCH DATA
if (!isset($_GET['id'])) die("Invalid Request");
$id = $_GET['id'];

$stmt = $pdo->prepare("SELECT a.*, c.course_name FROM applications a LEFT JOIN courses c ON a.course_id = c.id WHERE a.id = ?");
$stmt->execute([$id]);
$app = $stmt->fetch();

if (!$app) die("Application not found.");

$family = $pdo->prepare("SELECT * FROM application_family WHERE application_id = ?"); $family->execute([$id]); $family = $family->fetchAll();
$edu = $pdo->prepare("SELECT * FROM application_education WHERE application_id = ?"); $edu->execute([$id]); $edu = $edu->fetchAll();
$refs = $pdo->prepare("SELECT * FROM application_references WHERE application_id = ?"); $refs->execute([$id]); $refs = $refs->fetchAll();
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <title>Application <?= $app['application_no'] ?></title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <style>
        /* --- OFFICIAL PALETTE --- */
        :root {
            --gold: #F2C94C;       /* Institute Gold */
            --navy: #1F3A5F;       /* Deep Navy Blue */
            --sidebar-gray: #E6E6E6; 
            --text-black: #000;
        }
        
        body { background: #555; font-family: 'Times New Roman', serif; margin: 0; }
        .page { background: white; width: 210mm; min-height: 297mm; margin: 20px auto; position: relative; box-shadow: 0 0 10px rgba(0,0,0,0.5); box-sizing: border-box; }
        
        /* --- HEADER CONTAINER --- */
        .header-container {
            display: flex;
            width: 100%;
            height: 220px; 
            border-bottom: 2px solid var(--navy);
            position: relative;
        }

/* --- SHIELD LOGO (FLOATING) --- */
        .shield-logo {
            position: absolute;
            top: 0;
            left: 30px;
            height: 110px; 
            width: auto;
            z-index: 20;
            background: white;
            padding: 5px;
            border-radius: 0 0 50px 50px;
            box-shadow: 2px 2px 6px rgba(0,0,0,0.2);
        }

/* --- LEFT SIDE --- */
        .header-left {
            width: 75%;
            display: flex;
            flex-direction: column;
        }

.top-gold-bar {
            background-color: var(--gold);
            height: 65px;
            display: flex;
            align-items: center;
            padding-left: 160px; /* Space for Shield */
        }

.top-gold-bar h1 {
            color: white;
            font-size: 32px;
            font-weight: normal;
            margin: 0;
            text-transform: uppercase;
            font-family: 'Times New Roman', serif;
            letter-spacing: 0.5px;
        }

.logo-area {
            background: white;
            flex-grow: 1;
            display: flex;
            align-items: center;
            justify-content: space-around;
            padding: 10px 20px 10px 150px; 
        }

.logo-area img {
            height: 85px; 
            width: auto;
            object-fit: contain;
        }

/* --- RIGHT SIDEBAR --- */
        .header-sidebar {
            width: 25%;
            background-color: var(--sidebar-gray);
            border-left: 3px solid white;
            display: flex;
            flex-direction: column;
            align-items: center;
            justify-content: flex-start;
            padding-top: 10px;
            text-align: center;
        }

.photo-box {
            width: 150px;
            height: 190px;
            background: white;
            border: 1px solid #999;
            display: flex;
            align-items: center;
            justify-content: center;
            overflow: hidden;
            margin-bottom: 5px;
        }
        .photo-box img { width: 100%; height: 100%; object-fit: contain; }

.app-val {
            font-size: 16px;
            font-weight: bold;
            color: var(--navy);
            display: block;
            margin-top: 2px;
        }
        .app-lbl {
            font-size: 11px;
            color: var(--text-black);
            text-transform: uppercase;
            border-top: 1px solid var(--navy);
            width: 80%;
            margin: 2px auto 8px auto;
            display: block;
            font-family: sans-serif;
        }

/* --- STRIPS --- */
        .strip-course {
            background-color: var(--navy);
            padding: 12px 30px;
            font-size: 20px;
            font-weight: bold;
            font-family: serif;
            color: white;
        }
        .strip-course span { 
            color: var(--gold); 
            font-weight: bold;
            text-transform: uppercase;
        }

.strip-title {
            background-color: white;
            color: var(--navy);
            text-align: center;
            padding: 10px;
            font-size: 18px;
            font-weight: bold;
            text-transform: uppercase;
            border-bottom: 1px solid #ccc;
        }

/* --- CONTENT --- */
        .content { padding: 20px 30px; padding-bottom: 100px; }
        
        table.doc-table { width: 100%; border-collapse: collapse; font-size: 13px; margin-bottom: 15px; }
        table.doc-table td { border: 1px solid #000; padding: 6px 8px; vertical-align: top; }
        
        .lbl { font-size: 10px; color: #444; text-transform: uppercase; display: block; font-family: sans-serif; font-weight: bold; margin-bottom: 3px; }
        .val { font-size: 14px; font-weight: bold; text-transform: uppercase; color: #000; }
        
        .section-head { 
            font-weight: bold; font-size: 15px; margin-top: 20px; margin-bottom: 5px; text-decoration: underline; color: #000;
        }

/* --- FOOTER --- */
        .footer {
            background-color: var(--gold);
            color: var(--navy);
            border-top: 2px solid var(--navy);
            padding: 10px;
            text-align: center;
            font-size: 14px;
            position: absolute;
            bottom: 0;
            width: 100%;
            box-sizing: border-box;
            font-weight: 500;
        }
        
        .footer a { color: var(--navy); text-decoration: none; font-weight: bold; }

/* --- PRINT SETTINGS (FIXED FOR CLEAN URL REMOVAL) --- */
        @media print {
            @page {
                margin: 0; /* THIS REMOVES THE BROWSER HEADER/FOOTER (URL, Date) */
                size: auto;
            }
            body { 
                background: white; 
                margin: 0;
                padding-top: 10px; /* Small buffer for the printer */
            }
            .page { 
                margin: 0 auto; 
                box-shadow: none; 
                width: 100%; 
                border: none;
            }
            .no-print { display: none !important; }
            
            /* Enforce Background Graphics */
            .top-gold-bar { background-color: #F2C94C !important; -webkit-print-color-adjust: exact; }
            .strip-course { background-color: #1F3A5F !important; -webkit-print-color-adjust: exact; }
            .header-sidebar { background-color: #E6E6E6 !important; -webkit-print-color-adjust: exact; }
            .footer { background-color: #F2C94C !important; color: #1F3A5F !important; -webkit-print-color-adjust: exact; }
        }
    </style>
</head>
<body>

<div class="container mt-3 mb-3 no-print">
    <div class="card shadow border-0">
        <div class="card-body d-flex justify-content-between align-items-center">
            <div>
                <a href="dashboard.php" class="btn btn-secondary btn-sm">&larr; Dashboard</a>
                <span class="ms-3 badge bg-dark fs-6">Status: <?= strtoupper($app['status']) ?></span>
            </div>
            <div>
                <a href="change-status.php?id=<?= $id ?>&status=shortlisted" class="btn btn-success btn-sm" onclick="return confirm('Shortlist?')">✅ Shortlist</a>
                <a href="change-status.php?id=<?= $id ?>&status=rejected" class="btn btn-danger btn-sm" onclick="return confirm('Reject?')">❌ Reject</a>
                <button onclick="window.print()" class="btn btn-primary btn-sm ms-2">🖨 Print</button>
            </div>
        </div>
    </div>
</div>

<div class="header-left">
            <div class="top-gold-bar">
                <h1>Dr. Rafiq Zakaria Campus</h1>
            </div>
            <div class="logo-area">
                <img src="../assets/ihm_logo.png" alt="IHM">
                <img src="../assets/ihcl_logo.png" alt="IHCL" onerror="this.style.display='none'">
                <img src="../assets/taj_logo.png" alt="Taj">
            </div>
        </div>

<div class="header-sidebar">
            <div class="photo-box">
                <?php if(!empty($app['photo_path'])): ?>
                    <img src="../<?= $app['photo_path'] ?>">
                <?php else: ?>
                    <span style="font-size:10px; color:#ccc;">PHOTO</span>
                <?php endif; ?>
            </div>
            
            <span class="app-val"><?= $app['application_no'] ?></span>
            <span class="app-lbl">APPLICATION NO.</span>
            
            <span class="app-val" style="font-weight:normal; margin-top:5px;"><?= $app['receipt_no'] ?? 'Pending' ?></span>
            <span class="app-lbl">RECEIPT NO.</span>
        </div>

</div>

<div class="strip-course">
        Course Applied for: <span><?= $app['course_name'] ?></span>
    </div>
    <div class="strip-title">
        APPLICATION FORM FOR ADMISSION <?= $app['academic_year'] ?>
    </div>

<div class="content">
        
        <table class="doc-table">
            <tr>
                <td width="5%">1</td>
                <td width="30%"><span class="lbl">First Name</span><span class="val"><?= $app['first_name'] ?></span></td>
                <td width="30%"><span class="lbl">Middle Name</span><span class="val"><?= $app['middle_name'] ?></span></td>
                <td width="35%"><span class="lbl">Surname</span><span class="val"><?= $app['last_name'] ?></span></td>
            </tr>
            <tr>
                <td>2</td>
                <td><span class="lbl">Date of Birth</span><span class="val"><?= date('d-M-Y', strtotime($app['dob'])) ?></span></td>
                <td colspan="2"><span class="lbl">Nationality</span><span class="val"><?= $app['nationality'] ?></span></td>
            </tr>
            <tr>
                <td>3</td>
                <td colspan="3"><span class="lbl">Address</span><span class="val"><?= $app['address_line1'] ?>, <?= $app['city'] ?> - <?= $app['pincode'] ?></span></td>
            </tr>
            <tr>
                <td rowspan="2">4</td>
                <td><span class="lbl">Email</span><span class="val" style="text-transform:lowercase;"><?= $app['email'] ?></span></td>
                <td><span class="lbl">Mobile</span><span class="val"><?= $app['phone_mobile'] ?></span></td>
                <td><span class="lbl">Home Tel</span><span class="val"><?= $app['phone_home'] ?></span></td>
            </tr>
            <tr>
                <td><span class="lbl">Domicile</span><span class="val"><?= $app['domicile_state'] ?></span></td>
                <td><span class="lbl">Mother Tongue</span><span class="val"><?= $app['mother_tongue'] ?></span></td>
                <td><span class="lbl">Faith</span><span class="val"><?= $app['faith'] ?></span></td>
            </tr>
        </table>

<div class="section-head">FAMILY DETAILS</div>
        <table class="doc-table">
            <tr style="background:#f9f9f9;">
                <td><b>Relation</b></td><td><b>Name</b></td><td><b>Age</b></td><td><b>Occupation</b></td><td><b>Contact</b></td>
            </tr>
            <?php foreach($family as $f): ?>
            <tr>
                <td><?= strtoupper($f['type']) ?></td>
                <td><?= $f['name'] ?></td>
                <td><?= $f['age'] ?></td>
                <td><?= $f['occupation'] ?></td>
                <td><?= $f['mobile'] ?></td>
            </tr>
            <?php endforeach; ?>
        </table>

<div class="section-head">EDUCATIONAL DETAILS</div>
        <table class="doc-table">
            <tr style="background:#f9f9f9;">
                <td><b>Exam</b></td><td><b>School</b></td><td><b>Year</b></td><td><b>Marks</b></td><td><b>Subjects</b></td>
            </tr>
            <?php foreach($edu as $e): ?>
            <tr>
                <td><?= $e['level'] ?></td>
                <td><?= $e['institution_name'] ?></td>
                <td><?= $e['year_of_passing'] ?></td>
                <td><?= $e['marks_percent'] ?>%</td>
                <td><?= $e['subjects'] ?></td>
            </tr>
            <?php endforeach; ?>
        </table>

<div class="section-head">REFERENCES</div>
        <table class="doc-table">
            <tr>
            <?php foreach($refs as $i=>$r): ?>
                <td width="50%">
                    <span class="lbl">Reference <?= $i+1 ?></span><br>
                    <b><?= $r['name'] ?></b><br>
                    Occ: <?= $r['occupation'] ?><br>
                    Ph: <?= $r['phone'] ?>
                </td>
            <?php endforeach; ?>
            </tr>
        </table>

<div style="margin-top:20px;">
            <div style="border: 1px solid #ccc; padding: 10px; background-color: #f9f9f9; font-size: 11px; text-align:justify;">
                <b>DECLARATION:</b> My ward has my permission to apply for admission to the Institute of Hotel Management, Aurangabad. If my ward secures admission, I shall be responsible for his/her conduct and discipline. I also declare that the information given above is correct.
            </div>
            
            <table style="border:none; width:100%; text-align:center; margin-top:20px;">
                <tr style="border:none;">
                    <td style="border:none; vertical-align:bottom; text-align:left; width:25%; padding-left:10px;">
                        <b style="font-size:13px;">Place: <?= $app['place'] ?></b><br><br>
                        <b style="font-size:13px;">Date: <?= date('d-m-Y', strtotime($app['submitted_at'])) ?></b>
                    </td>
                    
                    <td style="border:none; vertical-align:bottom; width:37%;">
                        <div style="height:70px; display:flex; align-items:flex-end; justify-content:center;">
                            <?php if(!empty($app['signature_path'])): ?>
                                <img src="../<?= $app['signature_path'] ?>" style="max-height:60px; max-width:180px;">
                            <?php endif; ?>
                        </div>
                        <span class="lbl" style="border-top:1px solid #000; padding-top:5px; display:inline-block; width:200px; font-weight:bold;">Signature of Applicant</span>
                    </td>

<td style="border:none; vertical-align:bottom; width:38%;">
                        <div style="height:70px;"></div>
                        <span class="lbl" style="border-top:1px solid #000; padding-top:5px; display:inline-block; width:200px; font-weight:bold;">Signature of Parent/Guardian</span>
                    </td>
                </tr>
            </table>
        </div>
        
    </div>

<div class="footer">
    <strong>Institute of Hotel Management Dr. Rafiq Zakaria Campus</strong><br>
    Dr. Rafiq Zakaria Marg, Rauza Bagh, Aurangabad – 431001 (Maharashtra), India.<br>
    Tel: (0240) 2381127, 2392847 | Email: 
    <a href="mailto:ihm.aurangabad@tajhotels.com">ihm.aurangabad@tajhotels.com</a>

</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: application-view.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation