This article explains data insertion in MySql using HTML Form. You must have seen contact/feedback Forms in many websites. These Forms are designed using standard HTML Form elements. On the back end, SQL queries are used to perform DML operation using information provided by user. Any server side scripting language can be used to insert data in database. Following steps explain this process using PHP and MySql. 1- First of all create a table in MySql database using following command. This command can be executed in any MySql query browser like phpMyAdmin.
CREATE TABLE contact ( msg_id int(11) not null auto_increment, name varchar(255) NOT NULL , email varchar(255), msg varchar(2000) NOT NULL, PRIMARY KEY (msg_id))
|