Skip to content

ZaidArman/CRUD-App-Using-PHP-MySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PHP CRUD Application with MySQL

A beautiful and responsive Create, Read, Update, Delete (CRUD) application built with PHP and MySQL. Features a modern UI with gradient backgrounds, smooth animations, and a scrollable user table.

Features

  • ✨ Create, Read, Update, and Delete users
  • 🌈 Modern UI with gradient background and glass morphism effect
  • 📱 Responsive design that works on mobile and desktop
  • 📜 Scrollable user table with fixed header
  • 💾 MySQL database integration
  • 🎨 Beautiful animations and transitions
  • 📝 Form validation
  • 💬 Flash messages for user feedback

Requirements

  • PHP 7.4 or higher
  • MySQL 5.7 or higher
  • Web server (Apache, XAMPP, or built-in PHP server)

Installation

  1. Clone the repository:
    git clone 
    cd crud_-_app
    
  2. Place the files in your web server directory:
  • Move the crud-app folder to:
  • XAMPP: C:\xampp\htdocs\ (Windows) or /opt/lampp/htdocs/ (Linux)
  • WAMP: C:\wamp64\www\ (Windows)
  1. Set up the database:

    • Create a MySQL database
    • Import the SQL schema from database/schema.sql
    • Configure the database connection:
    • Edit db.php with your database credentials: $servername = "localhost"; $username = "root"; // Default XAMPP/WAMP username $password = ""; // Default XAMPP/WAMP password (empty) $dbname = "crud_app"; // Your database name
  2. Run the application:

  1. File Structure crud_app/ ├── index.php # Main application file ├── edit.php # Edit user page ├── delete.php # Delete user script ├── db.php # Database configuration ├── style.css # Stylesheet ├── sql_schema.sql # Database schema └── static/ └── img/ # Images directory

Usage

  1. Add a new user:
  • Fill out the form with name, email, and description
  • Click "Add User" button
  1. Edit a user:
  • Click the "Edit" button next to any user
  • Make changes in the edit form
  • Click "Update" to save changes
  1. Delete a user:
  • Click the "Delete" button next to any user
  • Confirm deletion in the popup dialog

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published