Solved

Order placing mechanism and Multi-table entry

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
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 tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

757 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now