PHP Car Search - By UK Postcode

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

The postcode SQL dump file is available at http://www.pc-i.co.uk/dwn/postcodes.sql

The code is then needed to show the results depending on distance selected, please do not bid if this is something you are not sure on how to do

attahced is information in php on how to code the postcode location by distance, based on the sql dump :)

Beceriler: PHP

Daha fazlasını gör: postcode autotrader, autotrader postcode, autotrader postcodes, postcode autotrades, post code autotradercouk, autotrader poscod, postcode cars, car stores postcodes, php postcode checker, you by your numbers, www linked, www developed by, who was the website developed by, what php can do, what is linked in, website developed in php, view cars online, uk email address database, thanks you notes, see cars online, search per, search here, search for an image online, rest specification, project list in php

İşveren Hakkında:
( 3 değerlendirme ) n/a, United Kingdom

Proje NO: #117703



Hello, I have read your post in full and I have some details to discuss. Please see the PMB. Thanks.

%selectedBids___i_period_sub_7% gün içinde 150%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(106 Değerlendirme)

13 freelancers are bidding on average $201 for this job


Have done similar database based project several times and can do it easily.. Thanks, Vishal

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(450 Değerlendirme)

Hi, I HAVE READ YOUR POST IN FULL. Please see PMB for more details. Best Regards ... ccpplinux

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(116 Değerlendirme)

Please check it out the PM for more info, thanks…

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(96 Değerlendirme)

I HAVE READ YOUR POST IN FULL. I'm ready to start. Thanks

in %bids___i_period_sub_35% gün içinde145%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(105 Değerlendirme)

Please check PMB.

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(24 Değerlendirme)

I HAVE READ YOUR POST IN FULL! The project you are interested in is easy to do and will be ready fast and up to very high standards. Please check PMB for some details on it!

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)

I have similar site.. [url removed, login to view] [url removed, login to view] user: admin pasw: admin The cars for sell can be added from admin or from registered users.. The admin is hierarchical, the superadmin can add for Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(39 Değerlendirme)

Hello, I already have experience in such kind of projects. I worked on sites like [url removed, login to view], [url removed, login to view] and more. Their adminback-end has similar functionality. Thanks. Regards, Olms

in %bids___i_period_sub_35% gün içinde130%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

I have read your post in full. This job is just a piece of cake! If you don't choose my bid I'll make this script for my own pleasure:)

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, Kindly check this website. [url removed, login to view] this website is developed by our team. Your requirements is very less than this site. Reply

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

hi i have understood ur requirements regarding the project. and i am intrested in accomplishing this [url removed, login to view] are professionalised team of 9 developers in PHP and MySQL and we have good designers as well .and we can Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I can do this job in 2 days.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)