Inserting Associative Array to MySQL via PHP with unknown keys

There should be an information_schema database that contains the table names, field names and the ordinal position of each field in that table.

1. You query this database as follows:

    $sql = "select column_name, data_type from information_schema.columns
            where table_name = '$table_name' ORDER BY ordinal_position";
   

   Note: I also query the data_type because it can be useful in these operations.

2. Save this information to an array. (This is your master)

3. Iterate through your associative array (outer-loop) while iterating through each element in your master (inner-loop). Any keys in your outer that are not found in your inner are added to the table.

4. Add any new columns to table (there are plenty of example sql statements for adding columns).

5. Requery #1 to get a new master.

6. Next, iterate through your master (outer-loop) while iterating through your original associative array (inner-loop). When there's a field name match add the field name and value to a new array (you could also use two strings: $fields and $values).

7. The new array (or strings) will now have all the fields/values in the right order, and you can use this to build your insert SQL statement.

   INSERT INTO table_name (column1, column2, column3,...)
   VALUES (value1, value2, value3,...) 
   

To Insert data from Associative Array to MySQl Please follow the below steps.

Step 1: Remove the Elements those are not the table columns.Example from your POST array please remove the Submit Buttons Value.

unset($_POST['submit']);

If you want to add any other column's values to table you may add the same to the array.Like if you want to save client IP address,Then use like

$_POST['customer_ip'] = $_SERVER['REMOTE_ADDR'];

Step 2: $query = "INSERT INTO table_name SET ";

foreach($_POST as $column => $column_value) {
    $query .= $column." = '".$column_value."'";
}

$query contents the desired SQL Query to execute.

mysqli_query($query);