Question about "if(isset"

[mike94]

Hi,
I'm a PHP newbie and I'm stumped on a piece of making a form submit.

A little background:
- I am trying to make the if(isset($_POST)) dynamic since I will have many pages that have the same basic function but will place data into different tables/fields.
- I am able to get the form to submit correctly if I don't use any variables, and hard code something like: $name1 = $_POST['name1'];

The process works like this:
1) A form is created that automatically is given a name. For example:

<div class='form-group'><textarea class='form-control' rows='5' name='{$name1}'>{$sampleData}</textarea></div>.

I should note that according to the HTML source code, there is no issue assigning the correct name and the form looks correct. I will also note that with any given form, there maybe 1 or 5 ...or some other number of fields.
2) I send the information via post and this is where it is getting tricky. What I have is below:

if(isset($_POST['submit'])){
$name1 = $_POST['name1'];
$name2 = $_POST['name2'];
$name3 = $_POST['name3'];
$nextPage = $_POST['nextpage'];
$date = date('Y-m-d H:i:s');
$userid = 10;

	if(isset($_POST['submit'])) {
	header("Location: /pages/$nextPage"); 
	$query = "INSERT INTO tablename (id, field1,field2, field3, lotdrivewaydate) ";
	$query .= "VALUES ($userid, '$name1', '$name1', '$name2', '$name3') ";
    $result = mysqli_query($connection, $query);
    echo "$nextPage";
	if(!$result) {
    die("QUERY FAILED" . mysqli_error($connection));    
   }
	}
}

So you will first notice that $name1 = $_POST['name1']; and the column names are hard coded. Is there a good way to pull my automatically generated form names into $_POST? How about automatically pulling in the column names?

I've been working on this for quite a while and haven't been able to crack it. Hopefully, this is clear but let me know if I can provide more detail. Thank you in advance for any ideas you all have!

[DyDr]

You would write or find (this is not the first time anyone has done this) a 'form generator/form processor' script.

You would define the dynamic information about your form (each field name, label, field type, field parameters, css class for styling, if existing data should populate the field, and any other things you can think of...) and form processing code (if a value is required or not, data type - type of validation, and any other things you can think of...) somewhere (a database table, php array), then use that information to dynamically produce the form (which it sounds like you are already doing) and dynamically process the submitted form data.

Instead of the hard-coded logic you have posted to processes the form data, you would loop over the definition you have created and validate each field based on the definition. At the end, if there are no validation errors, you would use the submitted form data.

For the database query(ies) that use the data, after you have validated it, you would do something similar, define the dynamic information needed to build the queries (table name, field names that are permitted for each type of query, what to use as the data source for each field, ...), to make a general purpose CRUD (Create - Insert, Read - Select, Update, Delete) application.