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.
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
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
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 :)
13 pekerja bebas membida secara purata $201 untuk pekerjaan ini
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!
Hello, I already have experience in such kind of projects. I worked on sites like [login to view URL], [login to view URL] and more. Their adminback-end has similar functionality. Thanks. Regards, Olms