Add fields to form

[MitchEvans]

Hi Guys,

I have a simple form asking for name and location - "Submit" is then clicked and it updates the sql database - simples.

What I would like to do now is have a button next to the name and location reading "add another" where another name and location field are added underneath the other that has already been filled in. And again if "add another" is pressed a third name and location field would be shown and so on. Once submitted I would like the contents of these fields to go into the 2 fields within the database named name and location.

So the db would look like this:

Name | Location
Mitch | UK
John | USA
Bob | Spain

My simple form is shown here:

<form action="test.php" method="post">
Name: <input type="text" name="name"><br>
Location: <input type="text" name="location"><br>
<input type="submit">
</form>

Hope this makes sense and someone can help!?

[bradgrafelman]

I think the main pieces of the puzzle would be:

• Use Javascript (jQuery would probably be my weapon of choice) to "clone" or duplicate elements of the form as needed.

• Use square brackets in the "name" attributes, e.g. name[0], name[1], etc.

• In the PHP script, $POST['name'] and $POST['location'] will then be arrays. Use something like a [man]for/man loop to process the two arrays together, handling the name/location pairs as necessary (i.e. building up a SQL query string that then INSERTs all of the tuples into your D😎.

[MitchEvans]

Mate that's worked perfect thanks so much, got a great form working now!!

The only thing is how do I get it to insert in the db, i'm using the below and it's not working!?

$array=$_POST['nametain'];
$array1=$_POST['qualification'];
$array2=$_POST['datetain'];
foreach($array as $nametrain)
foreach($array1 as $qualification)
foreach($array2 as $datetrain)
{
	{
		{
if(strlen($nametrain)>0)
{

$res=mysql_query("INSERT INTO gap_q4(customerid,date,nametrain,qualification,datetrain)values
('$customerid','$date','$nametrain','$qualification','$datetrain')");

}
}
}
}

[bradgrafelman]

The stacked foreach() loops are the problem (since they don't make sense). As I suggested, use a single for() loop to iterate through the numerical indexes.

[MitchEvans]

Hi, thanks very much for this, do you have an example of how I would do this?

I'm not sure my coding explains what I am looking to do, 3 arrays are posted from the form and I would like to insert these into my sql db. The count will be the same for them.

Thanks.

[MitchEvans]

Thanks for all the help here guys, I have now sorted it with the below!

Thanks for all the help it really appreciated!

$arrlength=count($make);

for($x=0;$x<$arrlength;$x++)
  {
  $res= mysql_query ("INSERT INTO gap_q5 (customerid,date,make,model,description,value,serial,pat) 
VALUES ('$customerid','$date','$make[$x]','$model[$x]','$description[$x]','$value[$x]','$serial[$x]','$pat')");

  }

[bradgrafelman]

Last few pieces of advice I'll offer:

• Stop Using the MySQL Extension!

• You should never place user-supplied data directly into a SQL query string, else your code will be vulnerable to SQL injection attacks and/or just plain SQL errors. Instead, you must first sanitize the data or use prepared statements. See [man]security.database.sql-injection[/man] for more info.

• Don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu above.