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/aqua-walrus-487298.hostingersite.com/public_html/admin

Free Space:

8.2 TB

🔧 Quick Actions

✏️ Editing: add-batch.php

<?php
// File: /esarthi/admin/add-batch.php (Admin Panel - Add New Batch)

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

require_once("../config/db.php");

$message = "";
$is_error = false;
$initial_course_id = isset($_GET['course_id']) ? (int)$_GET['course_id'] : 0; // Pre-select if filtered

// --- 2. FETCH DEPENDENT DATA (Courses & Teachers) ---
$q_courses = $conn->query("SELECT course_id, course_name, fees FROM courses WHERE status='active' ORDER BY course_name ASC");
$q_teachers = $conn->query("SELECT teacher_id, full_name, subject_expertise FROM teachers WHERE status='active' ORDER BY full_name ASC");

if ($q_courses->num_rows === 0) {
     $message = "❌ Error: Cannot add a batch. No **Active Courses** found. Please add a course first.";
     $is_error = true;
}
if ($q_teachers->num_rows === 0) {
     $message .= (empty($message) ? "" : "<br>") . "❌ Error: Cannot assign a teacher. No **Active Teachers** found.";
     $is_error = true;
}

// --- 3. HANDLE FORM SUBMISSION (Insert Logic) ---
if (isset($_POST['add_batch'])) {
    $course_id = (int)$_POST['course_id'];
    $teacher_id = (int)$_POST['teacher_id'];
    $batch_name = $conn->real_escape_string($_POST['batch_name']);
    $start_date = $conn->real_escape_string($_POST['start_date']);
    $end_date = !empty($_POST['end_date']) ? "'".$conn->real_escape_string($_POST['end_date'])."'" : "NULL";
    $timing = $conn->real_escape_string($_POST['timing']);
    $max_capacity = (int)$_POST['max_capacity'];
    $status = $conn->real_escape_string($_POST['status']);
    
    // Simple validation
    if (empty($batch_name) || empty($start_date) || $course_id <= 0 || $teacher_id <= 0 || $max_capacity <= 0) {
        $message = "❌ Error: All required fields (Batch Name, Dates, Course, Teacher, Capacity) must be filled.";
        $is_error = true;
    } elseif ($max_capacity < 1) {
        $message = "❌ Error: Maximum capacity must be at least 1.";
        $is_error = true;
    } else {
        $sql = "INSERT INTO batches (course_id, teacher_id, batch_name, start_date, end_date, timing, max_capacity, status) 
                VALUES ($course_id, $teacher_id, '$batch_name', '$start_date', $end_date, '$timing', $max_capacity, '$status')";
        
        if ($conn->query($sql) === TRUE) {
            $last_id = $conn->insert_id;
            $message = "✅ Success! New Batch '<b>{$batch_name}</b>' created successfully (ID: {$last_id}).";
            
            // Redirect to the manage page
            header("Location: manage-batches.php?msg=" . urlencode($message));
            exit();
        } else {
            $message = "❌ Error: Database insertion failed. " . $conn->error;
            $is_error = true;
        }
    }
}

