require "conn.php"; //引入数据库;
header('Access-Control-Allow-Origin:*');//解决跨域跨域调用
插入数据:
$user=$_GET["username"];
$pwd=$_GET["pwd"];
$sql="insert into reg (user,pwd,time)value('$user','$pwd',now())";
$result=mysqli_query($conn,$sql);
if($result){
echo "true";
}else{
echo "false";
}
查询数据:
$result=mysqli_query($conn,"select user from reg");
$arr=array();
if(mysqli_num_rows($result)>0){//判断是否有数据
while($row=mysqli_fetch_assoc($result)){//取出数据
$arr[]=$row["user"];
}
}
echo json_encode($arr);
查询验证:
$name=$_GET["username"];
$pwd=$_GET["pwd"];
$res=mysqli_query($conn,"select * from reg where user='$name' and pwd='$pwd' ");
if(mysqli_num_rows($res)){
echo "1";
}else{
echo "0";
}
修改数据:
$id=$_GET["id"];
$user=$_GET["user"];
$pwd=$_GET["pwd"];
$up=mysqli_query($conn,"update reg set user='$user',pwd='$pwd' where id='$id'");
if($up){
echo "1";
}else{
echo "0";
}
删除数据:
$id=$_GET["id"];
$res=mysqli_query($conn,"delete from reg where id='$id'");
if($res){
echo "1";
}else{
echo "0";
}