?
Solved

Order placing mechanism and Multi-table entry

Posted on 2011-03-21
4
Medium Priority
?
484 Views
Last Modified: 2012-05-11
I am doing this project, which is basically few modules from an ERP using PHP/MySQL (codeigniter framework).

I'm not sure how should I integrate the Order Placing mechanism (and other multi table dependent) features.
Eg. Customer's Order is managed by two MySQL tables, (Order and Order-Detail).
Order tables stores general order information, while Order-Detail stores ordered product information (quantity etc.), since an order can have more than one product ordered.

So, my questions are:
- How is this thing basically implemented (the logic behind it)?
- How it is called in the industry jargon (so I can google for ready JavaScript/AJAX or PHP libraries or snipets)?
0
Comment
Question by:psybaron
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 10

Accepted Solution

by:
Mathiyazhagan earned 2000 total points
ID: 35186729
Hi,

I think you need for a help on "shopping cart" which includes Categories, Product List, Products, Payment gateway & Order management system.

Basically a product page contains "Add to cart" button which adds the product in shopping cart. In the cart page you can get billing address, shipping address & payment. If payment made successful the order will be placed in the order table.

You can have product listing pages under different categories.

Check some shopping cart application for more information on this.
0
 

Assisted Solution

by:psybaron
psybaron earned 0 total points
ID: 35194682
Yes, I might integrate shopping cart for the customer's interface. But still, since this is an ERP, I will need to use forms that upon submit will submit data to more than one table.

I want to ability my form to have for example (+) button, when upon clicking new form elements will appear (new line) and one can new product. And again, new one if clicked. When submitted, this will result in one entry in the main table (general info) and eg. 3 entires in the details table.

I hope I'm transmitting my idea clearly. Please ask for clarification.
0
 

Author Comment

by:psybaron
ID: 35308712
I decided to use my own way of Master/Detail entries, from within the same form. Thank for the help.
0
 

Author Closing Comment

by:psybaron
ID: 35349173
Asking this question, I realized roughly the solution. The Expert gave me a good idea in implementing the front end of the application. Thank  you!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article discusses how to implement server side field validation and display customized error messages to the client.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question