School Management System Project | With Source Code In Php

$query = "SELECT * FROM users WHERE username='$username'"; $result = mysqli_query($conn, $query);

$query = "INSERT INTO students (first_name, last_name, roll_no, class_id, section, parent_mobile, address, dob, admission_date) VALUES ('$first_name', '$last_name', '$roll_no', $class_id, '$section', '$parent_mobile', '$address', '$dob', '$admission_date')";

// Fetch student details $student = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM students WHERE id=$student_id")); 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>

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!"; } $query = "SELECT * FROM users WHERE username='$username'";

// Get classes taught by this teacher $classes_taught = mysqli_query($conn, "SELECT DISTINCT class_id FROM subjects WHERE teacher_id=$teacher_id"); $students = []; if ($class_id) { $students = mysqli_query($conn, "SELECT * FROM students WHERE class_id=$class_id"); } ?> <form method="POST"> <select name="class_id" onchange="this.form.submit()"> <option value="">Select Class</option> <?php while($row = mysqli_fetch_assoc($classes_taught)): ?> <option value="<?= $row['class_id'] ?>" <?= $class_id == $row['class_id'] ? 'selected' : '' ?>> Class <?= $row['class_id'] ?> </option> <?php endwhile; ?> </select>

if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } ?> <?php session_start(); if (!isset($_SESSION['user_id'])) { header("Location: ../login.php"); exit(); } ?> 5.3 Login Script ( login.php ) <?php session_start(); require_once 'config/db_connection.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { $username = mysqli_real_escape_string($conn, $_POST['username']); $password = $_POST['password']; $result = mysqli_query($conn

// Fetch recent attendance $attendance = mysqli_query($conn, "SELECT date, status FROM attendance WHERE student_id=$student_id ORDER BY date DESC LIMIT 10");