php連結mysql資料庫最簡單登入

標籤：null   method   表名   帳號   close   res   submit   count   asc   

<?php
    header("Content-type:text/html;charset=utf-8");
    $account = $_POST[‘account‘];
    $password = $_POST[‘password‘];
    echo ‘
        <form action="Login.php" method="POST">
            帳號：<input type="text" name="account"><br><br>
            密碼：<input type="password" name="password"><br><br>
            <input type="submit" value="登入">
        </form>
    ‘;
    function login($account,$password){
        $conn = mysql_connect ( "localhost" , "root" , "root" );
        $result = mysql_db_query ( "資料庫" , "select * from <表名> where ACCOUNT = ‘$account‘ and PASSWORD = ‘$password‘" , $conn );
        $row = mysql_fetch_row ( $result );
        if ($row != null){
　　　　　　　//判斷成立跳轉下一頁面
            echo ‘<script language="javascript">location.href="test1/index.php"</script>‘;
        }else{
            echo ‘登入失敗‘;
        }
        mysql_free_result ( $result );
        mysql_close ( $conn );
    }
    login($account,$password);
?>

php連結mysql資料庫最簡單登入