php留言系统

连接数据库,connet.php:

<meta charset="utf-8">
<?php
$conn=mysqli_connect("localhost","root","123456","ly")or die("连接数据库服务器失败!".mysqli_error());
mysqli_query($conn,"set names utf8");
?>

登录页面Login.php:

<html>
<head>
<title>登录</title>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="./css/index1.css">
<style>
body{height:100%;}
</style>
</head>
<body style="background: url(./images/1.png);">
<div class="index_01"> 
<table style="width: 100%;height:100%;" >
  <tr>
    <td align="center" >
      <table align="center" width=350 height=230; class="index_table" >  
       <form method ="POST" action = "doloading.php" name="frmLogin"> 
     <tr align="center" style="font-size:25px;"> 
           <td colspan="2" style="font-size:35px;">用户登录</td>
     </tr>
       <tr>  
           <td align="center" style="font-size:25px;">用户名</td>  
           <td><input type="name" maxlength="16" name="uid" placeholder="请输入账号" style="width:180px;font-size:20px;border-radius: 8px; "></td>  
       </tr>  
       <tr>  
           <td align="center" style="font-size:25px;">密   码</td>  
           <td><input name="password" type="password" maxlength="16" placeholder="请输入密码" style="width:180px;font-size:20px;border-radius: 8px; "></td>
       </tr>
       <tr align="center"> 
           <td colspan="2">
           <input type="submit" name="denglu" value="登录" class="btn">
           <input type="reset" name="rs" value="重置" class="btn">  
         
           </td>  
       </tr> 
     </form>
     </table>
    </td>
  </tr>
</table> 
</div>
</body>
</html> 

登录处理,doloading.php

<meta charset="utf-8">
<?php
session_start();
$uid=$_POST['uid'];
$pwd=$_POST['password'];
if($uid==""||$pwd=="")
{
	 echo "<script>alert('用户名或密码为空,请重新登录');location='Login.php';</script>";
}else{
	include_once("connet.php");
	$sql="select * from user where uid='$uid' and upwd='$pwd' ";
	$result=mysqli_query($conn,$sql);
    $num=mysqli_num_rows($result);
    if($num!=0){
    	echo "<script>alert('登录成功');location='show.php';</script>";
    	$_SESSION['user']['islogin']=true;
    }else
    {
    	echo "<script>alert('登录失败');location='Login.php';</script>";
    }
	
	 
	
}
?>

 

 

注册页面,regist.php

<html>
<head>
<title>注册</title>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="./css/index1.css">
<style>
body{height:100%;}
</style>
</head>
<body style="background: url(./images/1.png)">
<div class="index_01" > 
<table style="width: 100%;height:100%;" >
  <tr>
    <td align="center" >
      <form action="doregister.php " name="dl" method="post">
      <table  align="center" width=350 height=230; style="font-family:宋体;font-size:25px;">
      <tr align="center"> 
          <td colspan="2" style="font-size:35px;">注册用户</td>
      </tr>
      <tr>
          <td align="center">用户名</td>
          <td>
          <input type="name" maxlength="20" name="id" placeholder="手机号/邮箱" style="width:180px;font-size:20px;border-radius: 8px; ">
          </td>
      </tr>
      <tr>
          <td align="center">密   码</td>
          <td >
          <input name="password" type="password" maxlength="16" placeholder="请输入密码" style="width:180px;font-size:20px;border-radius: 8px; ">
      </td>
      </tr>
      <tr>
          <td align="center">再次输入密码</td>
          <td>
          <input name="confirmPassword" type="password" maxlength="16" placeholder="请再次输入密码" style="width:180px;font-size:20px;border-radius: 8px; ">
          </td>
      </tr>
      <tr>
        <td colspan="2" align="center">
          <input type="submit" name="zu" value="注册" style="font-size:17px;border-radius:12px;" class="btn"/>
        <input type="reset" name="zu" value="重置" style="font-size:17px;border-radius: 12px;" class="btn"> 
        
        </td>
      </tr>
   </table>
   </form>
    </td>
  </tr>
</table>
</div>
</body>
<html>

注册处理,doregist.php,往数据库添加数据

<meta charset="utf-8">
<?php
$uid=$_POST['id'];
$pwd=$_POST['password'];
$confpwd=$_POST['confirmPassword'];
//判断密码是否一致
if($pwd!=$confpwd)
{
  echo "<script>alert('密码不匹配,请重新输入');location='register.php';</script>";
}
//连接数据库进行查询
  include_once("connet.php");
  $sql1="select * from user ";
  $res=mysqli_query($conn,$sql1);
  //判断账户密码是否为空
  if($uid!=null&&$pwd!=null)
  {
    while($myrow=mysqli_fetch_object($res))
    {
      //判断账户是否与数据库中已有的账户一致
      if($uid!=$myrow->uid){
        $sql2="insert into user values('".$uid."','".$pwd."')";
        $res1=mysqli_query($conn,$sql2);
        if($res1){
           echo "<script>alert('注册成功');location='Login.php';</script>";
        }
      }else{
        echo "<script>alert('注册失败,该账号已被注册');location='register.php';</script>";
      }
    }
  }else{
    echo "<script>alert('注册失败,请输入账号和密码');location='register.php';</script>";
  }
?>
 

主页面,show.php:

    <?php
    header('Content-type: text/html; charset=UTF8');
    ?>
	<html>  
    <head>  
    <title>我的留言板.查看留言</title> 
	<link rel="stylesheet" type="text/css" href="./css/index1.css">
    <link rel="stylesheet" type="text/css" href="./css/index2.css">
    </head>  
    <body background="./images/7.jpg" style="background-size:cover;background-attachment: fixed;" >  

   
    <center>  
     <h2>我的留言板</h2>  
    <input type = "button" value = "添加留言" onclick="location.href='authority.php'" class="button"/>
    <input type = "button" value = "查看留言" onclick="location.href='select.php'" class="button"/>
	<input type = "button" value = "登&nbsp;&nbsp;&nbsp;&nbsp;录" onclick="location.href='Login.php';" class="button"/>
    <input type = "button" value = "注&nbsp;&nbsp;&nbsp;&nbsp;册" onclick="location.href='register.php';" class="button"/>
    <hr width = "70%"> 
	</center>
<?php
    include_once("connet.php");
    mysqli_query($conn,'set names utf8');
    $str = "select * from tbliuyan";
    $result = mysqli_query($conn,$str);
    while($myrow = mysqli_fetch_row($result)){
?>
    <div style="color:blue;border: 1px solid black;width: 700px;margin: 0 auto;height: 100px;">   
        <div style="width: 80px;float: left;" ><img src="http://q1.qlogo.cn/g?b=qq&nk=<?php echo $myrow[4];?>&s=640" style="width: 80px;height: 80px;margin-top: 10px;">
        </div>
        <div style="width: 620px;margin-left: 120px;margin-top:15px;color: black;" >
             <span style="margin-top:60px;">名称:<?php echo $myrow[1];?></span><br>
             <span>ID:<?php echo $myrow[0];?></span><br>   
            <span>标题:<?php echo $myrow[2];?></span><br>     
            <span>内容:<?php echo $myrow[3];?></span>
        </div>
    </div>
    
    
<?php
}
?>
     <span class="STYLE2"style="margin-left: 1100px;"><?php
          $rows = mysqli_num_rows($result);
          echo "查询结果为:".$rows.'条记录';
        ?><a href="add.php">:继续添加</a></span>
    



    </body>  
    </html> 

 

 

添加一个权限,authority.php:

  <meta charset="utf-8">
   <?php
    session_start();
if (isset($_SESSION['user']['islogin'])&&$_SESSION['user']['islogin']==true) {
     echo"<script>alert('欢迎访问该页面'); location='add.php';</script>";
}else{
    echo"<script>alert('对不起,您无权访问,返回首页');location='show.php';</script>";
} 

添加页面,add.php

<?php
    header('Content-type: text/html; charset=UTF8');
    ?>
    <html>  
    <head>
    <link rel="stylesheet" type="text/css" href="./css/index1.css">
    <title>我的留言板.添加留言</title>  
    </head>  
    <body background="./images/7.jpg" style="background-size:cover;" >  
    <center>  
    <h2>我的留言板</h2> 
    <input type = "button" value = "修改留言" onclick="location.href='update.php'" class="button"/>
    <input type = "button" value = "删除留言" onclick="location.href='del.php'" class="button"/>
    <input type = "button" value = "退出登录" onclick="location.href='logout.php'" class="button"/>
    <hr width = "70%"> 
    </center>
    <div class="k1">
    <form action = "doAdd.php" method = "post">  
    <h1>添加留言
    </h1>
    <label>
    <span>用户名称:</span>
    <input type="text" name="author" />
    </label>
    <label>
    <span>主题:</span>
    <input type="text" name="title"/>
    </label>
    <label>
    <span>内容 :</span>
    <textarea name="content"></textarea>
    </label>
    <label>
    <span>QQ:</span>
    <input type="text" name="qq"/>
    </label>
    <div style="margin-left:125px">
    <input type="submit" value="提交留言" class="submit">
    <input type = "reset" value = "重置" class="reset">
    </div>
    </div>
    </form>
    </body>  
    </html>  
 

添加处理,doAdd.php:

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>添加留言</title>
</head>
<body>
	<?php
	session_start();
	 include_once("connet.php");
	  if (isset($_POST['author'],$_POST['title'],$_POST['content'],$_POST['qq'])) {
	  	if ( !($_POST['author']&&$_POST['title']&&$_POST['content']&&$_POST['qq'])) {
	  	echo "输入数据不允许为空,单击<a href='javascript:onclick=history.go(-1)'>这里</a>返回";
		  }else{
		  	$str="insert into tbliuyan values(NULL,'".$_POST['author']."','".$_POST['title']."','".$_POST['content']."','".$_POST['qq']."')";
		  	$result=mysqli_query($conn, $str);
		  	if($result){
		  		echo "留言添加添加成功,点击<a href='show.php'>查看</a>";
		  	}else{
		  		echo "<script>alert('添加失败');history.go(-1);</script>";
		  	}
		  }
	  }else{
	  	echo "<script>alert('添加失败');history.go(-1);</script>";
	  }
	?>
</body>
</html>

 

 

更新页面。update.php:

<?php
    header('Content-type: text/html; charset=UTF8');
    ?>
    <html>  
    <head>
    <link rel="stylesheet" type="text/css" href="./css/index1.css">
    <title>我的留言板.添加留言</title>  
    </head>  
    <body background="./images/7.jpg" style="background-size:cover;" >  
    <center>  
    <h2>我的留言板</h2> 
    <input type = "button" value = "查看留言" onclick="location.href='show.php'" class="button"/>
    <input type = "button" value = "退出登陆" onclick="location.href='index.php'" class="button"/>
    <hr width = "70%"> 
    </center>
    <div class="k1">
    <form action = "doupdate.php" method = "post">  
    <h1>更改信息
    <span>根据qq号更改信息</span>
    </h1>
    <label>
    <span>用户名称:</span>
    <input type="text" name="author" />
    </label>
    <label>
    <span>主题:</span>
    <input type="text" name="title"  />
    </label>
    <label>
    <span>内容 :</span>
    <textarea name="content" ></textarea>
    </label>
    <label>
    <span>ID:</span>
    <input type="text" name="tid" />
    </label>
    <div style="margin-left:125px">
    <input type="submit" value="修改留言" class="submit">
    <input type = "reset" value = "重置" class="reset">
    </div>
    </div>
    </form>
    </body>  
    </html>  

更新处理,doupdate.php:

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>修改留言</title>
</head>
<body>
<?php
	 include_once("connet.php");
	  if (!($_POST['author']&&$_POST['title']&&$_POST['content']&&$_POST['tid'])) {
	  	echo "输入数据不允许为空,单击<a href='javascript:onclick=history.go(-1)'>这里</a>返回";
	  }else{
	  	
	  	$str="update tbliuyan set username='".$_POST['author']."',title='".$_POST['title']."',message='".$_POST['content']."' where id=".$_POST['tid'];
	  	$result=mysqli_query($conn, $str);
	  	if($result){
	  		echo "留言更新添加成功,点击<a href='show.php'>查看</a>";
	  	}else{
	  		echo "<script>alert('更新失败');history.go(-1);</script>";
	  	}
	  }
	?>
</body>
</html>

 

 

删除页面,del.php

<?php
    header('Content-type: text/html; charset=UTF8');
    ?>
    <html>  
    <head>
    <link rel="stylesheet" type="text/css" href="./css/index1.css">
    <title>我的留言板.查询留言</title>  
    </head>  
    <body background="./images/7.jpg" style="background-size:cover;" >  
    <center>  
    <h2>我的留言板</h2> 
    <input type = "button" value = "修改留言" onclick="location.href='update.php'" class="button"/>
    <input type = "button" value = "查看留言" onclick="location.href='show.php'" class="button"/>
    <input type = "button" value = "退出登录" onclick="location.href='index.php'" class="button"/>
    <hr width = "70%"> 
    </center>
    <div class="k1">
    <form action = "dodel.php" method = "post">  
    <h1>删除留言
        <span>根据ID删除留言</span>
    </h1>
    <label>
    <span>ID:</span>
    <input type="text" name="id"/>
    </label>
    <div style="margin-left:125px">
    <input type="submit" value="删除留言" class="submit">
    <input type = "reset" value = "重置" class="reset">
    </div>
    </form>
       
    </div>
    </body>  
    </html>  

删除处理,dodel.php:

<meta charset="utf-8">
<?php
include_once("connet.php");
	$id = $_POST['id'];
if(isset($_POST['id']))
{
  if($_POST['id'])
  {
     $sql="delete from tbliuyan where id ='".$_POST['id']."' ";
     $res=mysqli_query($conn,$sql);
  	 if($res){
  		       echo "<script>alert('删除成功,返回首页');location='show.php';</script>";
  		}
      else{
  		   echo "<script>alert('删除失败');location='show.php'</script>";
      }
  }
  else
  {
    echo "<script>alert('数据为空,不能允许删除');location='del.php';</script>";
  }
}
?>

 

 

查找页面.select.php:

<?php
    header('Content-type: text/html; charset=UTF8');
    ?>
    <html>  
    <head>
    <link rel="stylesheet" type="text/css" href="./css/index1.css">
    <title>我的留言板.查询留言</title>  
    </head>  
    <body background="./images/7.jpg" style="background-size:cover;" >  
    <center>  
    <h2>我的留言板</h2> 
    <input type = "button" value = "返回首页" onclick="location.href='show.php'" class="button"/>
    <input type = "button" value = "退出登录" onclick="location.href='logout.php'" class="button"/>
    <hr width = "70%"> 
    </center>
    <div class="k1">
    <form action = "doselect.php" method = "post">  
    <h1>查看留言
        <span>根据qq号查看留言</span>
    </h1>
    <label>
    <span>QQ:</span>
    <input type="text" name="qq"/>
    </label>
    <div style="margin-left:125px">
    <input type="submit" value="查看留言" class="submit">
    <input type = "reset" value = "重置" class="reset">
    </div>
    </form>
       
    </div>
    </body>  
    </html>  

查找处理,doselect.php:

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>Document</title>
</head>
<body>
<?php
    if (isset($_POST['qq'])) {
    include_once("connet.php");
    mysqli_query($conn,'set names utf8');
    $str = "select * from tbliuyan where qq=".$_POST['qq'];
    $result = mysqli_query($conn,$str);
    while($myrow = mysqli_fetch_row($result)){
?>
	<div style="color:blue;border: 1px solid black;width: 700px;margin: 0 auto;height: 100px;">   
        <div style="width: 80px;float: left;" ><img src="http://q1.qlogo.cn/g?b=qq&nk=<?php echo $myrow[4];?>&s=640" style="width: 80px;height: 80px;margin-top: 10px;">
        </div>
        <div style="width: 620px;margin-left: 120px;margin-top:15px;color: black;" > 
            <span style="margin-	top:60px;">名称:<?php echo $myrow[1];?></span><br>
            <span>ID:<?php echo $myrow[0];?></span><br> 
            <span>标题:<?php echo $myrow[2];?></span><br>     
            <span>内容:<?php echo $myrow[3];?></span>
        </div>
    </div>
<?php 
}
}
?>
</body>
</html>

创建注销登录,logout.php:

<meta charset="utf-8">
<?php
session_start();
$_SESSION=array();
setcookie(session_name(),null,time()-1,'/');
echo"<script>alert('退出成功');location='show.php';</script>";
session_destroy();

 

  • 24
    点赞
  • 131
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 4
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

喵俺第一专栏

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值