CRUD with file upload using PDO in PHP

Repository Details:

• Read, Insert, Update, Delete Record
• Upload Image
• Store the image path in database

User Manual:

• Need to download or clone the project
• Create a Database named crud_pdo_in_php
• Create a Table named employees
• Table Queries are given below
• Need to put the mySQL user name and password in config/database.php file
• And you are done!
• Just go to your browser and write localhost!
• And Yes, most importantly -- You have to installed Apache, PHP and MySQL on your computer :)

Upload Image:

• Need to create a folder name uploads in the clonned directory to get the upload file work.
• Folder heirarchy are given below.

`employees` table queries:

• CREATE TABLE employees (
• id INT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
• name VARCHAR(50) NOT NULL,
• email VARCHAR(50) NOT NULL,
• website VARCHAR(50) NOT NULL,
• comment VARCHAR(50),
• image_path VARCHAR(255),
• created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
• updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
• );

Folder hierarchy:

--config

• database.php

--css

• style.css

--inc

• footer.php
• header.php
• image_upload.php
• record_submit.php
• record_update.php

--uploads (Store the uploaded image)

--create.php (Create Record)

--delete.php (Delete Record)

--edit.php (Edit Record)

--index.php (Read Record)