What is the principle of customizing forms

How does a custom form work? Users can insert data after a field is added to the background
My idea is that PHP write add field operations don't know right

Reply to discussion (solution)

I got a file for you.
How to implement a custom form simple discussion: http://blog.csdn.net/yytt123622/article/details/4272201
Give me some ideas, huh?
Create a custom form data table that creates an extended field for the data table based on the background administrator action;
In the foreground, by customizing the form ID or other unique information, the table field is paged out and the specific interface pattern is looped out; I don't know if I can understand.

I hope I can help you.

Phpcms has a custom form feature that you can look at

For example, the default provides three columns of database Autolie 3 users click the Add Column button after the database corresponding to the autolie+1
Render the interface with the JS Loop to draw on the line!

I got a file for you.
How to implement a custom form simple discussion: http://blog.csdn.net/yytt123622/article/details/4272201
Give me some ideas, huh?
Create a custom form data table that creates an extended field for the data table based on the background administrator action;
In the foreground, by customizing the form ID or other unique information, the table field is paged out and the specific interface pattern is looped out; I don't know if I can understand.

I hope I can help you.

What is the SQL statement for the extended field?

ALTER [IGNORE] TABLE tbl_name
Alter_specification [, Alter_specification] ...

Alter_specification:
ADD [COLUMN] column_definition [First | After Col_name]
| ADD [COLUMN] (column_definition,...)
| ADD INDEX [index_name] [Index_type] (Index_col_name,...)
| ADD [CONSTRAINT [symbol]]
PRIMARY KEY [Index_type] (Index_col_name,...)
| ADD [CONSTRAINT [symbol]]
UNIQUE [index_name] [Index_type] (Index_col_name,...)
| ADD [fulltext| SPATIAL] [index_name] (Index_col_name,...)
| ADD [CONSTRAINT [symbol]]
FOREIGN KEY [index_name] (Index_col_name,...)
[Reference_definition]
| ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
| Change [COLUMN] Old_col_name column_definition
[first| After Col_name]
| MODIFY [COLUMN] column_definition [First | After Col_name]
| DROP [COLUMN] Col_name
| DROP PRIMARY KEY
| DROP INDEX index_name
| DROP FOREIGN KEY Fk_symbol
| DISABLE KEYS
| ENABLE KEYS
| RENAME [to] New_tbl_name
| ORDER by Col_name
| CONVERT to CHARACTER SET charset_name [COLLATE collation_name]
| [DEFAULT] CHARACTER SET charset_name [COLLATE collation_name]
| DISCARD tablespace
| IMPORT tablespace
| Table_options
| Partition_options
| ADD PARTITION partition_definition
| DROP PARTITION Partition_names
| COALESCE PARTITION Number
| REORGANIZE PARTITION partition_names into (partition_definitions)
| ANALYZE PARTITION Partition_names
| CHECK PARTITION Partition_names
| OPTIMIZE PARTITION Partition_names
| REBUILD PARTITION Partition_names
| REPAIR PARTITION Partition_names

ALTER TABLE is used to change the structure of an existing table. For example, you can add or subtract columns, create or cancel an index, change the type of an existing column, or rename a column or table. You can also change the table's commentary and table type.

Feeling plus field is not good, plus an extension table to record the extended field is better.

