<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<script src="js/1.js" type="text/javascript" charset="utf-8">
</script>
</head>
<body>
<p>
user:<input type="text" id="uname" />
<br>
password:<input type="password" id="upwd" />
<br>
email:<input type="text" id="uemail" />
</p>
<input type="button" value="login" onclick="test()"/>
<script type="text/javascript">
function test(){
//创建异步对象
var xhr=creatXhr();
//绑定事件
xhr.onreadystatechange=function(){
if(xhr.readyState==4 && xhr.status==200){
var res=xhr.responseText;
alert(res);
}
}
//打开连接
xhr.open("POST","6.php",true);
xhr.setRequestHeader("Content-Type","application/x-www-from-urlencoded");
var uname=$("uname").value;
var upwd=$("upwd").value;
var uemail=$("uemail").value;
var msg="uname="+uname+"&upwd="+upwd+"&uemail="+uemail;
//发送请求
xhr.send(msg);
}
</script>
</body>
</html>
js 的代码
//获取值的方法:
function $(id){
return document.getElementById(id);
}
//创建异步对象
function creatXhr(){
var xhr=null;
//判断window.XMLHttpRequest
if(window.XMLHttpRequest){
//标准创建
xhr=new XMLHttpRequest();
//console.log("支持标准创建:"+window.XMLHttpRequest);
}else{
//IE8以下创建
xhr=new ActiveXObject("Microsoft.XMLHttp");
//console.log("不支持标准创建:"+window.XMLHttpRequest);
}
return xhr;//返回异步对象
}
它报的错:
php代码:(php我测试了对着呢)
<?php
#接收数据
$uname=$_REQUEST["uname"];
$upwd=$_REQUEST["upwd"];
$uemail=$_REQUEST["uemail"];
#连接数据库
require("mysql.php");
#sql语句:
$sql="insert into ypc_1 (uname,upwd,uemail) values ('$uname','$upwd','$uemail')";
//$sql="INSERT INTO ypc_1 (uname,upwd,uemail) VALUES ('{$uname}','{$upwd}','{$uemail}')";
//$sql="select * from ypc_1";
$result=mysqli_query($conn,$sql);
if($result===true){
echo "成功<br> ";
}else{
echo "失败 $sql";
//echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
?>
看问题在插入失败,但是没具体的详细信息
把echo "失败 $sql"; 这句话把 $result也加上,看看是哪里出了问题,
也有可能是传过来的参数没有接收到,所以导致了插入失败
加了没有报错