School Management System Project With Source Code: In Php

// 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');

if (mysqli_query($conn, $query)) { $student_id = mysqli_insert_id($conn); $username = strtolower($first_name . "." . $last_name); $default_password = password_hash($roll_no, PASSWORD_DEFAULT); mysqli_query($conn, "INSERT INTO users (username, password, role, related_id) VALUES ('$username', '$default_password', 'student', $student_id)"); $success = "Student added successfully. Username: $username, Password: $roll_no"; } else { $error = "Error: " . mysqli_error($conn); } } school management system project with source code in php

// Fetch marks $marks = mysqli_query($conn, "SELECT m.exam_type, s.subject_name, m.marks_obtained, m.max_marks FROM marks m JOIN subjects s ON m.subject_id = s.id WHERE m.student_id=$student_id"); ?> <h1>Welcome, <?= $student['first_name'] ?></h1> <h3>Recent Attendance</h3> <ul> <?php while($row = mysqli_fetch_assoc($attendance)): ?> <li><?= $row['date'] ?> - <?= $row['status'] ?></li> <?php endwhile; ?> </ul> // Fetch classes for dropdown $classes = mysqli_query($conn,

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!"; } $default_password = password_hash($roll_no