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: editteacher.php

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

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

$teacher_id = intval($_GET['id']);

$query = "SELECT * FROM student WHERE student_id = $teacher_id AND delete_status = 0";
$result = mysqli_query($con, $query);

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

$teacher = mysqli_fetch_assoc($result);

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $teacher_regno = mysqli_real_escape_string($con, $_POST['teacher_regno']);
    $teacher_name = mysqli_real_escape_string($con, $_POST['teacher_name']);
    $mobile_no = mysqli_real_escape_string($con, $_POST['mobile_no']);
    $ref_status_id = intval($_POST['ref_status_id']);

// Check if regno is taken by another record
    $check = mysqli_query($con, "SELECT student_id FROM student WHERE student_regno = '$teacher_regno' AND student_id != $teacher_id AND delete_status = 0");
    if (mysqli_num_rows($check) > 0) {
        echo "<script>alert('Registration number already exists!'); history.back();</script>";
        exit;
    }

$sql = "UPDATE student SET 
                student_regno = '$teacher_regno', 
                student_name = '$teacher_name',
                mobile_no = '$mobile_no',
                ref_status_id = '$ref_status_id'
            WHERE student_id = $teacher_id";

if (mysqli_query($con, $sql)) {
        echo "<script>alert('Teacher updated successfully!'); window.location.href='teacherlist.php';</script>";
        exit;
    } else {
        echo "<script>alert('Error updating teacher.');</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 Teacher</h4>
                    </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 Teacher</h3>
                        </div>
                        <div class="card-body">
                            <form method="post" action="">
                                <div class="row">
                                    <div class="col-md-2">
                                        <label><b>Registration No</b></label>
                                        <input type="text" name="teacher_regno" class="form-control" required
                                               value="<?php echo htmlspecialchars($teacher['student_regno']); ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label><b>Name</b></label>
                                        <input type="text" name="teacher_name" class="form-control" required
                                               value="<?php echo htmlspecialchars($teacher['student_name']); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label><b>Mobile Number</b></label>
                                        <input type="text" name="mobile_no" class="form-control" maxlength="10" required
                                               pattern="\d{10}" oninput="this.value = this.value.replace(/\D/g, '').slice(0, 10)"
                                               value="<?php echo htmlspecialchars($teacher['mobile_no']); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label><b>Status</b></label>
                                        <select name="ref_status_id" class="form-control" required>
                                            <option value="">-- Select --</option>
                                            <?php
                                            $status_sql = "SELECT status_id, status_name FROM status ORDER BY status_id ASC";
                                            $status_result = mysqli_query($con, $status_sql);
                                            while ($status = mysqli_fetch_assoc($status_result)) {
                                                $selected = ($status['status_id'] == $teacher['ref_status_id']) ? 'selected' : '';
                                                echo '<option value="' . $status['status_id'] . '" ' . $selected . '>' . $status['status_name'] . '</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    <div class="row">
                                        <div class="col-md-4"><br>
                                            <input type="submit" class="btn btn-success" value="Update">
                                            <a href="teacherlist.php" class="btn btn-warning">Cancel</a>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div> 
                    </div> 
                </div>
            </div>
        </div>
    </div>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: editteacher.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation