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

<?php include ('header.php');
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
if (isset($_POST['check_regno']) && isset($_POST['regno'])) {

$regno = mysqli_real_escape_string($con, trim($_POST['regno']));

$checkSql = "SELECT student_id FROM student WHERE student_regno = '$regno' AND delete_status = 0";
    $res = mysqli_query($con, $checkSql);

if (mysqli_num_rows($res) > 0) {
        echo "Registration number already exists.";
    }
    exit; 
}

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'];
    $added_date = date('Y-m-d H:i:s');
    
$check = mysqli_query($con, "SELECT student_id FROM student WHERE student_regno = '$student_regno' AND delete_status = 0");
if (mysqli_num_rows($check) > 0) {
    echo "<script>alert('Registration number already exists!'); history.back();</script>";
    exit;
}

$sql = "INSERT INTO `student` (student_regno, student_name, ref_class_id, ref_section_id, mobile_no, member_type, guardian_name, ref_status_id, added_date, delete_status)
            VALUES ('$student_regno', '$student_name', '$ref_class_id', '$ref_section_id', '$mobile_no', '1', '$guardian_name', '$ref_status_id', '$added_date', '0')";
    //echo $sql;die();
    if (mysqli_query($con, $sql)) {
        echo "<script>
            alert('Student added successfully!');
            window.location.href = 'studentslist.php';
        </script>";
        exit;
    } else {
        echo "<script>alert('Error adding student.');</script>";
    }
}

<div class="main-content">

<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">Add 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">Add 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">Add Student</h3 style="color: #20478a;">
                        </div>
                        <div class="card-body">
                            <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post"
                                enctype="multipart/form-data">

<div class="col-md-2">
                                            <label><b>Registration No </b></label>

<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)) {
                echo '<option value="' . $row['class_id'] . '">' . $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)){
                                                        echo '<option value=" '.$row['section_id'].'">' . $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"
    maxlength="10"
    pattern="\d{10}"
    oninput="this.value = this.value.replace(/\D/g, '').slice(0, 10)"
    required
>

</div>

<div class="col-md-3"><br>
                                            <label><b>Guardian Name</b></label>
                                            <input type="text" name="guardian_name" id="guardian_name"
                                                class="form-control" placeholder="Enter" 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)) {
            echo '<option value="' . $row['status_id'] . '">' . $row['status_name'] . '</option>';
        }
    }
    ?>
                                            </select>
                                        </div>
                                        <div class="row">
    <div class="col-md-4"><br>
        <input type="submit" class="me-3 btn btn-success" name="submit" value="Submit">
        <button type="button" class="btn btn-warning    " onclick="history.back()">Cancel</button>
    </div>
</div>

</div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <script>
            document.getElementById("student_regno").addEventListener("blur", function () {
    const regno = this.value.trim();

if (regno !== '') {
        const formData = new FormData();
        formData.append('check_regno', 1);
        formData.append('regno', regno);

fetch(window.location.href, {
            method: 'POST',
            body: formData
        })
        .then(res => res.text())
        .then(data => {
            document.getElementById("regno_msg").textContent = data.trim();
        });
    }
});

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

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation