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
Solved

Order placing mechanism and Multi-table entry

Posted on 2011-03-21
4
480 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
  • 3
4 Comments
 
LVL 10

Accepted Solution

by:
Mathiyazhagan earned 500 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Learn about the eCommerce marketing trends for the year ahead.
In this blog, I will share you some basic tips for content marketing and to rank your website on Google.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

839 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