Skip to content

itsdevrajchauhan/crud_app

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

6 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

CRUD Application in PHP & MySQL

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.


πŸš€ Features

  • βž• 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

πŸ› οΈ Technologies Used

Technology Purpose
PHP Backend logic
MySQL Database storage
Bootstrap Styling
HTML/CSS Frontend
XAMPP Local server

πŸ“‚ Project Structure

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:

βœ” dbconnection.php

Handles MySQL connection using mysqli_connect().

βœ” index.php

Shows all data from the database in a Bootstrap table.

βœ” insert_data.php

Processes new student form and inserts data into MySQL.

βœ” update_page_1.php

Loads selected student info, updates record when submitted.

βœ” delete_page.php

Deletes the selected student record.

βœ” header.php / footer.php

Reusable layout components for cleaner code.

βœ” style.css

Your custom styling (optional).


βš™οΈ How to Run This Project

1. Clone or Download the Project

git clone https://github.com/your-username/crud-app-php.git

2. Move to XAMPP htdocs

C:/xampp/htdocs/CRUD_APP/

3. Start Apache & MySQL in XAMPP

4. Create the Database

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
);

5. Open in Browser

http://localhost/CRUD_APP/

πŸ“ CRUD Operations

βž• Create

insert_data.php adds student to DB.

πŸ“„ Read

index.php displays all student data.

✏️ Update

update_page_1.php loads selected student β†’ updates them.

❌ Delete

delete_page.php removes student from DB.


πŸ“Έ Screenshots

Read image


Create image


Update image


Delete

image

✨ Future Improvements (Optional)

  • Validation messages
  • Search bar
  • Pagination
  • Login system
  • Improved UI with custom CSS

πŸ‘¨β€πŸ’» Author

Raj Chauhan Project created with passion ❀️ Portfolio: https://itsdevrajchauhan.netlify.app


πŸ“ License

This project is fully open-source. Feel free to use or modify it for your learning.


About

PHP and Mysql Crud Application

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages