submit form with multiple values for variable.

[grizzley]

Can somebody please explain to me in simple beginners terms how I can submit a form with more than one value for each variable to my database?

$tarifid and $tarifname can have multiple values which I am using to generate the table, and I need to insert corresponding values for 'pitch' and 'adult' entered by the user to the database, and want to do it with one submit button, one form if possible without getting too complicated.

echo "<form action='updatecampingpricelist.php' method='get' name='FormName'>";	
 
 
	echo "<table width='100%' border='1' cellspacing='2' cellpadding='0'>";
 
	echo "<tr><td>Tarif id</td>";
	echo "<td>Tarif name</td>";
	echo "<td>Pitch</td>";
	echo "<td>Adult</td></tr>";
 
 
 
$sql = @mysql_query("select tarifid, tarifname from campingtarif");
 
	while ($campingtarif = mysql_fetch_array($sql))	{
		$tarifid = $campingtarif['tarifid'];
		$tarifname = $campingtarif['tarifname'];
 
	echo "<tr valign = 'center'>\n";
 
echo "<td align = 'center'>" . $tarifid . "</td>\n";
echo "<td align = 'center'>" . $tarifname . "</td>\n";
echo "<td align = 'center'>£<input type='text' name='pitch'></td>\n";
echo "<td align = 'center'>£<input type='text' name='adult'></td>\n";
 
}
echo "</table>";
 
echo "<p><input type='submit' value='submit'></p>";	
 
echo '</form>';

[spiderling]

Is it pitch and adult that have multiple values that a user would input into the field? Can you include the relevant tables you are using.

[grizzley]

pitch and adult are entered by user against values for $tarifid and $tarifname which are already set.
Tables involved are

describe campingtarif
tarifid int not null primary key auto_increment
tarifname  text not null

select all to get $tarifid and $tarifname

describe campingprices
tarifid int not null primary key
seasonid int not null
pitch decimal(7,2) not null
adult decimal(7,2) not null

[grizzley]

got interupted and never finished that!
To help clarify the aim is to create new price list for items $pitch and $adult for predefined services ($tarifid and $tarifname) available between specified dates ($season). $tarifid, $tarifname and $season all set on an earlier page.

[crmalibu]

php supports a specific request variable naming syntax which it will parse into arrays for you. It works a lot like native php arrays.

http://www.php.net/manual/en/faq.htm...aq.html.arrays

<input name="data[0][pitch]">
<input name="data[0][adult]">

<input name="data[1][pitch]">
<input name="data[1][adult]">

<input name="data[2][pitch]">
<input name="data[2][adult]">

php will provide you with a multidimensional array

print_r($_POST['data']);

foreach ($_POST['data'] as $associated_fields) {
    echo $associated_fields['pitch'] . $associated_fields['adult'] . "\n";
} 

[grizzley]

Thats a big help.

Table now altered like this using $tarifid as index

echo "<td align = 'center'>" . $tarifid . "</td>\n";
echo "<td align = 'center'>" . $tarifname . "</td>\n";
echo "<td align = 'center'>£<input type='text' name='data[$tarifid][pitch]' size='8'></td>\n";
echo "<td align = 'center'>£<input type='text' name='data[$tarifid][adult]'8'></td>\

Gives this array with sample values inserted

Array ( [1] => Array ( [pitch] => 20 [adult] => 12 ) [2] => Array ( [pitch] => 18 [adult] => 15 ) [4] => Array ( [pitch] => 25 [adult] => 50 ) )

But how do I now get $tarifid out of this to include in echo?

echo $tarifid . $associated_fields['pitch'] . $associated_fields['adult'] . "\n";

[crmalibu]

<input name="data[0][tarifid]" value="475">

You could use type=hidden if desired


Or, if tarifid is unique, and is a value that is suitable to use as a php array key, you could use it as one. eg 475

<input name="data[475][pitch]">
<input name="data[475][adult]">

foreach ($_POST['data'] as $tarifid => $associated_fields) 

[grizzley]

Thanks for that.

Using type = hidden seems to work ok.

But as a beginner to php I'm still having a bit of a problem getting my head around arrays - creating them and then sorting results and identifying specific items. For example, in the array created originally how would I output

array[2] pitch>=18

for further processing on its own?

Purely academic in this instance but the sort of thing I'm struggling with.

Any advice / worthwhile reading at a level I can understand appreciated.