Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,471
There are 1456 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

Database design for ecommerce site

Thread title: Database design for ecommerce site
Closed Thread    
    Thread tools Search this thread Display Modes  
02-14-2007, 12:32 AM
#1
adammc is offline adammc
adammc's Avatar
Status: Junior Member
Join date: Jan 2007
Location: Cairns, Australia
Expertise:
Software:
 
Posts: 26
iTrader: 0 / 0%
 

adammc is on a distinguished road

  Old  Database design for ecommerce site

Hi Guys,

I am looking to design an ecommerce site with categorised products.
Once built, I want my client to be able to add additional categories and be abel to add their products into their chosen category.

Would I be best displaying this dynamnically after creating a table with the products category names in it or doing it static?

Also, if I wanted to show a different header / meta tags for weach category how would I best tie this in?

I have designed a few ecommerce sites in the past but have done it the hard way, creating each individual category page!

Any advice would be GREATLY appreciated

02-14-2007, 08:23 PM
#2
RaZoR^ is offline RaZoR^
RaZoR^'s Avatar
Status: Member
Join date: Feb 2006
Location:
Expertise:
Software:
 
Posts: 191
iTrader: 1 / 100%
 

RaZoR^ is on a distinguished road

  Old

DATABASE: products
-- TABLE: cats
-- -- COLUMN: id
-- -- COLUMN: cat
-- TABLE: products
-- -- COLUMN: id
-- -- COLUMN: name
-- -- COLUMN: cat

You select the row id from the cats table where cat = (what the user inputting?). You then select all from products where cat = (cat id).

That way you can add and remove categories, and you call pull them all out and put them into a select menu in HTML or something.

With regards to meta tags and such:
Code:
<meta name="description" content="High quality <?php echo $category; ?> products at low prices!" />
(obviously that's just the general drift lol).

Closed Thread    


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed