nhcar
/
checkuser.php

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <?php include_once 'functions.php'; ?>
        <?php
        //一、接收Form表单的数据
        echo "checkuser<br>";
        //var_dump($_POST);
        //关联数据是键对
        //array(3) { ["username"]=> string(3) "123" ["password"]=> string(3) "ddv" ["verify"]=> string(3) "aav" }
        $uname=$_POST['uname'];
        $upwd=$_POST['upwd'];
        echo "$uname $upwd<br>";

        //二、处理表单数据，操作数据表
        //1、连接数据库
        $link=  mysqli_connect("localhost", "root","" );//创建数据库连接，返回一数据库连接资源
        mysqli_select_db($link, "nhcar");//选择要使用的数据库
        mysqli_set_charset($link, "utf8");//设置连接的字符编码


        //2、操作数据库
        $sql="SELECT * FROM users WHERE uname='$uname' AND upwd='$upwd';";
        //mysqlli_query(数据库的连接，sql语句)如果select返回一个查询结果资源，如果是insert delete update返回true或false;
        $result= mysqli_query($link, $sql);
        //$num=mysali_num_rows($result);//返回的行数
        $row=  mysqli_fetch_array($result);//返回一行数据包含索引数组和关联数组
        //$row=  mysqli_fetch_assoc($result);//返回一行数据关联数组
        //$row=  mysqli_fetch_row($result);//返回一行数据索引数组
        var_dump($row);
        //exit();
        //3、处理结果数据，并返回
       if($row){
           //cookie存储用户ID、用户名
           $uid=$row['uid'];
           $uname=$row['uname'];
           //setcookie(键，值，过期时间)；//过期时间=当前时间+时间间隔=time()+3600*24*7
           //setcookie("czuid",$uid,time()+3600*24*7);//3600秒*24小时*7天
           //setcookie("czuname",$username,time()+3600*24*7);//3600秒*24小时*7天
           setcookie("nhuid",$uid,time()+15);//3600秒*24小时*7天
           setcookie("nhuname",$uname,time()+15);
           //echo "<script>alert(’登录成功！');location.href='index.php'</script>";
           //header("location:index.php");
           //echo "<script>alert('$msg');location.href='$url'</script>";
           go_forward("登录成功啦", "index.php");
       }  else {
           //echo "<script>alert(’登录失败！');location.href='login.php'</script>";
           //header("location:login.php");
           //echo "<script>alert('$msg');location.href='$url'</script>";
            go_forward("登录失败", "login.php");

       }
        ?>

    </body>
</html>