MySQL

Top  Previous  Next

Use “mysql_query” action to work with MySQL database

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