注册/登录怎么做:给数据库增加数据
页面:
<ul>
<li>账号:<input class="num" type="text"></li>
<li>密码:<input class="pwd" type="text"></li>
<li>姓名:<input class="name" type="text"></li>
<li>性别:<input class="sex" type="radio" name="sex" value="男" checked>男<input type="radio" name="sex" value="女">女</li>
<li>年龄:<input class="age" type="text"></li>
<li>邮箱:<input class="email" type="text"></li>
<li>地址:<input class="address" type="text"></li>
<li id="btn"><button>注册</button></li>
</ul>
<ul>
<li>账号:<input class="usernum" type="text"></li>
<li>密码:<input class="userpwd" type="text"></li>
<li id="logo"><button>登录</button></li>
</ul>
js:
$("#btn").click(function () {
var num = $(".num").val();
var pwd = $(".pwd").val();
var name = $(".name").val();
var sex = $(".sex:checked").val();
var age = $(".age").val();
var email = $(".email").val();
var address = $(".address").val();
$.ajax({
method: "post",
url: "http://localhost:8080/regestInfo.php",
data: {number: num, pwd: pwd, name: name, sex: sex, age: age, email: email, address: address}, //冒号前面为后台接收值,后面为给后台传的变量值
success: function (res) {
if (res == "success") {
console.log(res);
alert("注册成功!");
}
}
});
});
$("#logo").click(function(){
var userid=$(".usernum").val();
var userpwd=$(".userpwd").val();
$.ajax({
method:"post",
url:"http://localhost:8080/userLogin.php",
data:{num:userid,pwd:userpwd},
dataType:"json",
success:function(res){
if(res[0].count>0){
alert("登录成功!");
}
}
});
});
regestInfo.php:
<?php
header('Access-Control-Allow-Origin: * ');
header('Content-type: text/html;charset=utf-8');
//造连接对象
$db = new MySQLi("localhost","root","12345678","blog");
mysqli_query($db,"SET NAMES 'UTF8'");
//写SQL语句
$sql = "insert into user(number,pwd,name,sex,age,email,address) values('$_POST[number]','$_POST[pwd]','$_POST[name]','$_POST[sex]',$_POST[age],'$_POST[email]','$_POST[address]')";
//检测连接数据库是否成功,失败返回“连接失败”,并退出程序
if(mysqli_connect_error()){
die("连接失败");
}
//执行SQL语句,返回结果集对象
$result = mysqli_query($db,$sql);
if(!$result){
echo "error";
}
else{
echo "success";
}
?>
userLogin.php:
<?php
header('Access-Control-Allow-Origin: * ');
//造连接对象
$db = new MySQLi("localhost","root","12345678","blog");
mysqli_query($db,"SET NAMES 'UTF8'");
//写SQL语句
$sql = "select count(*) as count from user where number='$_POST[num]' and pwd='$_POST[pwd]'";
//检测连接数据库是否成功,失败返回“连接失败”,并退出程序
if(mysqli_connect_error()){
die("连接失败");
}
//执行SQL语句,返回结果集对象
$result = mysqli_query($db,$sql);
//判断结果有无数据
$data=array();
class User{
public $count;
}
if($result->num_rows){
while($row = mysqli_fetch_array($result))
{
$user=new User();
$user->count=$row["count"];
$data[]=$user;
}
}
echo json_encode($data);
?>