Info from form but don't know keys

[Anon]

I have a form that spits info to a php doc. The problem is, I don't know all the keys. The only way to get them is by querying the database for the Fields. However, my problem lies in trying to insert the data into the database. I can get my SQL INSERT statement to include all the fieldnames, but not the associated values from the form.

ie:
INSERT into mydb (Field1,Field2,Field3) VALUES (
This is where I run into problems. I've tried just inserting something like:
$value = "$" . "Field1";
but this gives me the literal $Field1 instead of the interpreted value from the form.

Hope I've explained this well enough 🙂

[flipis]

You can use this: (depends on what you want):

INSERT INTO table (field1,field2) VALUES (".$Field1.",".$Field2.");

escaped by '' where needed. (Strings)

Now, if you named your variables from a loop (Field1,Field2,Field3,etc...), u use this:

${$Field1};

so you can construct it like this:

$name = "Field$i"; //Asssume $i = 1
$value = ${$name};

value contains the real value from the form.

Hope this helps

fLIPIS

[Anon]

Yes thank you, the ${$Field} was exactly what I was looking for.