Results 1 to 5 of 5

Thread: E-commerce Site

  1. #1
    Join Date
    May 2004
    Location
    South Wales | UK
    Posts
    43

    Unanswered: 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.

  2. #2
    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

  3. #3
    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.

  4. #4
    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.

  5. #5
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •