ubantu下php和myql实现登陆功能并且在主页显示用户名

约定不等于承诺〃 2022-01-22 10:51 150阅读 0赞

直接上代码：

登陆表单【**login.php**】

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    
    <br/><br/><br/><br/><br/><br/><br/>
    
    
    			<form action="logcheck.php" method="post">
    				<div class="sign-ipt f-l">
    					<p>用户名：</p>
    					<input type="text" name="id" placeholder="ID" />
    					<p>密码：</p>
    					<input type="password" name="pwd" placeholder="密码" />
    					<br />
    					<button class="slig-btn">登录</button>
    					<p>
    						没有账号？请
    						<a href="register.php">注册</a>
    					</p>
    				</div>
    			</form>
    
    
    </body>
    </html>

登陆后台检测【**logcheck.php**】

<?php
        session_start();
        header("Content-type: text/html; charset=utf-8");
        $username = $_POST['id'];
        $password = $_POST['pwd'];
        $conn = new mysqli('localhost','led','123456','db_cexu');
        if ($conn->connect_error){
            echo '数据库连接失败！';
            exit(0);
        }else{
            if ($username == ''){
                echo '<script>alert("请输入用户名！");history.go(-1);</script>';
                exit(0);
            }
            if ($password == ''){
                echo '<script>alert("请输入密码！");history.go(-1);</script>';
                exit(0);
            }
            $sql = "select id,pwd,name from cexu_data where id = '$username' ";
            $result = $conn->query($sql);
            $number = mysqli_num_rows($result);
    	$row = mysqli_fetch_array($result);
    //	echo $row['name'];
    /*
    		while($row = mysqli_fetch_array($result))
    		{
    			echo "<br/>";
    			echo $row['id'];
    			echo "<br/>";
    			echo $row['pwd'];
    			echo "<br/>";
    			echo $row['name'];
    		}
    */	
    	
            if ($number) {
    			$_SESSION['username'] = $row['name'];
    			echo "<script>window.location.href='index.php'</script>";
            } else {
                echo '<script>alert("用户名或密码错误！");history.go(-1);</script>';
            }
        }
    ?>

主页【**index.php**】

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    
    <?php
    session_start();
    echo $_SESSION['username'];
    echo "<br/>";
    ?>
    <h1>   欢迎来到在线测序网站  </h1>
    
    </body>
    </html>

输出结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70][]

\----------------------------------分割线------------------------------------------------

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70 1][]

参考：

[https://blog.csdn.net/qq\_29656961/article/details/78924085][https_blog.csdn.net_qq_29656961_article_details_78924085]

[https://liu-endong.blog.csdn.net/article/details/90987926][https_liu-endong.blog.csdn.net_article_details_90987926]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70]: /images/20220122/9114b7ade77d4f8fb0b7009fb7becabb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70 1]: /images/20220122/a0a5aa7969524cbb81a07a4865a133c5.png
[https_blog.csdn.net_qq_29656961_article_details_78924085]: https://blog.csdn.net/qq_29656961/article/details/78924085
[https_liu-endong.blog.csdn.net_article_details_90987926]: https://liu-endong.blog.csdn.net/article/details/90987926