This project is a simple PHP-based CRUD form that allows users to submit their information (name, fatherโs name, email, number, and CNIC).
All data is stored in a MySQL database.
- Add user details using a Bootstrap form
- Insert data into MySQL database
- Shows โsuccessfulโ message after insertion
- Uses
mysqlifor database connection - Correct handling of phone number & CNIC by using VARCHAR datatype
- PHP
- MySQL
- Bootstrap 5
- HTML
project-folder/ โโโ connect.php โโโ index.php โโโ README.md โโโ (other files)
- Open phpMyAdmin
- Create a database (example:
crud_db) - Create table using this SQL:
CREATE TABLE crudee (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
fname VARCHAR(100),
email VARCHAR(100),
number VARCHAR(20),
cnic VARCHAR(25)
);