[RESOLVED] First in table insert

[Double_M]

Hi,

I have a very large form and its anoying to get each form name seperatly and insert them into the database, as you could imagine the sql insert statement will be huge. Is there a way i could 'foreach' the post variables and insert them into the database without using the names from the fields.

I mean that could i for example insert into the first field in the table and then the second and so on?

i.e.
foreach ($post as $key => $val){

INSERT INTO blabla SET (the first field) to $postvar

}

[devinemke]

are all of the returned form fields going into a single db row? are the form fields in the same order as the db fields?

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	field 1: <input type="text" name="data[1]"><br>
	field 2: <input type="text" name="data[2]"><br>
	field 3: <input type="text" name="data[3]"><br>
	field 4: <input type="text" name="data[4]"><br>
	field 5: <input type="text" name="data[5]"><br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	foreach ($_POST['data'] as $key => $value)
	{
		$value = trim($value);
		$value = addslashes($value); // assuming magic_quotes is OFF
		$array[] = "'" . $value . "'";		
	}

$sql = 'INSERT INTO table VALUES (' . implode(',', $array) . ')';
echo $sql;
}
?>

[Double_M]

Yep same row and same order 🙂

[Double_M]

That works great thanks very much 😃