php登录注册和留言

最新推荐文章于 2021-12-12 16:08:49 发布

wolfdream080

最新推荐文章于 2021-12-12 16:08:49 发布

阅读量835

点赞数 3

分类专栏： php 文章标签： php java c++ c语言

本文链接：https://blog.csdn.net/weixin_44885285/article/details/108827213

版权

php 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

登录注册

function.php

<meta charset="uft8">
<?php
	session_start();
	if(!isset($conn)){
		//连接本地数据库od
		$conn = mysqli_connect("127.0.0.1","root","","od") or die("服务器操作失败");

		// 设置编码
		mysqli_query($conn,"set names uft8");
	}


    function login(){
    	global $conn;

	    //获取表单提交过来的值
	    $user_name = $_POST['user'];
	    $password = $_POST['pwd'];

	    $sql = "select * from loginName";
	    $result = mysqli_query($conn,$sql) or die("数据发送失败");

	    $judge = 0;

	    while($row = mysqli_fetch_array($result)){
	        if($user_name == $row['user_name'] && $password == $row['password']){
	        	$_SESSION['userName'] = $row['user_name'];
	        	$judge++;
	        	break;
	        }
	           
	    }

		if($judge == 0){
		   echo "<script>alert('登录失败');window.location.href='login.html';</script>";
		}else{
		   echo "<script>alert('登录成功');window.location.href='index.php';</script>";
		    
		}


	    //关闭连接
	    mysqli_close($conn);
	}

	function register(){
		global $conn;
		//获取表单提交过来的值
		$user_name = $_POST['user'];
		$password = $_POST['pwd1'];


		$sql = "insert into loginName(user_name,password) values('$user_name','$password')";

		if(mysqli_query($conn,$sql)){
			echo "<script>alert('注册成功');window.location.href='login.html';</script>";
		}else{
			echo "<script>alert('注册失败');window.location.href='register.html';</script>";
		}


		//关闭连接
		mysqli_close($conn);
	}

	//状态：是否登录
	function loginSession(){
		if(@$_SESSION['userName'] == ""){
			echo "<script>alert('请先登录');window.location.href='login.php';</script>";
		}
	}

	//退出登录
	function logOut(){
		unset($_SESSION['userName']);
		header("location:login.php");
	}

	//发送留言
	function sendMessage(){
		global $conn;
		//获取表单提交过来的值
		$user_name = $_SESSION['userName'];
		$title = $_POST['title'];
		$content = $_POST['content'];
	

		$sql = "insert into liuYan(user_name,title,content,sendingTime) values('$user_name','$title','$content',now())";
		// echo $sql;
	   if(mysqli_query($conn,$sql)){
		   echo "<script>alert('留言成功');window.location.href='showLiuYan.php';</script>";
	   }else{
		   echo "<script>alert('留言失败');window.location.href='liuyan.php#';</script>";
	   }
	
	
	   //关闭连接
	   mysqli_close($conn);

	}

	//显示全部留言
	function showLiuYan(){
		global $conn;

		$sql = " select * from liuyan";
		$result = mysqli_query($conn,$sql);
		if($row = mysqli_fetch_array($result) == ""){
			echo "<script>alert('留言为发表!');window.location.href='liuyan.php#';</script>";
		}else{
			echo $row;
			while($row){
				echo "sdf";
				echo $row['id'];
				echo "<br>";
				echo $row['user_name'];
				echo "<br>";
				echo $row['title'];
				echo "<br>";
				echo $row['content'];
				echo "<br>";
				echo $row['sendingTime'];
				echo "<br>";
				echo "===========";
			}
		}
		
	}

	//显示留言———————只显示最新发表的那条评论
	function showNewLiuYan(){
		global $conn;

		//查询最新评论返回结果一条
		$sql = " select * from liuyan order by sendingTime desc limit 0,1";
		$result = mysqli_query($conn,$sql);
		$row =mysqli_fetch_array($result);
		if($row == ""){
			echo "<script>alert('留言为发表!');window.location.href='liuyan.php#';</script>";
		}else{
			echo $row['id'];
			echo "<br>";
			echo $row['user_name'];
			echo "<br>";
			echo $row['title'];
			echo "<br>";
			echo $row['content'];
			echo "<br>";
			echo $row['sendingTime'];
			echo "<br>";

			//删除除了最新评论外的数据
			$sql = "delete from liuyan where id !='$row[id]'";
			echo $sql;
			mysqli_query($conn,$sql) or die("删除失败");
		}
		
		
		//关闭连接
		mysqli_close($conn);
	}

	
	  
?>

login.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <link rel="stylesheet" type="text/css" href="css/login.css">
</head>
<body>
    <form action="login.php" method="post"  name="form">
         <div class="from-control"><input type="text" placeholder="用户名"  name="user"></div>
         <div class="from-control"><input type="password" placeholder="输入密码" name="pwd"></div>
         <button type="submit" name="login" class="btn btn-large">登录</button>
         <div name="sd">2222</div>
    </form>

    <script src="js/login.js"></script>
</body>
</html>

login.css

*{margin: 0; padding: 0;}
ul{
    list-style-type: none;
}
a{
    text-decoration: none;
}
div,a{
    color: white;
}


/*表单样式*/
form  label,form .from-control{
    margin-bottom: 19px;
}

form .from-control{
    width: 90%;
}

form .form-control input,form .form-control textarea{
    width: 100%;
    height: 15x;
    padding: 10px;
    outline-color: rgb(49, 49, 214);
}

form label{
    font-size: 20px;
}

.liuyan-title{
    text-align: center;
}



/* 按钮 */
.btn{
    width: 60px;
    height: 30px;
}
.btn:hover{
    cursor: pointer;
    color: white;
    background: rgb(63, 117, 233);
}
.btn-large{
    width: 100px;
    height: 40px;
}

register.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <link rel="stylesheet" type="text/css" href="css/login.css">
</head>
<body>
    <form action="register.php" method="post"  name="form">
         <div class="from-control"><input type="text" placeholder="用户名"  name="user"></div>
         <div class="from-control"><input type="password" placeholder="输入密码" name="pwd1"></div>
         <div class="from-control"><input type="password" placeholder="确认密码" name="pwd2"></div>
         <button type="submit" name="register" class="btn btn-large">注册</button>
    </form>

    <script src="js/login.js"></script>
</body>
</html>

sql文件

#创建数据库od
create database if not exists od default character set utf8;

#打开od
use od;

#创建账户表
create table if not exists loginName(
	id int auto_increment primary key,
    user_name char(20) unique,
    password char(20)
);

#添加测试数据
insert into loginName (user_name,password) values('zjh','zjh123');

#创建留言表
create table if not exists liuYan(
    id int auto_increment primary key,
    user_name char(20),
    title char(30),
    content text,
    sendingTime datetime
);

#添加测试数据
insert into liuYan(user_name,title,content,sendingTime) values('njk','gender','My gender is male',now());
insert into liuYan(user_name,title,content,sendingTime) values('zjh','gender','My gender is female',now());
insert into liuYan(user_name,title,content,sendingTime) values('sh','gender','My gender is male',now());
insert into liuYan(user_name,title,content,sendingTime) values('dyf','gender','My gender is female',now());

liuyan.php

<!DOCTYPE html>
<?php
    require("function.php");
    if(isset($_POST['sendMessage'])){
        sendMessage();
    }else{
        echo "<script>alert('欢迎来到留言板');</script>";
    }
?>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <link rel="stylesheet" type="text/css" href="css/login.css">
</head>
<body>
    <h1 class="liuyan-title">留言板块</h1>
    <form action="liuyan.php" method="post"  name="form" onsubmit="return check()">
            <input type="text" name="" value="">
            <div class="form-control"><input type="text" placeholder="标题"  name="title"></div>
            <div class="form-control"><textarea rows="20" placeholder="留言内容" name="content"></textarea></div>
            <button type="submit" name="sendMessage" class="btn btn-large">发送留言</button>
    </form>
    <script src="js/judge.js"></script>
</body>
</html>

judge.js


//验证注册板块
var registerCheck =function (){
	if(formRegister.user.value == ""){
		alert("注册的用户名不能为空");
		formRegister.user.focus();
		return false;
	}else if(formRegister.pwd.value == ""){
		alert("注册的密码不能为空");
		formRegister.pwd.focus();
		return false;
	}else if(formRegister.pwd.value != formRegister.pwd1.value){
		alert("注册的密码不一致");
		formRegister.pwd1.focus();
		return false;
	}else{
		return true;
	}
}

//验证登录板块
var loginCheck = function(){
	if(formLogin.user.value == ""){
		alert("登录用户名不能为空");
		formLogin.user.focus();
		return false;
	}else if(formLogin.pwd.value == ""){
		alert("登录密码不能为空");
		formLogin.pwd.focus();
		return false;
	}else{
		return true;
	}
}



//验证留言板块
var liuYanCheck = function(){
    if(formLiuYan.title.value == ""){
        alert("标题为空");
        formLiuYan.title.focus();
        return false;
    }else if(formLiuYan.content.value == ""){
        alert("请填写留言内容");
        formLiuYan.content.focus();
        return false;
    }else{
        return true;
    }
}