System and method for creating integrated web form and database applications

A method for creating integrated web form and database applications comprising:

• accepting a form definition based on a plurality of form elements from a form interface, wherein said form interface is configured to provide a user interface with a visual WYSIWYG representation and a drag-and-move functionality to create at least one web form comprising said plurality of form elements;
• presenting a code generation interface configured to generate PHP code and database commands based on said form definition, wherein said code generation interface allows said user to review and manually edit said PHP code, wherein said PHP code associates with a visual appearance based on said visual WYSIWYG representation;
• creating said PHP code to implement said form definition;
• generating a database schema for said at least one web form based on said plurality of form elements;
• generating a SQL file to implement said form definition and said schema based on said PHP code, wherein said database schema is automatically modified and new SQL statements generated based on changes to said web form through said form interface;
• creating backend database structures to support said at least one web form;
• publishing said PHP code and said SQL file to a server associated with said database;
• and
• executing said SQL file on said server associated with said database.

A non-transitory computer-readable medium comprising computer-readable instructions for providing integrated web form and database applications, wherein execution of said computer-readable instructions by one or more processors causes said one or more processors to:

• accept a form definition based on a plurality of form elements from a form interface, wherein said form interface is configured to provide a user interface with a visual WYSIWYG representation and a drag-and-move functionality to create at least one web form comprising said plurality of form elements;
• present a code generation interface configured to generate PHP code and database commands based on said form definition, wherein said code generation interface allows said user to review and manually edit said PHP code, wherein said PHP code associates with a visual appearance based on said visual WYSIWYG representation;
• create said PHP code to implement said form definition;
• generate a database schema for said at least one web form based on said plurality of form elements;
• generate a SQL file to implement said form definition and said schema based on said PHP code, wherein said database schema is automatically modified and new SQL statements generated based on changes to said web form through said form interface;
• create backend database structures to support said at least one web form;
• publish said PHP code and said SQL file to a server associated with said database;
• and
• execute said SQL file on said server associated with said database.