/CrudUsingPdoInPhp

CRUD with file upload using PDO in PHP

Primary LanguagePHP

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)