Photo Auction

Web application designed using PHP, HTML, SQL & Bootstrap

Getting Started

These instructions will help you set up the project on your local machine

Prerequisites

Install one of the local servers listed below to setup the environment for databases

WAMP | LAMP | MAMP | XAMPP 

Installing

To install the database with test data visit the sql directory for the .sql files

Access monitor:

-> mysql -u [username] -p;

Method 1:

Install entire database

• Install photo_auctions.sql:
  

   -> source photo_auctions;
  

Method 2:

Install each script separately

• Install Create_Table_Member.sql:

   -> source Create_Table_Member.sql;
  

• Install Entry_List.sql:

   -> source Entry_List.sql;
  

• Install Project_1_image_values.sql:

   -> source Project_1_image_values.sql;
  

Dump & Restore Database

For the following commands, exit the MySQL monitor:

Command used to dump the database:

mysqldump -u [username] -p [database] > db_project_backup.sql

Command used to restore the dumped database:

mysql -u [username] -p -h localhost [database] < db_project_backup.sql

Existing Accounts:

Use the account information below to surf the web app

Seller Account:

Email: visualsofupal@gmail.com
Password: vou123

Buyer Account:

Email: j@nw.got.com
Password: j123

Photo Auction GitHub Project Link