// --- 4. HTML structure and output follow below ---
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Admin Panel - Add New Batch</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
    <style>
        /* Admin UI Style Consistency */
        body { font-family: 'Poppins', sans-serif; padding: 0; margin: 0; background-color: #f4f4f9; color: #333; }
        .wrapper { padding: 20px 40px; max-width: 900px; margin: 0 auto; }
        h1, h2 { color: #0f2b46; }
        
        /* Navigation Bar */
        .admin-nav { padding: 10px 0; margin-bottom: 20px; border-bottom: 2px solid #eee; }
        .admin-nav a { 
            color: #555; text-decoration: none; font-weight: 600; padding: 5px 10px; border-radius: 5px; 
            margin-right: 10px; transition: color 0.2s;
        }
        .admin-nav a:hover { color: #dc3545; }

/* Messages */
        .message { padding: 12px; border-radius: 6px; margin-bottom: 20px; font-weight: 600; }
        .success { background-color: #d4edda; color: #155724; border: 1px solid #c3e6cb; }
        .error { background-color: #f8d7da; color: #721c24; border: 1px solid #f5c6fb; }
        
        /* Form Card */
        .form-card { 
            background: white; 
            padding: 30px; 
            border-radius: 12px; 
            box-shadow: 0 4px 15px rgba(0,0,0,0.1); 
            border-top: 5px solid #0f2b46;
        }
        .form-group { margin-bottom: 18px; }
        label { display: block; font-weight: 600; color: #0f2b46; margin-bottom: 5px; }
        input[type="text"], input[type="number"], input[type="date"], textarea, select { 
            width: 100%; padding: 10px; border: 1px solid #ccc; border-radius: 4px; box-sizing: border-box; 
        }
        
        .form-grid {
            display: grid;
            grid-template-columns: 1fr 1fr;
            gap: 20px;
        }

.btn-add { 
            background-color: #28a745; 
            color: white; 
            padding: 12px 20px; 
            border: none; 
            border-radius: 6px; 
            cursor: pointer; 
            font-size: 16px; 
            margin-top: 20px; 
            font-weight: <b>bold</b>;
            width: 100%;
        }
        .btn-add:hover { background-color: #1e7e34; }
    </style>
</head>
<body>
    <div class="wrapper">
        
        <h1>➕ Add New Batch Schedule</h1>
        <div class="admin-nav">
            <a href="dashboard.php"><i class="fas fa-tachometer-alt"></i> Dashboard</a>
            <a href="manage-batches.php"><i class="fas fa-users"></i> Manage Batches</a>
            <a href="manage-courses.php"><i class="fas fa-book"></i> Courses</a>
        </div>
        <hr>

<?php if (!empty($message)): ?>
            <div class="message <?= $is_error ? 'error' : 'success' ?>">
                <?= strip_tags($message, '<b><strong><em><br>') ?>
            </div>
        <?php endif; ?>

<div class="form-grid">
                    <div class="form-group">
                        <label for="course_id">Select Course *</label>
                        <select name="course_id" id="course_id" required <?= ($is_error && $q_courses->num_rows === 0) ? 'disabled' : '' ?>>
                             <option value="">-- Select Course --</option>
                             <?php $q_courses->data_seek(0); // Reset pointer for output ?>
                             <?php while($course = $q_courses->fetch_assoc()): ?>
                                 <option value="<?= $course['course_id'] ?>" 
                                    <?= ($initial_course_id == $course['course_id'] || ($_POST['course_id'] ?? 0) == $course['course_id']) ? 'selected' : '' ?>>
                                     <?= htmlspecialchars($course['course_name']) ?> (Fees: ₹<?= number_format($course['fees'], 0) ?>)
                                 </option>
                             <?php endwhile; ?>
                        </select>
                    </div>

<div class="form-group">
                        <label for="teacher_id">Assign Lead Teacher *</label>
                        <select name="teacher_id" id="teacher_id" required <?= ($is_error && $q_teachers->num_rows === 0) ? 'disabled' : '' ?>>
                             <option value="">-- Select Teacher --</option>
                             <?php $q_teachers->data_seek(0); // Reset pointer for output ?>
                             <?php while($teacher = $q_teachers->fetch_assoc()): ?>
                                 <option value="<?= $teacher['teacher_id'] ?>" <?= (($_POST['teacher_id'] ?? 0) == $teacher['teacher_id']) ? 'selected' : '' ?>>
                                     <?= htmlspecialchars($teacher['full_name']) ?> (<?= htmlspecialchars($teacher['subject_expertise'] ?? 'General') ?>)
                                 </option>
                             <?php endwhile; ?>
                        </select>
                    </div>
                </div>

<div class="form-group">
                    <label for="batch_name">Batch Name *</label>
                    <input type="text" name="batch_name" id="batch_name" required placeholder="e.g., Evening Batch 6PM, Weekend Class" value="<?= htmlspecialchars($_POST['batch_name'] ?? '') ?>">
                </div>
                
                <div class="form-grid">
                    <div class="form-group">
                        <label for="start_date">Start Date *</label>
                        <input type="date" name="start_date" id="start_date" required value="<?= htmlspecialchars($_POST['start_date'] ?? date('Y-m-d')) ?>">
                    </div>

<div class="form-group">
                        <label for="end_date">Expected End Date (Optional)</label>
                        <input type="date" name="end_date" id="end_date" value="<?= htmlspecialchars($_POST['end_date'] ?? '') ?>">
                    </div>
                </div>

<div class="form-grid">
                    <div class="form-group">
                        <label for="timing">Class Timing *</label>
                        <input type="text" name="timing" id="timing" required placeholder="e.g., Mon-Fri 6:00 PM to 7:30 PM" value="<?= htmlspecialchars($_POST['timing'] ?? '') ?>">
                    </div>

<div class="form-group">
                        <label for="max_capacity">Maximum Student Capacity *</label>
                        <input type="number" name="max_capacity" id="max_capacity" required min="1" placeholder="e.g., 50" value="<?= htmlspecialchars($_POST['max_capacity'] ?? 30) ?>">
                    </div>
                </div>

<div class="form-group">
                    <label for="status">Batch Status *</label>
                    <select name="status" id="status" required>
                        <option value="Upcoming" <?= (($_POST['status'] ?? 'Upcoming') == 'Upcoming') ? 'selected' : '' ?>>Upcoming (Accepting applications)</option>
                        <option value="Active" <?= (($_POST['status'] ?? '') == 'Active') ? 'selected' : '' ?>>Active (Currently running)</option>
                        <option value="Completed" <?= (($_POST['status'] ?? '') == 'Completed') ? 'selected' : '' ?>>Completed (Finished)</option>
                    </select>
                </div>

<button type="submit" name="add_batch" class="btn-add">
                    <i class="fas fa-calendar-plus"></i> Create New Batch
                </button>
            </form>
            
            <p style="margin-top: 20px; text-align: center;">
                <a href="manage-batches.php" style="color: #0f2b46;">← Back to Batch List</a>
            </p>
        </div>
    </div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-batch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation