Student registration
CREATE DATABASE student_db;
USE student_db;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) UNIQUE,
password VARCHAR(255)
);
CREATE TABLE exam_registration (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
roll VARCHAR(20),
email VARCHAR(100),
course VARCHAR(50)
);
-- Insert test user
INSERT INTO users (username, password) VALUES ('testuser', MD5('test123'));
index.php
<?php
session_start();
$host = "localhost";
$username = "root";
$password = "";
$database = "student_db";
$conn = new mysqli($host, $username, $password, $database);
if ($conn->connect_error) die("Connection failed: " . $conn->connect_error);
// Handle Login
if (isset($_POST['login'])) {
$user = $_POST['username'];
$pass = md5($_POST['password']); // simple hash
$result = $conn->query("SELECT * FROM users WHERE username='$user' AND password='$pass'");
if ($result->num_rows == 1) {
$_SESSION['user'] = $user;
} else {
echo "<p>Invalid login!</p>";
}
}
// Handle Logout
if (isset($_GET['logout'])) {
session_destroy();
header("Location: index.php");
exit;
}
// Handle Registration
if (isset($_POST['register'])) {
if (!isset($_SESSION['user'])) {
echo "Please login first!";
exit;
}
$name = $_POST['name'];
$roll = $_POST['roll'];
$email = $_POST['email'];
$course = $_POST['course'];
if ($name && $roll && $email && $course) {
$stmt = $conn->prepare("INSERT INTO exam_registration (name, roll, email, course) VALUES (?, ?, ?, ?)");
$stmt->bind_param("ssss", $name, $roll, $email, $course);
$stmt->execute();
echo "<p>Registration Successful!</p>";
} else {
echo "<p>All fields are required!</p>";
}
}
?>
<!DOCTYPE html>
<html>
<head><title>Login & Registration</title></head>
<body>
<?php if (!isset($_SESSION['user'])): ?>
<h2>Login</h2>
<form method="post">
Username: <input name="username" required><br><br>
Password: <input type="password" name="password" required><br><br>
<input type="submit" name="login" value="Login">
</form>
<?php else: ?>
<h2>Welcome, <?= $_SESSION['user'] ?> | <a href="?logout=true">Logout</a></h2>
<h3>Exam Registration Form</h3>
<form method="post">
Name: <input name="name" required><br><br>
Roll Number: <input name="roll" required><br><br>
Email: <input type="email" name="email" required><br><br>
Course:
<select name="course" required>
<option value="">--Select--</option>
<option value="Math">Math</option>
<option value="Science">Science</option>
</select><br><br>
<input type="submit" name="register" value="Register">
</form>
<?php endif; ?>
</body>
</html>
Comments
Post a Comment