Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/avatar_coupon/admin

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: editstudents.php

<?php 
include('header.php');

if (!isset($_GET['id']) || empty($_GET['id'])) {
    echo "<script> alert('Invalid student ID'); window.location.href='studentslist.php'; </script>";
    exit;
}

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

// Fetch existing student data
$sql = "SELECT * FROM student WHERE student_id = $student_id AND delete_status = 0 LIMIT 1";
$result = mysqli_query($con, $sql);

if (!$result || mysqli_num_rows($result) == 0) {
    echo "<script> alert('Student not found'); window.location.href='studentslist.php'; </script>";
    exit;
}

$student = mysqli_fetch_assoc($result);

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $student_regno = $_POST['student_regno'];
    $student_name = $_POST['student_name'];
    $ref_class_id = $_POST['ref_class_id'];
    $ref_section_id = $_POST['ref_section_id'];
    $mobile_no = $_POST['mobile_no'];
    $guardian_name = $_POST['guardian_name'];
    $ref_status_id = $_POST['ref_status_id'];

$updated_date = date('Y-m-d H:i:s');

$update_sql = "UPDATE student SET 
        student_regno = '$student_regno',
        student_name = '$student_name',
        ref_class_id = '$ref_class_id',
        ref_section_id = '$ref_section_id',
        mobile_no = '$mobile_no',
        guardian_name = '$guardian_name',
        ref_status_id = '$ref_status_id',
        modified_date = '$updated_date'
        WHERE student_id = $student_id";

if (mysqli_query($con, $update_sql)) {
        echo "<script>
            alert('Student updated successfully!');
            window.location.href = 'studentslist.php';
        </script>";
        exit;
    } else {
        echo "<script>alert('Error updating student.');</script>";
    }
}

<div class="row">
                <div class="col-12">
                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0">Edit Student</h4>
                        <div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                                <li class="breadcrumb-item active">Edit Student</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

<div class="row">
                <div class="col-xl">
                    <div class="card mb-4">
                        <div class="card-header text-center">
                            <h3 style="color: #20478a;" class="mb-0">Edit Student</h3>
                        </div>
                        <div class="card-body">
                            <form action="<?php echo htmlspecialchars($_SERVER['REQUEST_URI']); ?>" method="post" enctype="multipart/form-data">

<div class="row g-3">
                                    <div class="col-md-2">
                                        <label><b>Registration No</b></label>
                                        <input type="text" name="student_regno" class="form-control" placeholder="Enter" 
                                            value="<?php echo htmlspecialchars($student['student_regno']); ?>" required>
                                    </div>

<div class="col-md-3">
                                        <label><b>Name</b></label>
                                        <input type="text" name="student_name" id="student_name" class="form-control" placeholder="Enter" 
                                            value="<?php echo htmlspecialchars($student['student_name']); ?>" required>
                                    </div>

<div class="col-md-2">
                                        <label><b>Class</b></label>
                                        <select name="ref_class_id" class="form-control" required>
                                            <option value="">-- Select --</option>
                                            <?php
                                            $query = "SELECT class_id, class_name FROM class ORDER BY class_id ASC";
                                            $result = mysqli_query($con, $query);
                                            if ($result) {
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    $selected = ($row['class_id'] == $student['ref_class_id']) ? 'selected' : '';
                                                    echo '<option value="' . $row['class_id'] . '" '.$selected.'>' . $row['class_name'] . '</option>';
                                                }
                                            }
                                            ?>
                                        </select>
                                    </div>

<div class="col-md-3">
                                        <label><b>Section</b></label>
                                        <select name="ref_section_id" class="form-control" required>
                                            <option value="">-- Select --</option>
                                            <?php 
                                            $sql = "SELECT section_id, section_name FROM section ORDER BY section_id ASC";
                                            $result = mysqli_query($con,$sql);
                                            if($result){
                                                while($row=mysqli_fetch_assoc($result)){
                                                    $selected = ($row['section_id'] == $student['ref_section_id']) ? 'selected' : '';
                                                    echo '<option value="'.$row['section_id'].'" '.$selected.'>' . $row['section_name'] . '</option>';
                                                }
                                            }
                                            ?>
                                        </select>
                                    </div>

<div class="col-md-2">
                                        <label><b>Mobile Number</b></label>
                                        <input type="text" name="mobile_no" class="form-control" placeholder="Enter" 
                                            value="<?php echo htmlspecialchars($student['mobile_no']); ?>" required>
                                    </div>

<div class="col-md-3"><br>
                                        <label><b>Father Name</b></label>
                                        <input type="text" name="guardian_name" id="guardian_name" class="form-control" placeholder="Enter" 
                                            value="<?php echo htmlspecialchars($student['guardian_name']); ?>" required>
                                    </div>

<div class="col-md-2"><br>
                                        <label><b>Status</b></label>
                                        <select name="ref_status_id" class="form-control" required>
                                            <option value="">-- Select --</option>
                                            <?php 
                                            $sql = "SELECT status_id, status_name FROM status ORDER BY status_id ASC";
                                            $result = mysqli_query($con, $sql);
                                            if ($result){
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    $selected = ($row['status_id'] == $student['ref_status_id']) ? 'selected' : '';
                                                    echo '<option value="' . $row['status_id'] . '" '.$selected.'>' . $row['status_name'] . '</option>';
                                                }
                                            }
                                            ?>
                                        </select>
                                    </div>

<div class="row mt-3">
                                        <div class="col-md-4">
                                            <input type="submit" class="btn btn-success" name="submit" value="Update">
                                            <button type="button" class="btn btn-warning    " onclick="history.back()">Cancel</button>

</div>
                                    </div>

</div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

</div>
    </div>
</div>

function capitalizeWords(input) {
    let value = input.value.toLowerCase().replace(/\b\w/g, function (char) {
        return char.toUpperCase();
    });
    input.value = value;
}

document.getElementById('student_name').addEventListener('input', function () {
    capitalizeWords(this);
});

document.getElementById('guardian_name').addEventListener('input', function () {
    capitalizeWords(this);
});
</script>

<?php include('footer.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: editstudents.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation