<?php  

    if(isset($_POST['name'])||isset($_POST['pass'])){  

        //如果有表單有提交  

        //檢測(cè)表單中需要的值  

        if(empty($_POST['name'])){  

            die("請(qǐng)輸入用戶(hù)名！");  

        }  

        if(empty($_POST['pass'])){  

            die("請(qǐng)輸入密碼！");  

        }  

        //設(shè)置數(shù)據(jù)庫(kù)變量  

        $host = "localhost";  

        $user = "root";  

        $pass = "zq19890319";  

        $db = "cookie";  

        //打開(kāi)連接  

        $connection = mysql_connect($host, $user, $pass) or die("Unable to connect!");  

        //選擇一個(gè)數(shù)據(jù)庫(kù)  

        mysql_select_db($db) or die("Unable to select database!");  

        //建立一個(gè)查詢(xún)  

        $query = "SELECT * FROM users WHERE name = '".$_POST['name']."' AND pass = SHA1('".$_POST['pass']."')";  

        //執(zhí)行一個(gè)查詢(xún)  

        $result = mysql_query($query) or die("Error in query:$query." . mysql_error());  

        //是否有記錄集返回  

        if(mysql_num_rows($result) == 1){  

            //如果有一行記錄返回  

            //表示驗(yàn)證已經(jīng)通過(guò)  

            //建立一個(gè)session，設(shè)置一個(gè)登陸標(biāo)記為1，并將當(dāng)前用戶(hù)名保存在cookie中  

            session_start();  

            $_SESSION['auth'] = 1;  

            setcookie("username", $_POST['name'], time()+(84600*30));  

            echo "用戶(hù)訪問(wèn)已經(jīng)授權(quán)！";  

        }else{  

            echo "錯(cuò)誤的用戶(hù)名或密碼！";  

        }  

        //釋放記錄集  

        mysql_free_result($result);  

        //關(guān)閉數(shù)據(jù)庫(kù)  

        mysql_close($connection);  

    }  

    else{  

        //如果沒(méi)有表單提交，則顯示一個(gè)HTML表單  

    ?>  

    <html>  

    <head></head>  

    <body>  

        <center>  

            <form method="post" action="">  

            用戶(hù)名<input type="text" name="name" value="<?php echo $_COOKIE['username'];?>" />  

            <p />  

            密碼<input type="password" name="password" />  

            <p />  

            <input type="submit" name="submit" value="登陸" />  

            </form>  

        </center>  

    </body>  

<?php  

    }  

?>