while loop with $_POST array

helz

lets say i have a big form and the sql query to enter it into the database would be too long and time consuming to do,
would this be possible?

$num = 0;
$sql .= "INSERT INTO $tablename (";
while ($_POST) {
  $var = $_POST['$num'];
  $sql .= "$var, ";
  $num++;
}
$sql = str_replace(strrchr($sql,", "),"",$sql);//gets rid of the extra comma and space at the end
$sql .= ") VALUES (";
$num = 0;
while ($_POST) {
  $var = $_POST['$num'];
  $sql .= "'$".$var."', ";
}
$sql = str_replace(strrchr($sql,"', "),"",$sql);//gets rid of the extra comma and space at the end
$sql .= ")";

should output:

INSERT INTO $tablename (var1, var2, var3) VALUES ('$var1', '$var2', '$var3')

YappyDog

I don't think you can use a while loop, but you should be able to use a foreach loop. This will give you the idea how.....

foreach($_POST AS $field => $value) {
echo "field = $field, value = $value";
}

helz

yea i was thinking while was wrong,
so theres hope for my idea yet!, i think its a good idea, aslong as the user
wants all the fields of the form to be included, would the submit button be added to, but only if it had a name tag?
<input type='submit' name='submit' value='Submit!'>

YappyDog

You'd probably need to throw in a little extra code that made sure you were not doing the 'submit' field.

helz

probobly just add an extra line to remove it like in the example i gave or just leave out the name='submit' part since its not needed unless in the php script you use:
if(isset($_POST['submit']))