Insert/Add Row in HTML form

snowreney

Hi, I am a newbie in PHP, and I am trying to find out a way to have the user input as many rows as they desire, right now I only have a form where user can only input one row of data, I am wondering if there is a button lets say named "Add Row", after clicking it, the user can then add row into the database automatically?

It might be vague, so let me describe it in a more concrete way.

Lets say if I need user to enter a receiving report, the record includes date, sender, contents of shipment, qty

I want to be able to let the user enter multiple contents for one single shipment by clicking on an "Add content", but the other fields gets carried down.

severndigital

i'm still a bit confused.

HYPOTHETICALLY...

you have an HTML form that captures information for fields for let's say

Name
Address
Package
Ship_Date

you want to allow the user to input the information for this package.

however, if they have more than one package you want to give them the option to automatically save the content for

Name
Address
Ship_Date

to another sample of the form so they can add a new

Package

with the same information.

Correct??

if so,

i would add a check box to the form called "Add Another Shipment"

then pass the content of the check box to the script and use an if/else statment to represent the form with the content you desire.

make sense??

if you need help writing the script let me know. but it shouldn't be that hard.

chris

snowreney

Haha..I knew I would confuse people..

I think what i meant was how to add a button to dynamically add rows to the database. Lets say if the shipment came in, there was only one item, then the user will not have to "add row", but if in one shipment, there are multiple items, then user would need to enter multiple times, but if I have a button which when user clicks on it, it will automatically shows up another empty line and let user enter the data again on the same page before he hits "submit" button.

I don't know if that makes sense?

snowreney

Here, I will do a layout of the page that I want to do:

Date:
Shipping Carrier:
No. of Boxes rec'd:

Contents Qty.
Box 1:

Box 2:
.
.
.
Box N:

Submit/Reset

Where I want to be able to let user to have the choice of how many Boxes there are by clicking a button on the page "More boxes", OR I can pass the value of the No. of boxes enter above to determine how many lines it shows on the form in order for the users to enter the information. Is it better if I do two submits (two forms)? So, lets say let the user enter the date, carrier and # of boxes first..then hit submit...then on the next page, we will take the values and generate the customized form..?

Haha..I am thinking of solutions as I type along.....suggestions?

Thanks a million..

severndigital

ahh .. now i understand the problem.

Is it better if I do two submits (two forms)?

that's more than likley the best solution.

what you could do is make two forms on the same page.

one that asks the number of boxes and
one that will get build based on the number of boxes.

when submit is pressed for box qty form, it would read the $boxqty variable then run a loop to build the info form below it until the loop = $boxqty.

this way you can use the same script and only have to pass the other information once. instead of two the second page and then insert it into the database.

does that make sense??

snowreney

Yes!! The solution is coming closer to me as you explained it.. 😃

Thanks for the patience for a newbie 🙂 I am going to work on this, and I will let you know if i complete the mission!

severndigital

no problem, i hope i helped enough.

I could write the code and post it, but then you would never learn it...ya know.

that's how i learned anyway, with just enough information to do it myself.

seriously if, you need help with the code myself or anyone here would be happy to do it.

chris

snowreney

Here is what i've wrote so far, I know there are alot of syntax error and the structure is weird..haha

function updateFormFields (){

var row = 1;
if (row < $boxqty){
	row = row + 1;
{
else {
	row = 1;
}

var n = 2;
while (row > 0){


	document.createTextNode("Content:");
	document.createElement("TEXT");
	var rowName =  "line" + n;
	document.getElementById("rowName").size = 50;
	document.createTextNode("Qty:");
	document.createElement("TEXT")
	var rowQty = "qty" + n;
	document.getElementById("rowQty").size = 5;
	document.createTextNode("Serial No.:");
	document.createElement("TEXTAREA");
	var rowSN = "SN" + n;
	document.getElementById("rowSN").cols = 50;
	document.getElementById("rowSN").rows = 10;
	n = n+1;
}

}

What do you think?