ajax存储表单数据,使用ajax json将表单数据存储到数据库php

我试图在数据库中存储表单数据，但是我的代码反映了任何内容。 这里是我的代码使用ajax json将表单数据存储到数据库php

add.php

Student information:-

• FirstName:

  Only alphabets

• LastName:

  Only alphabets

• Username:

• Password:

Gender:

Male

Female

Other

Email:

Invalid email

Mobile:

only digits

address:

Register

和JavaScript文件是

serve.js

$(document).ready(function() {

$("#btnBooking").on("click", function (e) {

// as you have used hyperlink(a tag), this prevent to redirect to another/same page

e.preventDefault();

// get values from textboxs

var name = $('#name').val();

// alert('name');

var lname = $('#lname').val();

var username = $('#username').val();

var password = $('#password').val();

var gender = $('#gender').val();

var mail = $('#email').val();

var mobNum = $('#mobile').val();

var address = $('#address').val();

$.ajax({

url: "http://localhost/project_cloud/fun.php",

type: "post",

dataType: "json",

data: {type: "add", Name: name, Lname: lname, User: username, Pass: password, Gen: gender, Email: mail, Mob_Num: mobNum, Addr: address},

//type: should be same in server code, otherwise code will not run

ContentType: "application/json",

success: function (response) {

alert(JSON.stringify(response));

},

error: function (err) {

alert(JSON.stringify(err));

}

})

});

});

和存储结果另一个PHP文件在数据库中

fun.php

header('Access-Control-Allow-Origin: *');

mysql_connect("localhost", "root", "");

mysql_select_db("ocean");

if (isset($_GET['type'])) {

$res = [];

if ($_GET['type'] == "add") {

$name = $_GET ['Name'];

$lname = $_GET['Lname'];

$userN = $_GET['User'];

$passW = $_GET['Pass'];

$gen = $_GET['Gen'];

$mail = $_GET ['Email'];

$mobile = $_GET ['Mob_Num'];

$address = $_GET['Addr'];

$query1 = "insert into oops(username, password, firstname, lastname, gender, email, mobile, address) values('$userN','$passW','$name','$lname','$gen','$mail','$mobile','$address')";

$result1 = mysql_query($query1);

if ($result1) {

$res["flag"] = true;

$res["message"] = "Data Inserted Successfully";

} else {

$res["flag"] = false;

$res["message"] = "Oppes Errors";

}

}

} else {

$res["flag"] = false;

$res["message"] = "Invalid format";

}

echo json_encode($res, $result1);

?>

当我写在add.php文件我serve.js文件代码它给我造成存储在数据库中。但是，当我试图分开它的JS文件就说明什么。它有什么不对或者我错过了什么。

2016-07-16

oceanier

+0

在您的Ajax请求您发布的数据，但在你的PHP文件(fun.php)尝试检索数据GET($ _GET)。 –