Help with a dynamic form please

ali_p

Hi,

I have built a form with some elements being stored in my database table. This is so that my client can build their own form online and create their own fields. So for example they have built a form where they require a text field called 'username', the field name username is stored in my table along with the field type ( textbox ).

Now I can out put all the relevant fields to form a form, I have done this using the code attached.

However I am stuck at how to pick up all the different field names and process them on the submit page.

Any ideas would be greatly appreciated please.

Weedpacket

They're the keys of the $_POST array, aren't they?
[man]array_keys[/man].

djjjozsi

in the field table, you have an ID field, encode its number, and use that as field name, for example:

field_name["xxxxxxxxxxxxxx"] (where xxxx is the encoded ID value.)

And if i filled out the form, but there was an error (i missed one field) shouldn't i filled once the previously filled fields, So lets use values stored in SESSION.

ali_p

Thanks for the reply, but sorry I'm none the wiser.

djjjozsi

this is schematic example, maybe useful.

IF you have the table:

forms_names: form_id/B , Form_name , url

you have the form_elements table: elements_id/B , form_id(FK) , label , type , order_number

you have a results table: id/B , session_id , elements_id(FK) , value

select the fieldname properties from the form_elements using a $form_id.

$sql="SELECT * FROM form_elements WHERE form_id='$form_id' ORDER BY order_number";

You create a form, use <form method="post" action="forms.php">

you take the form elements depending from the type as in your code, but:

build the cases, and if your field is a checkbox or a password or a textfield use this method to make the pre-filled values:

variable names consist of the row's ID with an encryption.

$variabl_name=SHA1($one_row["elements_id"]);
if(isset($_POST["field"][$variabl_name]))
$value=" value=\"{$_POST["field"][$variabl_name]}\"";
else
$value=" value=\"\"";

echo "<input type=\"$type\" name=\"field[$variabl_name]\" $value>";

And finish the following form elements.

Use a hidden value, to store which form you're standing.

echo "<input type=\"hidden\" name=\"form\" value=\"$form_id\">";

How your process php looks like (forms.php)?

select the meta data from the form_elements table

You have the list of the elements_id, with that you can check and read the $POST array.
And

$variabl_name=SHA1($one_row["elements_id"]);

is the same method how you can know the $_POST indexes.

And build an sql query to insert the results into results table.

got question, free to ask 🙂