[SOLVED] A quick way to do this... loop $_POST

[Perad]

ok I have 20 forms each with 20+ inputs. After writing an SQL function for 1 I have realised that I would rather chop of my balls than do the rest of them manually. Is it possible to loop through $_POST so it will do something like this this...

 

In this case $_POST would be 'mwireless'...

 

 

$mwireless = $this->cleanString($_POST['mwireless']);

$sql = "INSERT INTO dbname (mwireless, ... ) VALUES ('$mwireless',..)";

 

Please tell me this can be done.

[MadTechie]

what about this

 

foreach($_POST as $K => $V)
{
//may want to clean $K as well
$Clean[$K] = $this->cleanString($V);
}

$fields = implode(",",array_keys($Clean));
$Values = implode("','",$Clean);

$sql = "INSERT INTO dbname ($fields) VALUES ('$Values')";

[Perad]

Ah thank you so much, just needed to filter out the $_POST['submit'] and it ran perfectly, now I have a shot of finishing this today