Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Order placing mechanism and Multi-table entry

Posted on 2011-03-21
4
Medium Priority
?
486 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 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
Ecommerce has truly become one of the most prosperous ways of monetizing your brand on the Internet. However, when it comes to it, auditing is undoubtedly the lifeblood of this type of business.  This article will help you to conduct your ecommerce …
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
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.
Suggested Courses

578 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