Looping though and Insert or Update Query?

nelsons

Have a table in a DB with the following:

ID - Primary Key-
Username
Jobnumber
Hours

Have a form with 5 username and dropdowns below each (for the hours per user - each form element is named the same name as the user).
form.php
Example(username):
Bob     Terri     Fred     Pat     Bill

form_process.php
When I go to drop these into the one table - each must have its own record. They will all have the same job number on input per form submission.

Whats the best method or technique to use? Sure I can manually do an if and sniff out if a number has been selected, then do an SQL insert on each one in turn, but something tells me theres a smarter way.

devinemke

how exactly is are dropdowns being populated? post the code from form.php.

nelsons

Typical drop down - manually entered
<select name="bob_hours" id="a">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
</select>

They are blank (non-selected) on entry into the form.

devinemke

here's an example that just echos the SQL. you didn't mention where "jobnumber" is coming from so i just used "???".

$users = array(
	'Bob',
	'Terri',
	'Fred',
	'Pat',
	'Bill' 
);

echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="POST">';
foreach ($users as $value)
{
	echo $value . ': <select name="hours[' . $value . ']">';
	for ($i = 1; $i <= 8; $i++) {echo '<option>' . $i . "\n";}
	echo '</select><br><br>'; 
}
echo '<input type="submit" name="submit" value="submit"></form>';

if (isset($_POST['submit']))
{
	foreach ($_POST['hours'] as $key => $value)
	{
		$sql = "INSERT INTO table SET username = '$key', jobnumber = '???', hours = '$value'";
		echo $sql . '<br>';
	}
}