Forum Moderators: phranque

Message Too Old, No Replies

Search Fields & Database Site, Which Direction To Go?

         

Foxhole

5:55 pm on May 14, 2010 (gmt 0)

10+ Year Member



Hi all,

I am just starting to put together a web site for my brother, the basics of the site such as the layout, HTML and CSS I am fine with and ready to go.

There is one aspect of this site which I'm not sure what is the best method to approach,

Basically, he has a garage full (in excess of 3000 items) of obsolete car parts that he wants to list on his web site (database?) that he can add to and update himself, and enable visitors to the web site to search for relevant items, then email him or call him to arrange purchase (not done through the web site).

What I had in mind was:

When he wants to add items to the inventory, he is able to select the car manufacturer from a drop down menu, then he selects a model, then inputs a part number, and a description, and finally uploads a representative image.
(He is not able to program or code websites, I would make a small program available to him to do this)

Hopefully I can set this up in a certain format so all of the items he would list would share the same style, such as available character space, image size and border, etc.

The visitor would then have a similar drop down menu available to them in which as they would select their requirements from the drop down menus and also type in a part number if they have one, then when they click search, this would list the corresponding items on the page that are within his database along with a small clickable thumbnail image.

Luckily, he is in no rush what so ever, more of a big learning curve and project for me really, the question I am asking is what languages in addition to HTML and CSS will I need to study to make this work?

Is this a job for Javascript and MySQL or something like that?

Any help to point me in the right direction would be greatly appreciated so I can get on with my studying!

Anyway, I hope this has made some sense in what we are trying to achieve,
Thanks for your time all,

Best regards,

Foxhole

lammert

6:33 am on May 15, 2010 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



To make such a website with the flexibility of adding and removing items, you definitely need some sort of database behind your site. There is no need to program everything from scratch though. If you haven't done any web programming before it is much easier to use an existing framework and adapt it to your needs. There are many open source packages which do more or less what you describe. A very similar question was asked a few days ago and the responses in that thread [webmasterworld.com] might give you an idea about the next steps to take.

Foxhole

1:15 pm on May 15, 2010 (gmt 0)

10+ Year Member



Hi Iammert,

Thank you very much for the quick response, I have had a look at the thread you highlighted for me, I'm getting the general feeling that the way to go is with Drupal.

Just a couple of questions about this as I have never even looked at this before:

How steep is the learning curve in comparison with something like HTML?

Do you have any books you can recommend for a beginner like myself to start studying?

How is the basis of Drupal's integration with my website, will it just be used for the database inventory and search part of the website and be referenced within the HTML, or will it have to work alone and be responsible for the whole site?

They also mention CCK, what elements of the set up will this be taking care of, if I need to use it at all?

I appologise for the incorrect listing of my post, in hindsight maybe listing within the database section would have been more appropriate.

Thanks again for your help,

Best regards,

Foxhole