Multiple item entry with edit and delete option

[rohanraj]

Help me with code for sales order in which one can add multiple item and can store it in database. Example.
-------------------------------------------------------------------------------------------
item name | item rate | item quantity| total amount|
LEd              2100           2                        4200    |Edit|Delete      (line 1)
Mouse          100             4                        400      |Edit|Delete      (line 2)
Item list     | auto fill   |  manual        | Auto fill       | Add             (line 3) 

                                    Grand Total  | 4400        |

                                                     

                                                                                **Submit**

Item list is taken from databse. item rate should be come auto as specified in database and total amount should come automatically. after pressing add button next line come automatically as line 3 and the added line must look like line 1 and line 2 with edit and delete option. after submitting the form all entry inserted into database.

Help will be highly appreciated.

the work I have done is .....

------------------------------------------------------------------------------------------------------

fee.php
----------------------------------------------------------------------------------------------------------------

checkfee.php

 

is attached.....

 

checkfee.php

Fee.php

[fastsol]

I think I understand what you want.  So you have a table displayed on the page with data and you want to hit a button "add" and have it make another table cell below that yo ucan continue to enter more in, then submit it all at once?  Is that about right? Check an example of this http://demo.amecms.com/a.php?menu=Products&admin_page=purchaseorder&action=add and click the "add more rows" at the bottom. 

The demo login info is (case sensitive)

username: admindemo

password: Admindemo1

 

If that example is what you are looking for, it's not the somplest thing to do and involves javascript and ajax.

[rohanraj]

Yes it is ill bit helpful.... Can u post the code here.... Or can u mail it to me on junkypantera@gmail.com.....