To save form data to MySQL database, you will have access to a MySQL database. JQuery form DOES NOT magically create database and table for you.
CREATE DATABASE form2db; CREATE TABLE `demo` ( `id` INT(10) UNSIGNED NOT NULL auto_increment, `name` TINYTEXT NULL, `comments` TEXT NULL, `email` VARCHAR(100) NULL DEFAULT NULL, `AutoID` varchar(64) NULL DEFAULT NULL, `HTTP_HOST` varchar(255) NULL DEFAULT NULL, `IP` varchar(15) NULL DEFAULT NULL, `Date` varchar(16) NULL DEFAULT NULL, `Time` varchar(16) NULL DEFAULT NULL, `HTTP_REFERER` text, PRIMARY KEY (`id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB; GRANT ALL ON form2db.* TO 'form2db_user'@'localhost' IDENTIFIED BY 'form2db_pass'; flush privileges;
class Form2DB { // mysql private $db = array( 'host' => '127.0.0.1', 'db' => 'form2db', 'user' => 'form2db_user', 'pass' => 'form2db_pass', 'charset' => 'utf8', ); private $table = 'demo'; /* define the mapping between form field IDs and table columns */ private $fieldMap = array( // formFieldID => columnName 'f1' => 'name', 'f2' => 'email', 'f3' => 'comments', 'AutoID' => 'AutoID', 'HTTP_HOST' => 'HTTP_HOST', 'IP' => 'IP', 'Date' => 'Date', 'Time' => 'Time', 'HTTP_REFERER' => 'HTTP_REFERER', ); ... }See screenshot below.