Generate Forms for MySQL Insert

[alcibar]

I have two tables:
parent
parentid
parentname

child
childid
parentid
childname
childage

This is my initial html

<form> 
parent name: <input type="text" name="parentname"><br> 
children: <input type="text" name="child1">&nbsp; Age:<input type="text" 
name="ageforchild1"> <a href="questionhere.link">Add Child Field</a> 
</form>

I have two questions here. One is what is the code in adding a childfield link link so that when I click that, another forms will be generated or the code above will become like this after I click the add child filed

<form> 
parent name: <input type="text" name="parentname"><br> 
children: <input type="text" name="child1">&nbsp; Age:<input type="text" 
name="ageforchild1"><br> 
children 2: <input type="text" name="child2">&nbsp; Age:<input type="text" 
name="ageforchild2"> <a href="questionhere.link">Add Child Field</a> 
</form>

Another question is how to insert this into database since this will insert into the parent table and multiple row for the child table.
I want to have like what is in gmail. In gmail, if you edit/add your contacts, you can observed that forms will be generated on same page if click add field.

Thank you.

[devinemke]

<?php
if (isset($_GET['children_count'])) {$children_count = $_GET['children_count'];}
else {$children_count = 1;}

if (isset($_GET['action']) && $_GET['action'] == 'add_child_field') {$children_count++;}

echo'
<form action="" method="POST">
<b>parent</b> name: <input type="text" name="parentname"><br>
';

for ($i = 1; $i <= $children_count; $i++)
{
	echo '<b>child ' . $i . '</b> name: <input type="text" name="children[' . $i . '][name]"> age:<input type="text" name="children[' . $i . '][age]"><br>';
}

echo '
<a href="' . $_SERVER['PHP_SELF'] . '?children_count=' . $children_count . '&action=add_child_field">add child field</a><br>
<input type="submit" name="submit" value="submit">
</form>
';
?>

when this form is submitted you will have a 2D array called $_POST['children'] with the names and ages in the subarrays.

[alcibar]

Sorry folks but I got another problem. It allows inserting null child - only the primary key is inserted. When I add 10 child field and fill up just 3 of them, all 10 are inserted but the seven remainings are just null. How to prevent this?

[devinemke]

foreach ($_POST['children'] as $key => $value)
{
	if ($value['name'] && $value['age'])
	{
		// do the INSERT
	}
}

[alcibar]

Sorry if I'm disturbing you about this but I was not able to make it work. Here's the code I modify:

<?php
require("config.php");	
if (isset($_GET['children_count'])) 
{
	$children_count = $_GET['children_count'];
}
else 
{
	$children_count = 1;
}
if (isset($_GET['action']) && $_GET['action'] == 'add_child_field') {$children_count++;}

echo'
<form action="index.php" method="POST">
<b>parent</b> name: <input type="text" name="parentname"><br>';

for ($i = 1; $i <= $children_count; $i++)
{
    echo '<b>child ' . $i . '</b> name: <input type="text" name="children[' . $i . '][name]"> age:<input type="text" name="children[' . $i . '][age]"><br>'; 
}
echo '<a href="' . $_SERVER['PHP_SELF'] . '?children_count=' . $children_count . '&action=add_child_field">add child field</a><br>
<input type="submit" name="submit" value="submit"></form>';
?> 
<?php
if(isset($_POST['submit']))
{
	$parent = $_POST['parentname'];
	$sql= "INSERT INTO parent (Name) VALUES($parent)";
	mysql_query($sql, $ServerConnect);
	echo $sql;

foreach ($_POST['children'] as $key => $value)
{
	if ($value['Name'] && $value['Age'])
	{
		$sql2= "INSERT INTO child (Name, Age) VALUES($value)";
		mysql_query($sql2, $ServerConnect);
	}
}
}
?>

I have another question, in if ($value['name'] && $value['age']) what is the name and age, is it the field in my database?

[devinemke]

array keys are case sensitive. see below (just echoing the queries for testing)

<?php
if (isset($_GET['children_count']))  

{ 
    $children_count = $_GET['children_count']; 
} 
else  

{ 
    $children_count = 1; 
} 
if (isset($_GET['action']) && $_GET['action'] == 'add_child_field') {$children_count++;} 

echo' 
<form action="" method="POST"> 
<b>parent</b> name: <input type="text" name="parentname"><br>
'; 

for ($i = 1; $i <= $children_count; $i++) 
{ 
    echo '<b>child ' . $i . '</b> name: <input type="text" name="children[' . $i . '][name]"> age:<input type="text" name="children[' . $i . '][age]"><br>';  

} 
echo '
<a href="' . $_SERVER['PHP_SELF'] . '?children_count=' . $children_count . '&action=add_child_field">add child field</a><br> 
<input type="submit" name="submit" value="submit"></form>
';

if(isset($_POST['submit'])) 
{ 
    $parent = $_POST['parentname']; 
    $sql= "INSERT INTO parent SET Name = '$parent'";
		echo $sql . '<br>';

	foreach ($_POST['children'] as $value)
{ 
    if ($value['name'] && $value['age']) 
    { 
        $sql= "INSERT INTO child SET Name = '" . $value['name'] . "', Age = '" . $value['age'] . "'"; 
        echo $sql . '<br>'; 
    } 
} 
}
?>