Insert PHP Grid Data into Mysql Table

[maideen]

Hi

I am new in PHP. basically I am asp.net programmer, Now I am entering Open source, coz license issue and other hosting issue is in Microsoft.

I have one issue. I do not know how to solve and also no idea. It is my scenario.

I have Product table with details,selling price, purchase price and so on. I want to invoice to clients.
Clients can buy lots of item in single invoice. If I select product, it will display the Name of item,Sell price
Uom in text box. If I click the add button, it will show in grid in php page. I have to do this one by one until client’s ordered items completed. Then I click submit, then the items in Grid should be saved into Mysql Data table.

It look like cart, but not

If there is any idea and how to do this, pls share your knowledge with me.

Thank you

Maideen

[Valkrider]

Why not write it to the database as you go, add to grid and then add to database then add next one. Alternatively store the selected items in an array as well as your grid and then write the array to the database at the end.