Returning names of posted form fields using HTTP_POST_VARS

[dotbob]

Hi all,

I have a slightly large form with 73 fields (don't ask) that I am posting to a php script which takes the POSTed information and stores it within a DB.

No probs there, well, no probs getting the form data anyway using the $HTTP_POST_VARS predefined var.

I can handle the rest of the code with regards to storing the data in the DB. What I need to know is if anyone knows a way of returning the actual field name or id within the POSTed results.

i.e. with a form field like: <input type="text" name="test1" id ="test1" value="sometext">

$HTTP_POST_VARS would contain the value of sometext but there is no way (that I know of) of identifying which field this data originated from, and as I'm sure you can appreciate, 73 fields is a hell of a lot of data to try and sort.

Appreciate any help anyone could offer.

[dotbob]

Never mind

Figured it out!

😉

[cahva]

This goes thru every posted variables. This uses $POST instead of $HTTP_POST_VARS(but if you have PHP version greater than 4.1.0 installed you should use $POST)

If you are inserting those values to db and have equal names to your post-variables, it isnt hard to build INSERT-query.

// get keys and values from $_POST. Checks if key is 'submit' because you dont wanna add that
foreach($_POST as $key=>$value)
{
if ($key<>'submit') {
$querynames.="$key,";
$queryvalues.="'$value',";
}
}
// Take the "," off the ends
$querynames=substr($querynames,0,-1);
$queryvalues=substr($queryvalues,0,-1);

//build query
$query="INSERT INTO table ($querynames) VALUES ($queryvalues)";

Test it b'cos I wrote that from my memory. But it should go like that..

[cahva]

Oh, you sorted it out... What a waste of time that was.. 🙂

[dotbob]

Thanks for that.

It's a different method to the one that I thought of but more effective.

Our internal dev setup uses PHP 4.0.6 so unfortunately I must stick to the deprecated HTTP_POST_VARS.