PHP 实现用户注册及登陆

用户登陆login.php：

<form action="logincheck.php" method="post">  
        用户名：<input type="text" name="username" />  
        <br />  
        密码：<input type="password" name="password" />  
        <br />  
        <input type="submit" name="submit" value="登陆" />  
              
        <a href="register.php">注册</a>  
    </form> 

用户登陆检查logincheck.php：

    <?php  
    
        if(isset($_POST["submit"]) && $_POST["submit"] == "登陆")  
        {  
            $user = $_POST["username"];  
            $psw = $_POST["password"];  
            if($user == "" || $psw == "")  
            {  
                echo "<script>alert('请输入用户名或密码！'); history.go(-1);</script>";  
            }  
            else  
            {  
                $con = mysqli_connect("localhost","root","123456");  
                mysqli_select_db($con,"user");  
                mysqli_query($con,"set names 'utf-8'");  
                $sql = "select username,password from userregister where username = '$_POST[username]' and password = '$_POST[password]'";  
                $result = mysqli_query($con,$sql);  
                if ($result != false)
                {
                    $num = mysqli_num_rows($result);
                    if($num)  
                    {  
                        $row = mysqli_fetch_array($result);  //将数据以索引方式储存在数组中  
                        echo $row[0];  
                    }  
                    else  
                    {  
                        echo "<script>alert('用户名或密码不正确！');history.go(-1);</script>";  
                    }
                  }
                mysqli_close($con);
            }  
        }  
        else  
        {  
            echo "<script>alert('提交未成功！'); history.go(-1);</script>";  
        }  
   
    ?> 

用户注册register.php：

    <form action="regcheck.php" method="post">   
        用户名：<input type="text" name="username" />  
        <br/>  
        密码：<input type="password" name="password"/>  
        <br/>  
        确认密码：<input type="password" name="confirm"/>  
        <br/>  
        <input type="Submit" name="Submit" value="注册"/>  
    </form>  

用户注册检查regcheck.php：

    <?php  
    
        if(isset($_POST["Submit"]) && $_POST["Submit"] == "注册")  
        {  
            $user = $_POST["username"];  
            $psw = $_POST["password"];  
            $psw_confirm = $_POST["confirm"];  
            if($user == "" || $psw == "" || $psw_confirm == "")  
            {  
                echo "<script>alert('请确认信息完整性！'); history.go(-1);</script>";  
            }  
            else  
            {  
                if($psw == $psw_confirm)  
                {  
                    $con = mysqli_connect("localhost","root","123456");   //连接数据库  
                    mysqli_select_db($con,"user");  //选择数据库  
                    mysqli_query($con,"set names 'utf-8'"); //设定字符集  
                    $sql = "select username from userregister where username = '$_POST[username]'"; //SQL语句  
                    $result = mysqli_query($con,$sql);    //执行SQL语句  
                    if ($result != false)
                    {
                        $num = mysqli_num_rows($result); //统计执行结果影响的行数  
                        if($num)    //如果已经存在该用户  
                        {  
                            echo "<script>alert('用户名已存在'); history.go(-1);</script>";  
                        }  
                        else    //不存在当前注册用户名称  
                        {  
                            $sql_insert = "insert into userregister (username,password) values('$_POST[username]','$_POST[password]')";
                            mysqli_free_result($num);  
                            $res_insert = mysqli_query($con,$sql_insert);  
                            //$num_insert = mysqli_num_rows($res_insert);  
                            if($res_insert)
                            {  
                                echo "<script>alert('注册成功！'); history.go(-1);</script>";  
                            }  
                            else  
                            {  
                                echo "<script>alert('系统繁忙，请稍候！'); history.go(-1);</script>";  
                            }  
                        }  
                                            mysqli_close($con);
                                        }
                }  
                else  
                {  
                    echo "<script>alert('密码不一致！'); history.go(-1);</script>";  
                }  
            }  
        }  
        else  
        {  
            echo "<script>alert('提交未成功！'); history.go(-1);</script>";  
        }  
    ?> 

mysql:(命令大全：http://c.biancheng.net/cpp/html/1448.html）

参考文章地址：

http://blog.csdn.net/jimoshuicao/article/details/17403327