[nicpon]

I would like to create php and mysql based website that have 5 different kinds of products and about 10 types of each kind. I want it be something like online catalog but dunno how to start. I have some experience in php and mysql but havent create anything from the scratch bymyself.Are you guys willing to help me a bit or have any ideas ??How should i start creating website in PHP ??

[rockitdev]

if you want your solution to be dynamic, then get your mysql database planned out first. any product catalogue should be stored in a db. that will be the backbone of your site. there are plenty of good tutorial sites out there to help you with developing your database. many of which you can find from the links at the top of this page. hot scripts is a really good site. then, build your pages to output the data from your database. those pages will be a combination of some sql to retrieve the data from the db, then php to output the data. if your solution requires a shopping cart, then find a good tutorial that deals with storing your information in a shopping cart. you will want to use a session approach for your cart as they are the best to use.

any e-comm site planning goes db -> pages to show your product -> shopping cart to make money. hope this helps.

~Rockitdev

[nicpon]

thanks rockitdev,

Now i know at least how to start, I dont need the shopping cart right now, maybe later but for now i would like to have only thumbnails of every single product with short discription. So i guess i will need 5 tables with 10 selections each.

[Wuiqed]

Not really, one table will be sufficient. Let's say your five products are product A, B, C, D and E and each variation of the products is labeled from 1 to 10. When you create your table, use one extra column and call it product. It could be like this...

Code:

 product  | type     | price
-----------------------------
 A        | 1        |  9.95
-----------------------------
 A        | 2        | 19.95 
-----------------------------
 B        | 1        |  9.95 
-----------------------------
 A        | 3        | 29.95 
-----------------------------
 E        | 1        |  9.95 
-----------------------------
 E        | 2        | 19.95

This would make 1 table enough.