If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > E-commerce Site

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-14-04, 18:02
InfoSystems InfoSystems is offline
Registered User
 
Join Date: May 2004
Location: South Wales | UK
Posts: 43
E-commerce Site

Hi Forum,

I am creating an e-commerce site that will sell clothes over th internet. I would like to implement this project with the use of MySQL and PHP due to no IIS etc.

I was wondering if anyone has any pointers in general and in regards to database layout.

Database Design

tbl_customers
tbl_products
tbl_categories
tbl_subcategories

Not sure if i need to have any more?? how is a shopping cart achieved??
Really could do with some help.
Reply With Quote
  #2 (permalink)  
Old 12-14-04, 21:10
savbill savbill is offline
Registered User
 
Join Date: Feb 2004
Posts: 533
How really bad do you want to DIY this? There are some really excellent open source and commercial ecommerce packages that well most likely have what you need and then some. Then you can spend more time on design and configuration insted of learning and coding. Check out OS Commerce I haven't used it in a live site myself but have looked it over. It has features and wide user base.


/
__________________
~

Bill
Reply With Quote
  #3 (permalink)  
Old 12-15-04, 06:45
InfoSystems InfoSystems is offline
Registered User
 
Join Date: May 2004
Location: South Wales | UK
Posts: 43
thanks

Hi Savbill,

Thanks for your reply, I am a final year student and my project is this and so will not be allowed to use third party software. I have to create the database etc myself.
Reply With Quote
  #4 (permalink)  
Old 12-15-04, 16:25
InfoSystems InfoSystems is offline
Registered User
 
Join Date: May 2004
Location: South Wales | UK
Posts: 43
Problem

I am not sure what tables to create to implement the site design etc not done anything like this and could do with some pointers.
Reply With Quote
  #5 (permalink)  
Old 12-17-04, 03:45
codenode codenode is offline
Registered User
 
Join Date: Dec 2004
Posts: 26
osCommerce comes with a PDF that shows its database design. That would be a good starting point to answer your question regarding what tables you might need.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On