Ở đây chúng tôi sử dụng 3 tệp để chèn dữ liệu trong cơ sở dữ liệu MySQL bằng AJAX.
- database.php
- index.php
- save.php
Bảng user_data
CREATE TABLE `user_data` [ `id` int[11] NOT NULL, `name` varchar[100] NOT NULL, `email` varchar[50] NOT NULL, `phone` varchar[100] NOT NULL, `city` varchar[50] NOT NULL ] ENGINE=InnoDB DEFAULT CHARSET=latin1;
database.php
index.php
Insert data in MySQL database using Ajax$[document].ready[function[] { $['#butsave'].on['click', function[] { $["#butsave"].attr["disabled", "disabled"]; var name = $['#name'].val[]; var email = $['#email'].val[]; var phone = $['#phone'].val[]; var city = $['#city'].val[]; if[name!="" && email!="" && phone!="" && city!=""]{ $.ajax[{ url: "save.php", type: "POST", data: { name: name, email: email, phone: phone, city: city }, cache: false, success: function[dataResult]{ var dataResult = JSON.parse[dataResult]; if[dataResult.statusCode==200]{ $["#butsave"].removeAttr["disabled"]; $['#fupForm'].find['input:text'].val['']; $["#success"].show[]; $['#success'].html['Data added successfully !']; } else if[dataResult.statusCode==201]{ alert["Error occured !"]; } } }]; } else{ alert['Please fill all the field !']; } }]; }];×Name:Email:Phone:City: Select Delhi Mumbai Pune