This is a simple CRUD (Create, Read, Update, Delete) application built using PHP, MySQL, and Bootstrap.
It allows you to manage student records with an easy-to-use web interface.
- β Add new student
- π View all students
- βοΈ Update student data
- β Delete student
- π¨ Clean UI using Bootstrap
- π MySQL database connection via MySQLi
- π Redirect messages for success/error actions
| Technology | Purpose |
|---|---|
| PHP | Backend logic |
| MySQL | Database storage |
| Bootstrap | Styling |
| HTML/CSS | Frontend |
| XAMPP | Local server |
Your folder looks like this:
CRUD_APP/
βββ dbconnection.php # Database connection file
βββ delete_page.php # Delete logic
βββ footer.php # Footer layout
βββ header.php # Header + navigation bar
βββ index.php # Displays all students
βββ insert_data.php # Insert student logic
βββ update_page_1.php # Update student page
βββ style.css # Custom styling (optional)
Each file plays a specific role:
Handles MySQL connection using mysqli_connect().
Shows all data from the database in a Bootstrap table.
Processes new student form and inserts data into MySQL.
Loads selected student info, updates record when submitted.
Deletes the selected student record.
Reusable layout components for cleaner code.
Your custom styling (optional).
git clone https://github.com/your-username/crud-app-php.gitC:/xampp/htdocs/CRUD_APP/
Open phpMyAdmin, then run:
CREATE DATABASE crud_app;
USE crud_app;
CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
firstName VARCHAR(100),
lastName VARCHAR(100),
age INT
);http://localhost/CRUD_APP/
insert_data.php adds student to DB.
index.php displays all student data.
update_page_1.php loads selected student β updates them.
delete_page.php removes student from DB.
Delete
- Validation messages
- Search bar
- Pagination
- Login system
- Improved UI with custom CSS
Raj Chauhan Project created with passion β€οΈ Portfolio: https://itsdevrajchauhan.netlify.app
This project is fully open-source. Feel free to use or modify it for your learning.


