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
13 freelancere byder i gennemsnit $201 for dette job
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 marinsauto.ca, gabies.ca and more. Their adminback-end has similar functionality. Thanks. Regards, Olms