Solved

Order placing mechanism and Multi-table entry

Posted on 2011-03-21
4
483 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 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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Learn about the eCommerce marketing trends for the year ahead.
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…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

696 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