array sql insert problem

[michaelowen]

hello everyone.

I had this thread going before, and I really started to change the focus, and had a much more specific question.

I am creating a signup form where a validation occurs, and during this validation, a user signifies how many entries they would like to add (to a mysql database).

My problem deals with posting the array to the database correctly.....i can not get the syntax correct.

here is my form:

---

if ($submit) {

// process form

$db = mysql_connect("..", ".....", "........");

mysql_select_db(".....",$db);

$sql = "INSERT INTO runner (first,last,age) VALUES ('$first','$last','$age')";

$result = mysql_query($sql);
echo "Thank you for registering your team members. \n"
;

} else{

?>

<table border="2" width="100%"><tr><td>
<form method="post" action="<?php echo $PHP_SELF?>" onSubmit="return Validator(this);">
<table width="100%" border="0">

<?
$row = 5;
for ($i = 0; $i < $row; $i++) {
echo"
<tr><td>
First Name: <input type=\"Text\" name=\"first[$i]\" size=\"10\">
Last Name: <input type=\"Text\" name=\"last[$i]\" size=\"10\">
Age: <input type=\"Text\" name=\"age[$i]\" size=\"5\">
</td></tr>";
}
?>

<input type="Submit" name="submit" value="enter information">
</form>
</table>

<?php

} // end if

?>

---

How do i pass these $rows as individual rows with ONE submit button?

Would it be something to this effect:

foreach($first as $value)
{
???????
}

How would i loop a foreach to include this row array?

Thanks in advance,

-Michael

[bretticus]

Well, I'm not sure this is how I woudl do this ('cause I hate parallel arrays mostly) but to follow the direction you're going ...

<?
if ($submit) { 

// process form 

$db = mysql_connect("..", ".....", "........"); 

mysql_select_db(".....",$db); 
for ($i = 0; $i < count($_POST['first']); $i++)
{
	$sql = "INSERT INTO runner (first,last,age) ";
$sql .= "VALUES ('".$_POST['first'][$i]."','".$_POST['last'][$i]."','".$_POST['age'][$i]."')";
}

$result = mysql_query($sql); 
echo "Thank you for registering your team members. \n"; 

} else{ 

?> 

<table border="2" width="100%"><tr><td> 
<form method="post" action="<?php echo $PHP_SELF?>" onSubmit="return Validator(this);"> 
<table width="100%" border="0"> 

<? 
$row = 5; 
for ($i = 0; $i < $row; $i++) { 
echo" 
<tr><td> 
First Name: <input type=\"Text\" name=\"first[]\" size=\"10\"> 
Last Name: <input type=\"Text\" name=\"last[]\" size=\"10\"> 
Age: <input type=\"Text\" name=\"age[]\" size=\"5\">
</td></tr>"; 
} 
?> 

[michaelowen]

thank you, this looks great!

For some reason it is only sending one entry (the last one) to the db, do you think there is something missing around the "count" statement?

-Michael

[laserlight]

Probably something along the lines of:

$query_error = false;
$count = count($_POST['first']);
for ($i = 0; $i < $count; $i++)
{
    $sql = "INSERT INTO runner (first,last,age) VALUES ('"
    	. $_POST['first'][$i] . "','"
    	. $_POST['last'][$i] . "','"
    	. $_POST['age'][$i] . "')";
	if (!mysql_query($sql)) {
		echo "Error: we were unable to complete your registration.\n";
		$query_error = true;
		break;
	}
}
if (!$query_error) {
	echo "Thank you for registering your team members.\n";
}

Note that instead of $PHP_SELF it is (usually) better to use $_SERVER['PHP_SELF']

[bretticus]

Yep, I left that mysql_query out of the for loop (it was late)