En cours

Search for time - PHP/MYSQL

Our goal is to create a page that lists the stores' opening hours. The times will be manually entered. We have already created the design in HTML / CSS.

Requirements

Database Requirements

- Flexible and optimized

Database Structure

* Business Name

* Opening hours (Monday - Sunday)

* Address (Street, Postal Code and City)

* Category (We already have all categories)

* Phone

* Fax

* Website

* Deviation

Notes

- Every company is unique, even if it occurs in several cities

Website Requirements

Search function

- Find times by searching for store and location.

(The user presses the search button to display the result)

(You can not search only at a city but it is possible to search only for a companies)

- Shops listed should be presented as open or close based on local time.

(Open the stores listed before closed)

Visitors

- Be able to report discrepancies

- Tell about times

- Searches are logged to the admin

Corporate Users

- Able to add stores / Hours

- Be able to delete own stores and its opening hours

- Able to edit own opening hours

Admin

- Able to add stores / Hours

- Be able to take away stores and opening hours

- Be able to edit the opening hours

- Approve times (companies) for publication

- Able to see statisktik from searches (such as number of searches)

Compétences : HTML, MySQL, PHP

Voir plus : search time php, structure stores, search for a website by name, php code to create report, find a postal code, find and search in php code, code search, php mysql search time, time add, php create function, delete searches, unique name for website company, unique business name, tell the time, take away, php mysql html css, mysql report, local search, css mysql, companies search, mysql code search, database design php mysql report, report mysql php database, structure php, name search number

Concernant l'employeur :
( 6 commentaires ) Linkoping, Sweden

N° du projet : #1013822