ajax向mysql传数据类型_web端通过ajax向MySql传数据

首先在js中定义一个方法 uploadData，代码如下

function uploadData(wifinamePa,addsPa,hottagPa,areaPa,locationtypePa,latPa,lngPa){

//document.getElementById("upload").value = "Processing";

registerRequest = createRequest();

if(registerRequest == null){

alert("Unable to upload the data.");

} else{

var url = "course_collect.php";

//var requestData = "lat=" + latPa +

// "&lon=" + lngPa;

var requestData ="wifi_name=" + wifinamePa +

"&wifi_adds=" + addsPa +

"&hot_tag=" + hottagPa +

"&area=" + areaPa +

"&location_type=" + locationtypePa +

"&lat=" + latPa +

"&lon=" + lngPa;

//registerRequest.onreadystatechange = registrationProcessed;

registerRequest.open("POST",url,true);

registerRequest.setRequestHeader("Content-Type","application/x-www-form-urlencoded;charset=utf-8");

registerRequest.send(requestData);

}

}

其中函数中的形参就是你要传输的数据，再添加一个发送请求的方法 代码如下

function createRequest(){

try{

request = new XMLHttpRequest();

}catch(tryMS){

try{

request = new ActiveXObject("Msxm12.XMLHTTP");

}catch(otherMS){

try{

request = new ActiveXObject("Microsoft.XMLHTTP");

}catch(failed){

request = null;

}

}

}

return request;

}然后调用uploadData方法，将实际的参数值传进去即可，接下来定义一个负责接收数据的php文件，代码如下：

$con = mysql_connect("localhost","root",null);

mysql_query($con, "SET NAMES 'UTF8'");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("a0722152915", $con);

mysql_query("SET NAMES 'UTF8'");

$sql="INSERT INTO access_point (wifi_name,wifi_adds,hot_tag,area,location_type,lat, lon)

VALUES

('$_POST[wifi_name]','$_POST[wifi_adds]','$_POST[hot_tag]','$_POST[area]','$_POST[location_type]','$_POST[lat]','$_POST[lon]')";

if (!mysql_query($sql,$con))

{

die('Error: ' . mysql_error());

}

echo wifi_name;

mysql_close($con)

?> 可以完成数据上传MySql，在表中就可以看到上传的数据了