PHP Car Search - By UK Postcode

Dette projekt blev tildelt til leoe for $150 USD.

Få gratis pristilbud for et projekt som dette
$100 - $300 USD
Bud i alt

I would like the following developed in PHP...

This is not a full website by any means, nor does it need a header, just some nice clean CSS pages

A car search page (attached image) to search a MySQL database (field format attached)

A car results page

A car "more details" page

An enquire about this car page

for an idea of what i want see [url removed, login to view]

the page will need to search the database for the relevant records by the search that was done (limited by postcode area and distance selected : note the postcode is stored in the company file and not the cars file)

It will then need to show the results (x per page x would be set in a global variable php file) and include sorting by fields also page numbers & prev/next page links.

There will be a carsID which will be an autoinc field.

The field linking the companies and cars together will be fields in each table called DealerID, there will then be a link to a second page once on the results page which will give more information on the vehicle such as the make, model, 4 pictures etc (again see autotrader, they use an onclick event to view each picture) i will also need to list the dealer who owns the car along with their email address, from here they should be able to enquire about the car direct to the dealer from an online form.

The field layout for the tables i will keep simple, i can do the rest of the fields once the initial design is complete.

Cars Table

CarsID - Autoinc

DealerNum - Integer

StockNumber - Integer

Make - Varchar - 40

Model - Varchar - 50

Specification - Varchar - 100

Notes - Memo (blob?)

Mileage - Integer

Price - Float

RegYear - Integer

ImageThumb Varchar - 150 (all images store paths to actual image)

Image1 Varchar - 150

Image2 Varchar - 150

Image3 Varchar - 150

Image4 Varchar - 150

Companies Table.

DealerID - AutoInc

DealerNum - Integer

DealernName - Varchar - 100

DealerEmail - Varchar - 100

The 2 table are linked via DealerNum fields

I do not need any fancy design, just a nice clean layout with CSS so i can edit it.

IN YOUR REPLIES PLEASE ACKNOWLEDGE THAT "I HAVE READ YOUR POST IN FULL" as many people copy and paste the same thing which just wastes everyones time!!

I have a figure of around $100-$150 in mind for this project, please only post if you can meet my needs within my budget!

If you have any questions please get in touch

Many thanks

Tildelt til:
Færdigheder påkrævet

Ønsker du at tjene nogle penge?

  • Fastsæt dit budget og din tidsramme
  • Beskriv dit forslag
  • Bliv betalt for dit arbejde

Ansæt Freelancere, der også bød på dette projekt

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online