📚 Student Records Management System

📌 Overview

This is a simple PHP & MySQL web application for storing and retrieving secondary school student records. It allows:

• Students to register their details through a form.
• The school admin to view, edit, and delete records.
• Validation to ensure data integrity before saving.

---

✨ Features

• Student Registration Form with validation for required fields.
• Error Handling to catch and display validation or database errors.
• Database Storage using MySQL.
• Admin Panel to view all registered students.
• CRUD Operations (Create, Read, Update, Delete).

---

🛠️ Technologies Used

• PHP – Backend logic and server-side scripting.
• MySQL – Database storage for student records.
• HTML & CSS – User interface and form styling.

---

📂 Project Structure

project-folder/
│
├── config.php           # Database connection configuration
├── functions.php        # Validation and CRUD functions
├── register.php         # Student registration form
├── student_list.php     # Admin interface to view students
└── school_records.sql   # Database schema

---

⚙️ Installation & Setup

1️⃣ Clone the Repository

git clone https://github.com/yourusername/student-records.git
cd student-records

2️⃣ Create the Database

In phpMyAdmin or MySQL CLI:

CREATE DATABASE school_records;

USE school_records;

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(100) NOT NULL,
    last_name VARCHAR(100) NOT NULL,
    email VARCHAR(150) NOT NULL UNIQUE,
    phone VARCHAR(15) NOT NULL
);

3️⃣ Configure Database Connection

Edit config.php to match your local environment:

$host = 'localhost';
$username = 'root';
$password = '';
$database = 'school_records';

4️⃣ Run the Application

• Place the project in your htdocs (XAMPP) or www (WAMP) directory.
• Start Apache and MySQL from your local server.
• Visit:

http://localhost/student-records/register.php

---

🖥️ Usage

For Students:

• Fill out the registration form with your first name, last name, email, and phone number.
• Submit to register.

For Admins:

• Navigate to student_list.php to view all records.
• Edit or delete student details as needed (future enhancement).

---

📌 Validation Rules

• First Name – Required.
• Last Name – Required.
• Email – Required, must be a valid format.
• Phone – Required, 10-15 digits only.

---

🚀 Future Enhancements

• Add search & filter for students.
• Implement edit & delete functionality.
• Add login authentication for admins.
• Improve UI with a CSS framework like Bootstrap.

---

👨‍💻 Author

Anas Yakubu – PHP Developer

---