MySQL

Use “mysql_query” action to save data to MySQL database. This action works with INSERT and UPDATE queries. If you want to get data from MySQL database, please use Database Select action.

Syntax:

mysql_query = <query>

“query” may be any valid MySQL query.

Example:

mysql_query = INSERT INTO mytable (name, email) VALUES ("{#name#}", "{#emai#}")

Entities {#name#} and {#email#} will be changed to user submitted data on “name” and “email” field.

To set MySQL hostname, username, and password use the following settings in your config.php file:

mysql_host - MySQL hostname

mysql_user - MySQL username

mysql_password -MySQL password

mysql_db - the name of MySQL database to be used

These settings are common for for all forms and must be set in the first section of config.php before form configuration blocks.