School Management System Project With Source Code In Php Link

<table> <?php while($s = mysqli_fetch_assoc($students)): ?> <tr> <td><?= $s['first_name'] . " " . $s['last_name'] ?></td> <td> <select name="attendance[<?= $s['id'] ?>]"> <option value="present">Present</option> <option value="absent">Absent</option> <option value="late">Late</option> </select> </td> </tr> <?php endwhile; ?> </table> <button type="submit">Save Attendance</button> </form> <?php require_once '../config/db_connection.php'; require_once '../includes/auth.php'; $student_id = $_SESSION['related_id'];

if (mysqli_num_rows($result) == 1) { $user = mysqli_fetch_assoc($result); if (password_verify($password, $user['password'])) { $_SESSION['user_id'] = $user['id']; $_SESSION['role'] = $user['role']; $_SESSION['related_id'] = $user['related_id']; switch ($user['role']) { case 'admin': header("Location: admin/dashboard.php"); break; case 'teacher': header("Location: teacher/dashboard.php"); break; case 'student': header("Location: student/dashboard.php"); break; } } else { $error = "Invalid password"; } } else { $error = "User not found"; } } ?> <!-- HTML Form --> <form method="POST"> <input type="text" name="username" required> <input type="password" name="password" required> <button type="submit">Login</button> <?php if(isset($error)) echo "<p>$error</p>"; ?> </form> <?php require_once '../config/db_connection.php'; require_once '../includes/auth.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $roll_no = $_POST['roll_no']; $class_id = $_POST['class_id']; $section = $_POST['section']; $parent_mobile = $_POST['parent_mobile']; $address = $_POST['address']; $dob = $_POST['dob']; $admission_date = $_POST['admission_date']; school management system project with source code in php

if ($_SERVER['REQUEST_METHOD'] == 'POST') { foreach ($_POST['attendance'] as $student_id => $status) { $check = mysqli_query($conn, "SELECT id FROM attendance WHERE student_id=$student_id AND date='$date'"); if (mysqli_num_rows($check) > 0) { mysqli_query($conn, "UPDATE attendance SET status='$status' WHERE student_id=$student_id AND date='$date'"); } else { mysqli_query($conn, "INSERT INTO attendance (student_id, class_id, date, status) VALUES ($student_id, $class_id, '$date', '$status')"); } } $success = "Attendance saved!"; } &lt;table&gt; &lt;

$query = "SELECT * FROM users WHERE username='$username'"; $result = mysqli_query($conn, $query); null; $date = date('Y-m-d');

// Fetch classes for dropdown $classes = mysqli_query($conn, "SELECT * FROM classes"); ?> <!-- HTML form for adding student --> <?php require_once '../config/db_connection.php'; require_once '../includes/auth.php'; $teacher_id = $_SESSION['related_id']; $class_id = $_GET['class_id'] ?? null; $date = date('Y-m-d');