workflow summary:
the database gets populated, from server to server, every night, with an xml file.
The customer access the database through a search box.
The customer see the results and click on a car to see its details.
The customer manually calls the shop to get more info.
## Deliverables
project name:
cars database viewer and search engine
required skills:
PHP, MySQL, JavaScript, CSS, HTML
workflow summary:
the database gets populated, from server to server, every night, with an xml file.
The customer access the database through a search box.
The customer see the results and click on a car to see its details.
The customer manually calls the shop to get more info.
description:
those are the details of a car:
* vendor (example: 'Renault')
* model version (example: 'Grand Espace 2.2 TD Dolce Vita [1998/01]')
* date withdraw (example: '2007-08-09 00:00:00')
* number of doors (example: '3' doors)
* type (example: 'people carrier')
* color (example: 'grey')
* cubic capacity (example: '2188')
* feeding (example: 'diesel')
* horsepower (example: '21')
* matriculation date (example: '1999-02-01 00:00:00')
* accessory (example: 'airbag')
* numberplate (example: 'BA76XXX')
* number of owners (example: '1')
* kilometers (example: '145000')
* last revision time (example: '2005-02-01 00:00:00')
* VAT (example: 'duty-free')
* box (div) with search, with the following fields:
- vendor
- model
- type (example: 'people carrier')
- kilometers range (example: 'from 100.000 to 150.000 kilometers')
- matriculation date range (example: 'from 1999 to 2001')
Those fields must be drop-dows menu.
Their values must be populated when the XML files gets imported and the database updated.
* page with the result of the search:
a list of the cars which match the above search.
Each result is a row with the following info of the car:
- vendor
- model
- kilometers (example: '145.000 kilometers')
- matriculation date (example: year '2000')
(by clicking on a car the customer views the following dynamic page)
* pages (1 dynamic page) of the cars, with all the details.
* the specification are not complete: images are missing.
During the development of this project, a new XML file will be provided which will include
the images of the cars.
Those images will be shown in the search results page
and in the page with the details of the car.