query($query);
if ($result->num_rows > 0) {
$student_data = $result->fetch_assoc();
session_start();
$_SESSION['student_id'] = $student_data['id'];
header('Location: student_portal.php');
exit;
} else {
$error = 'Invalid email or password';
}
}
// Display student result
if (isset($_SESSION['student_id'])) {
$student_id = $_SESSION['student_id'];
$query = "SELECT * FROM results WHERE student_id = '$student_id'";
$result = $conn->query($query);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "Subject: ". $row['subject_id']. ", Mark: ". $row['mark']. "
";
}
} else {
echo "No results found";
}
}
// Student admission form
if (isset($_POST['admission'])) {
$name = $_POST['name'];
$email = $_POST['email'];
$password = $_POST['password'];
$query = "INSERT INTO students (name, email, password) VALUES ('$name', '$email', '$password')";
$conn->query($query);
header('Location: student_portal.php');
exit;
}
?>
Student Portal
Student Portal
Results:
Admission Form: