Hello, I am trying to make a fitment guide which allows you to pick your make/model/year of your car and in turn it spits out your speaker sizes. many website have this functionality built in and I really have no idea where to start. I have all my data in a spreadsheet and would love some guidance.
example on http://metraonline.com/ the vehicle fit guide.
The first thing is to load the spreadsheet into a database. I don’t know how the other companies like crutchfield do it, but I would use the manufactures site of the products you sell to show what fits.
You will need javascript and php for a variety of portions. My worry would be when new vehicles come out. Would you manually update the database for the new vehicles?
Is the site you posted yours, or an example?
That site is an example.
Here is my table: http://oi62.tinypic.com/2s6kjmq.jpg
Database name is dbmenu
table name is table 3
any help would be very much appreciated!
I would put the table in xml format and just read the data from that, I have done that in the past when I was going from Flash to MYSQL. I would convert the data coming from flash to XML, I am sure it’s pretty easy converting to spreadsheet data to XML and I wouldn’t be surprised if the spreadsheet program has an automatic script that does it for you (I think I seen it when I played around with Microsoft’s Spreadsheet program). By that I mean having the XML data converted into php, but I could be wrong. Someone who is more experienced probably can give a better answer.
Any chance you’d be able to throw me some code that would read said XML file? I’m rather new to PHP and this sounds like it maye be a tad easier.
This is what I’m attempting at the moment but i cant’ get any return results.
[code]
MAKE:
----------
MODEL:
[/code]
My XML File:
http://oi60.tinypic.com/2wrf7r6.jpg[
I’ve come a long way since you pushed me towards the XML and Ajax format, I have now made my drop downs list dynamically, but I am having a hard time printing the results to the screen, here is my current code:
[code]
---Select Make---| Front Location 1 | Front Size 1 |
and an excerpt of XML:
<?xml version="1.0"?>
<ROWSET>
<ROW>
<MAKE>ACURA</MAKE>
<Model>CL</Model>
<YEAR>2001-
2003</YEAR>
<Front_Location_1>Door</Front_Location_1>
<Front_Size_1>6 1/2</Front_Size_1>
<Front_Location_2>Sail Panel</Front_Location_2>
<Front_Size_2>1 </Front_Size_2>
<Rear_Location_1>Deck</Rear_Location_1>
<Rear_Size_1>6 x 9</Rear_Size_1>
<Rear_Location_2></Rear_Location_2>
<Rear_Size_2></Rear_Size_2>
<Other_Speakers></Other_Speakers>
</ROW>
<ROW>
<MAKE>ACURA</MAKE>
<Model>CL</Model>
<YEAR>1999-
1999</YEAR>
<Front_Location_1>Door</Front_Location_1>
<Front_Size_1>6 1/2</Front_Size_1>
<Front_Location_2>Sail Panel</Front_Location_2>
<Front_Size_2>1 </Front_Size_2>
<Rear_Location_1>Deck</Rear_Location_1>
<Rear_Size_1>6 x 9</Rear_Size_1>
<Rear_Location_2></Rear_Location_2>
<Rear_Size_2></Rear_Size_2>
<Other_Speakers></Other_Speakers>
</ROW>
here is my test page:
http://creativenights.creativecaraudio.net/test/dropdown/xmltest3.html
Does anyone have any tips for me? I’m really stuck at this point.