How to create listinput form with ADD and REMOVE functions?

Techissue2008

I need to create a listinput form to let user able to input multiple rows of data and submit the form.

The DB table fields are batchid, imagepath, productid, quantity, price

Input fields in form are imagepath, productid, quantity, price

The default number of input rows is 5, user can add new row or remove row of input textbox.

Once it is input, it will display the total numbers of quantity and total price for this batch.

Multiple rows of data will be input into DB table after pressing submit button.

How can I code it and is there any source code or complete tutorial of it?

Thanks

Servyces

The form part can be achieved by using JavaScript. Inserting it into the database with a calculation would be PHP function that sums up all the individual prices and inserts the grand total into the database. For example if your price fields are named price[0] through price[3], your PHP code should look something like:

foreach $_POST['price'] as $price {
    $total += $price;
}

$total will then contain the total value of all price fields.

Techissue2008

How about the list input part?