MySQL Database for specifications (PHP also)

I need a database designing from new for storing car information i have gathered. It needs to be designed from new and have the following.

* Page for new specifications to be added (specs are stored now in .txt files) so this page needs to be able to input the specs from the .txt file into the databse.

* Page to edit and control the specs

* Page to display the specs to a html file. The page needs to contain. The Makes and models of cars listed in the database. A search facility to let viewers search for there car. Top 10 cars views and Top 10 new cars added.

Here is an example of the information to be stored to the db.

Fiat Stilo 1.2
(2002-2003)

FUEL TYPE: petrol (gasoline)
ENGINE CAPACITY: 1242cc
CYLINDERS: In-line 4
VALVES: 16
POWER: 80bhp
TORQUE: 84 lb-ft
DRIVEN WHEELS: front (FWD)
STANDARD TRANSMISSION: 6-speed manual
OPTIONAL TRANSMISSION: none
BODY STYLES: 3/5-door hatchback
SEATING CAPACITY: 5

MAXIMUM SPEED: 106mph
0-60: 13.4 seconds
AVERAGE FUEL ECONOMY: 43mpg

LENGTH: 4253mm [167.4 in]
WIDTH: 1756mm [69.1 in]
HEIGHT: 1525mm [60.0 in]
WHEELBASE: 2600mm [102.4 in]
KERB WEIGHT: 1090kg [2401lbs]

CO2 EMISSIONS: 155 g/km
UK INSURANCE GROUP: 4
EURO NCAP CRASH TEST RATING: 4 stars
US NCAP (NHTSA) CRASH TEST RATING: not applicable

This is how the specs are saved in the .txt files.

here is some exaples of other sites with these kind databases.
http://www.mymotorguide.com/
http://www.automotive.com/new-cars/specifications/index.html

Any questions please contact me

Thank you

Comments

  • Hi,

    I can build a frontend + backend in symfony. Let me know if you are interested.

    Regards
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion