Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u530111037

Directory:

/home/u530111037/domains/goodcharacteropc.com/public_html/working.old/admin

Free Space:

3.3 TB

🔧 Quick Actions

✏️ Editing: oldWorkingStudents.php

<?php
// students.php (single file: index + add + edit via GET)
require_once __DIR__ . '/../db.php';
require_once './../header.php';

require_admin();

// -------- Helpers ----------
function fetch_schools(mysqli $db): array {
    $rows = [];
    $res = $db->query("SELECT id, name FROM schools ORDER BY name ASC");
    while ($r = $res->fetch_assoc()) $rows[] = $r;
    return $rows;
}

function fetch_student(mysqli $db, int $id): ?array {
    $stmt = $db->prepare("
        SELECT s.*, sc.name AS school_name
        FROM students s
        JOIN schools sc ON sc.id = s.school_id
        WHERE s.id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $res = $stmt->get_result();
    return $res->num_rows ? $res->fetch_assoc() : null;
}

// -------- Mode detection ----------
$is_add  = isset($_GET['add']);
$edit_id = isset($_GET['edit']) ? (int)$_GET['edit'] : 0;

// -------- POST handlers (PRG) ----------
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // ADD
    if ($is_add && isset($_POST['save'])) {
        $full_name     = trim($_POST['full_name'] ?? '');
        $student_phone = (int)($_POST['student_phone'] ?? 0);
        $parent_phone  = (int)($_POST['parent_phone'] ?? 0);
        $standard      = trim($_POST['standard'] ?? '');
        $email         = trim($_POST['email'] ?? '');
        $password      = trim($_POST['password'] ?? '');
        $school_id     = (int)($_POST['school_id'] ?? 0);
        $language      = $_POST['language'] === 'urdu' ? 'urdu' : 'english';
        $active        = ($_POST['active'] ?? 'y') === 'n' ? 'n' : 'y';

// Basic validations
        $errors = [];
        if ($full_name === '') $errors[] = 'Full name is required';
        if ($standard === '') $errors[] = 'Standard is required';
        if ($email === '') $errors[] = 'Email is required';
        if ($password === '') $errors[] = 'Password is required';
        if ($school_id <= 0) $errors[] = 'School is required';

// Unique email check
        $stmt = $mysqli->prepare("SELECT id FROM students WHERE email = ? LIMIT 1");
        $stmt->bind_param("s", $email);
        $stmt->execute();
        if ($stmt->get_result()->num_rows) $errors[] = 'Email already exists';

if (!empty($errors)) {
            // Keep form with errors via GET
            $msg = urlencode(implode(', ', $errors));
            header("Location: students.php?add=1&err=$msg");
            exit;
        }

$password_hash = password_hash($password, PASSWORD_DEFAULT);
        $stmt = $mysqli->prepare("
            INSERT INTO students
              (full_name, student_phone, parent_phone, standard, email, password_hash, school_id, language, active)
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
        $stmt->bind_param(
            "siisssiss",
            $full_name, $student_phone, $parent_phone, $standard, $email, $password_hash, $school_id, $language, $active
        );
        $stmt->execute();

header("Location: students.php?msg=added");
        exit;
    }

// EDIT
    if ($edit_id && isset($_POST['update'])) {
      print_r($_POST);
        $full_name     = trim($_POST['full_name'] ?? '');
        $student_phone = (int)($_POST['student_phone'] ?? 0);
        $parent_phone  = (int)($_POST['parent_phone'] ?? 0);
        $standard      = trim($_POST['standard'] ?? '');
        $email         = trim($_POST['email'] ?? '');
        $password      = trim($_POST['password'] ?? ''); // optional
        $school_id     = (int)($_POST['school_id'] ?? 0);
        $language      = $_POST['language'] === 'urdu' ? 'urdu' : 'english';
        $active        = ($_POST['active'] ?? 'y') === 'n' ? 'n' : 'y';

// Validations
        $errors = [];
        if ($full_name === '') $errors[] = 'Full name is required';
        if ($standard === '') $errors[] = 'Standard is required';
        if ($email === '') $errors[] = 'Email is required';
        if ($school_id <= 0) $errors[] = 'School is required';

// Unique email check (exclude current)
        $stmt = $mysqli->prepare("SELECT id FROM students WHERE email = ? AND id <> ? LIMIT 1");
        $stmt->bind_param("si", $email, $edit_id);
        $stmt->execute();
        if ($stmt->get_result()->num_rows) $errors[] = 'Email already exists for another student';

if (!empty($errors)) {
            $msg = urlencode(implode(', ', $errors));
            header("Location: students.php?edit=$edit_id&err=$msg");
            exit;
        }

if ($password != '') {
            $password_hash = password_hash($password, PASSWORD_DEFAULT);
            $stmt = $mysqli->prepare("
                UPDATE students
                   SET full_name=?, student_phone=?, parent_phone=?, standard=?, email=?, password_hash=?, school_id=?, language=?, active=?
                 WHERE id=?");
            $stmt->bind_param(
                "siisssissi",
                $full_name, $student_phone, $parent_phone, $standard, $email, $password_hash, $school_id, $language, $active, $edit_id
            );
        } else {
            $stmt = $mysqli->prepare("
                UPDATE students
                   SET full_name=?, student_phone=?, parent_phone=?, standard=?, email=?, school_id=?, language=?, active=?
                 WHERE id=?");
            $stmt->bind_param(
                "siississi",
                $full_name, $student_phone, $parent_phone, $standard, $email, $school_id, $language, $active, $edit_id
            );
        }
        $stmt->execute();

header("Location: students.php?msg=updated");
        exit;
    }
}

// -------- Data for views ----------
$schools = fetch_schools($mysqli);
$msg  = isset($_GET['msg']) ? $_GET['msg'] : '';
$err  = isset($_GET['err']) ? $_GET['err'] : '';

$student = null;
if ($edit_id) {
    $student = fetch_student($mysqli, $edit_id);
    if (!$student) { header("Location: students.php?err=Student+not+found"); exit; }
}

// Students list (index)
$students = [];
if (!$is_add && !$edit_id) {
    $res = $mysqli->query("
        SELECT s.*, sc.name AS school_name
        FROM students s
        JOIN schools sc ON sc.id = s.school_id
        ORDER BY s.id DESC
    ");
    while ($r = $res->fetch_assoc()) $students[] = $r;
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Students</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<style>
.container-narrow{max-width:1100px}
.select2-container .select2-selection--single{height:38px;}
.select2-selection__rendered{line-height:38px !important;}
.select2-selection__arrow{height:38px !important;}
</style>
</head>
<body class="p-0 pb-3">
<div class="pt-3 container-fluid">

<div class="d-flex justify-content-between align-items-center mb-1">
    <h3 class="m-0">
      <?php if ($is_add): ?>
        <div class="mb-0">
            <a href="students.php" class="btn btn-outline-secondary" style="padding: 2px 8px !important; border-radius: 50%; background: gray; color: white">←</a>
            <span style="padding-left: 5px; font-size: 16px"><b>Students - Create</b></span>
        </div>

<?php elseif ($edit_id): ?>
        <div class="mb-0">
            <a href="students.php" class="btn btn-outline-secondary" style="padding: 2px 8px !important; border-radius: 50%; background: gray; color: white">←</a>
            <span style="padding-left: 5px; font-size: 16px"><b>Students - Edit</b></span>
        </div>

<?php else: ?>
        <div class="mb-0">
            
            <span style="padding-left: 5px; font-size: 16px"><b>Students - List</b></span>
        </div>
      <?php endif; ?>

</h3>
    <?php if (!$is_add && !$edit_id): ?>
      <div>
        <a class="btn btn-sm btn-success" href="students.php?add=1">+ Add Student</a>
      </div>
    <?php else: ?>

<?php endif; ?>
  </div>

<?php if ($err): ?>
    <div class="alert alert-danger py-2"><?= e($err) ?></div>
  <?php endif; ?>

<?php if (!$is_add && !$edit_id): ?>
    <div class="card">
      <div class="card-body p-0">
        <table class="table table-hover align-middle m-0">
          <thead class="table-dark">
            <tr>
              <th>ID</th>
              <th>Name</th>
              <th>School</th>
              <th>Standard</th>
              <th>Student Phone</th>
              <th>Email</th>
              <th>Language</th>
              <th>Active</th>
              <th></th>
            </tr>
          </thead>
          <tbody>
            <?php if (empty($students)): ?>
              <tr><td colspan="9" class="text-center text-muted py-4">No students found.</td></tr>
            <?php else: foreach ($students as $st): ?>
              <tr>
                <td><?= $st['id'] ?></td>
                <td><?= e($st['full_name']) ?></td>
                <td><?= e($st['school_name']) ?></td>
                <td><?= e($st['standard']) ?></td>
                <td><?= e($st['student_phone']) ?></td>
                <td><?= e($st['email']) ?></td>
                <td><?= ucfirst($st['language']) ?></td>
                <td><?= strtoupper($st['active']) ?></td>
                <td>
                  <a class="btn btn-sm btn-warning" href="students.php?edit=<?= $st['id'] ?>">Edit</a>
                </td>
              </tr>
            <?php endforeach; endif; ?>
          </tbody>
        </table>
      </div>
    </div>
  <?php endif; ?>

<?php if ($is_add): ?>
    <div class="card">
        <form method="post" action="students.php?add=1" autocomplete="off">
          <div class="card-header">
            Student Details
            <a href="/admin/students.php" class="btn btn-danger btn-sm" style="float: right;">Cancel</a>
            <button class="btn btn-success btn-sm" style="float: right; margin-right: 2px;">Save</button>
          </div>
          <div class="card-body">
          <input type="hidden" name="save" value="1">

<div class="row g-3">
            <div class="col-md-12">
              <label class="form-label">Student ID</label>
              <input class="form-control" placeholder="Auto" disabled>
            </div>
            <div class="col-md-12">
              <label class="form-label">Student Full Name</label>
              <input class="form-control" name="full_name" required>
            </div>
            <div class="col-md-6">
              <label class="form-label">Standard</label>
              <input class="form-control" name="standard" required>
            </div>
            <div class="col-md-6">
              <label class="form-label">Language</label>
              <select class="form-select" name="language">
                <option value="english">English</option>
                <option value="urdu">Urdu</option>
              </select>
            </div>

<div class="col-md-6">
              <label class="form-label">Student Phone No</label>
              <input class="form-control" name="student_phone" type="number" required>
            </div>
            <div class="col-md-6">
              <label class="form-label">Parent Phone No</label>
              <input class="form-control" name="parent_phone" type="number" required>
            </div>

<div class="col-md-6">
              <label class="form-label">Email</label>
              <input class="form-control" name="email" type="email" required>
            </div>
            <div class="col-md-6">
              <label class="form-label">School</label>
              <select class="form-select select2" name="school_id" required>
                <option value="">Select a school…</option>
                <?php foreach ($schools as $sc): ?>
                  <option value="<?= $sc['id'] ?>"><?= e($sc['name']) ?></option>
                <?php endforeach; ?>
              </select>
            </div>

<div class="col-md-12">
              <label class="form-label">Password</label>
              <input class="form-control" name="password" type="password" required>
            </div>

<div class="col-md-12">
              <label class="form-label">Active</label>
              <select class="form-select" name="active">
                <option value="y" selected>Y</option>
                <option value="n">N</option>
              </select>
            </div>

</div>

<div class="mt-4">
            <button class="btn btn-success">Save</button>
            <a class="btn btn-danger" href="students.php">Cancel</a>
          </div>
        </div>
      </form>
    </div>
  <?php endif; ?>

<?php if ($edit_id && $student): ?>
    <div class="card">
        <form method="post" action="students.php?edit=<?= $edit_id ?>" autocomplete="off">
          <div class="card-header">
            Student Details
            <a href="/admin/students.php" class="btn btn-danger btn-sm" style="float: right;">Cancel</a>
            <button class="btn btn-success btn-sm" style="float: right; margin-right: 2px;">Update</button>
          </div>
          <div class="card-body">
            <input type="hidden" name="update" value="1">

<div class="row g-3">
              <div class="col-md-12">
                <label class="form-label">Student ID</label>
                <input class="form-control" value="<?= $_GET['edit'] ?>" disabled>
              </div>
              <div class="col-md-12">
                <label class="form-label">Student Full Name</label>
                <input class="form-control" name="full_name" value="<?= e($student['full_name']) ?>" required>
              </div>
              <div class="col-md-6">
                <label class="form-label">Standard</label>
                <input class="form-control" name="standard" value="<?= e($student['standard']) ?>" required>
              </div>
              <div class="col-md-6">
                <label class="form-label">Language</label>
                <select class="form-select" name="language">
                  <option value="english" <?= $student['language']==='english'?'selected':''; ?>>English</option>
                  <option value="urdu" <?= $student['language']==='urdu'?'selected':''; ?>>Urdu</option>
                </select>
              </div>

<div class="col-md-6">
                <label class="form-label">Student Phone No</label>
                <input class="form-control" name="student_phone" type="number" value="<?= e($student['student_phone']) ?>" required>
              </div>
              <div class="col-md-6">
                <label class="form-label">Parent Phone No</label>
                <input class="form-control" name="parent_phone" type="number" value="<?= e($student['parent_phone']) ?>" required>
              </div>

<div class="col-md-6">
                <label class="form-label">Email</label>
                <input class="form-control" name="email" type="email" value="<?= e($student['email']) ?>" required>
              </div>

<div class="col-md-6">
                <label class="form-label">School</label>
                <select class="form-select select2" name="school_id" required>
                  <option value="">Select a school…</option>
                  <?php foreach ($schools as $sc): ?>
                    <option value="<?= $sc['id'] ?>" <?= (int)$student['school_id']===(int)$sc['id']?'selected':''; ?>>
                      <?= e($sc['name']) ?>
                    </option>
                  <?php endforeach; ?>
                </select>
              </div>

<div class="col-md-12">
                <label class="form-label">Password <small class="text-muted">(leave blank to keep unchanged)</small></label>
                <input class="form-control" name="password" type="password" placeholder="••••••••">
              </div>

<div class="col-md-12">
                <label class="form-label">Active</label>
                <select class="form-select" name="active">
                  <option value="y" <?= $student['active']==='y'?'selected':''; ?>>Y</option>
                  <option value="n" <?= $student['active']==='n'?'selected':''; ?>>N</option>
                </select>
              </div>
            </div>

</div>
        </form>
    </div>
  <?php endif; ?>

</div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: oldWorkingStudents.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation