Link to home
Start Free TrialLog in
Avatar of psybaron
psybaronFlag for Greece

asked on

Order placing mechanism and Multi-table entry

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)?
ASKER CERTIFIED SOLUTION
Avatar of Mathiyazhagan
Mathiyazhagan
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of psybaron

ASKER

I decided to use my own way of Master/Detail entries, from within the same form. Thank for the help.
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!