Table Input Forms

[phpnk]

I am attempting to write code so that authorized users can directly add golf event results into a database. It is pretty simple how to set it up to enter one record at a time but I'd like to offer them a way of entering 10 or more at a time. Maximum records would be around 180, or as few as 20.

Similar to displaying the results I suspect it involves a do while loop, but I am unfamiliar with the code to make that work for uploading data.

Any assistance would be greatly appreciated.

[devinemke]

use a for loop. here is an example that generates 10 text fields:

for ($i = 1; $i <= 10; $i++)
{
	echo 'field #' . $i . '<input type="text" name="' . $i . '"><br>';
}

[phpnk]

Thanks, that creates the form with 10 lines of input, but what is the insert code like to get all of that data into the MySQL database. As is it only takes the last row of input. I'd like for it to upload all rows in order.

Thanks.

Here's the code I have:

<?php
if (!erefno || !$pl || !$div || !$first || !$last || !$rd1)
{ ?>
You have not entered all the required details.<br>
Please go back and try again.
<?php exit;
}
$erefno = addslashes($erefno);
$pl = addslashes($pl);
$div = addslashes($div);
$first = addslashes($first);
$last = addslashes($last);
$pdgan = addslashes($pdgan);
$rd1 = addslashes($rd1);
$rd2 = addslashes($rd2);
$rd3 = addslashes($rd3);
$rd4 = addslashes($rd4);
$fnl9 = addslashes($fnl9);
$prize = addslashes($prize);
$madcn = addslashes($madcn);
@ $db = mysql_pconnect("**.com", "pw", "***db");
if (!$db) { echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("thedb");
$query = "insert into resultdb values
('".$erefno ."', '".$pl."', '".$div."', '".$first."', '".$last."', '".$pdgan."', '".$rd1."', '".$rd2."', '".$rd3."', '".$rd4."', '".$fnl9."', '".$prize."', '".$madcn."')";
$result = mysql_query($query);
if ($result) {
echo mysql_affected_rows(). "Record has been added. This record has been inserted into database.
<br><br>If you do not see this record posted in the results section please email the MADC Web Master.";
}
else
{
echo"Record not entered.";
}
?>

Do I loop this the same way?

[devinemke]

a simple example with 3 sets:

<?php
if (!isset($_POST['submit']))
{
	echo '<form action="" method="POST">';

for ($i = 1; $i <= 3; $i++)
{ 
    echo '
	  set #' . $i . '<br>
	  name: <input type="text" name="fields[' . $i . '][name]"><br>
	  email: <input type="text" name="fields[' . $i . '][email]"><br>
	  <br>
	  ';		   
}

echo '
<input type="submit" name="submit" value="submit">
</form>
';
}
else
{
	foreach ($_POST['fields'] as $value)
	{
		$sql = "INSERT INTO table SET name = '" . $value['name'] . ", email = '" . $value['email'] . "'";
		echo $sql . '<br>';
	}
}
?>

[phpnk]

I'm getting the following warning when I submit the data:

"Warning: Invalid argument supplied for foreach() in /mnt/nfs/fun4nick/resultsform2.php on line 160."

Line 160:
"foreach ($_POST['fields'] as $value)"

I'm guessing it doesn't recognize the 'field' variable or it is null.

running within PHP Version 4.4.2RC2-dev

here is some of the code:

<?php if (!isset($_POST['submit'])) 
<?php for ($i = 1; $i <= 10; $i++)
					{ ?>
						<tr>
							<td>
								<?php echo "<span style='color:white;'>$i</span>"; ?>
							</td>
							<td>
								<?php echo "<input type='text' name='fields[' . $i . '][erefno]'"; ?> size='3'>
							</td>
							<td>
								<?php echo "<input type='text' name='fields[' . $i . '][pl]' size='3'>"; ?>
							</td>
} ?>
					</tbody>

				<tfoot>
					<tr><td colspan="13	"><input type='submit' name='submit' value='Add Another'></td></tr>	
				</tfoot>
			</table>
			</div>
			</form>
		<?php 
		} 
		else	
		{
			foreach ($_POST['$fields'] as $value)
			{

				if (erefno || pl || div )
				{ ?>
					You have not entered all the required details.<br>
					Please go back and try again.
					<?php exit; 
				} 
				@ $db = mysql_pconnect("server", "un", "pw");
					if (!$db) { echo "Error: Could not connect to database.  Please try again later.";
						exit;
					}
					mysql_select_db("dbname");
					$query = "insert into tabledb set erefno = '" . $value['erefno']	. ", pl = '" . $value['pl'] . ", div = '" . $value['div'] . "'";
					$result = mysql_query($query);
					if ($result) {
						echo mysql_affected_rows(). "Record has been added. This record has been inserted into database.
						<br><br>If you do not see this record posted in the results section please email the MADC Web Master.";
						}
					else
						{
						echo"Record not entered.";
						}
		}}}?>

[phpnk]

Incase I have not been clear here is a summary.

I have a form that gathers data 13 fields across by 10 records down. (these are sporting results for golf events)

I'd like for all of these records to be submitted at the same time and entered in different records in the database.

I'm assuming from the above example that you have created a counter that identifies each record and loops it to insert each.

Is this right and does anyone have a live example and access to the entire code?

[phpnk]

I'm still really hoping to get more help on this.

Something is wrong with the foreach statement suggested.

Thanks.

[khendar]

I'm guessing it doesn't recognize the 'field' variable or it is null.

Here's a hint: Dont guess. Find out. Echo (or in this case print_r ) the variable which you believe is causing the trouble and see what is actually contained in it. It might give you a better idea of whats going wrong.

[phpnk]

There is no output when I do that.

[khendar]

Then that probably means that the variable is not being passed in correctly. I think the problem is the code for the text fields

You'll need to sort out the single quotes in the echo <input...> statements.

Also are erefno and pl constants or string ? If they are strings then they need to be enclosed in their own quotes.

[phpnk]

I'm back to try again. Only I'd like to do this a little differently. I have seen a form by which a user can copy the contents of an MS Excel Spreadsheet and paste them into a form text area and upon submission the data is parsed into correct data fields according to tab delineation and carriage return.

Has anyone worked with such a form and how did you accomplish it?