Posted by J.O. Aho on 12/06/05 00:14

Dan Williams wrote:
> Hi,
> Can anyone advise what "should" be used to creat a pc quote builder similar
> to what is used here.
> http://www.sneakerscomputers.com/systems/

I would pick to have a database where I can store the "computers" and parts
that can be picked.

You can have a table for each category, like memory, hard drive, graphics card
and so on. Then you have a table for the computer models. Then you create
relation tables, computer-part relations, this will be as many as there are
parts that you can pick from. Last you need a default parts table, where you
have the connection for computer and what parts by default.

After that you make a page where you select the compute model, which then
loads a page which dynamically generates the table depending on which
relations are between a computer model and parts, so that only those things
that can be used in a computer is shown. The whole page is a big form of
course, which then stores the data in some way, either into a database or/and
send you a mail.

It's really not that much work if you know basic php and sql.


//Aho

[Back to original message]