使用PHP连接数据库实现留言板功能的实例讲解(推荐)

2024-05-04 22:45:27

字体：大中小

来源：转载

供稿：网友

PHP实现留言板功能：

1 首先是登录页面：

<!DOCTYPE html><html> <head>  <meta charset="UTF-8">  <title>留言板登录</title>  <script src="bootstrap/js/jquery-1.11.2.min.js"></script>  <script src="bootstrap/js/bootstrap.min.js"></script>  <link href="bootstrap/css/bootstrap.min.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="stylesheet" type="text/css"/> </head> <style>  .header{   margin-left: 550px;   margin-top: 150px;   height: 300px;   max-width: 300px;  }  .xiugai{   max-width: 200px;  }  .login{   margin-top: 10px;  } </style> <body>  <form action="messloginchuli.php" method="post">  <div class="header">   <h2>开发部内部留言板</h2>   <div class="input-group xiugai">    <span class="input-group-addon" >用户名:</span>    <input type="text" class="form-control" name="uid" placeholder="请输入用户名">   </div>   <div class="input-group xiugai" >    <span class="input-group-addon">口令：</span>    <input type="text" class="form-control" name="pwd" placeholder="请输入口令">   </div>   <button type="submit" class="btn btn-success login">登录</button>  </div> </form> </body></html>

2 登录页面完成后要进入登录处理页面了，也就是上面提交到的messloginchuli.php

<?phpsession_start();　　// 登录之后要把所包含登录的页面连接起来，开启session$uid = $_POST["uid"];$pwd = $_POST["pwd"];require_once "./DBDA.class.php";$db = new DBDA();$sql = "select password from yuangong where username='{$uid}'";$arr = $db->query($sql,0);//var_dump($arr[0][0]);if($arr[0][0]=$pwd && !empty($pwd)){ $_SESSION["uid"]=$uid; header("location:message.php");}?>

登录页面效果如图：

3.登录完成后是进入主页面，也就是显示自己收到的对话内容，下面是设计的数据库的表格和主页面的代码：

<!DOCTYPE html><html> <head>  <meta charset="UTF-8">  <title></title>  <script src="bootstrap/js/jquery-1.11.2.min.js"></script>  <script src="bootstrap/js/bootstrap.min.js"></script>  <link href="bootstrap/css/bootstrap.min.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="stylesheet" type="text/css"/> </head> <style>  .mess{   max-width: 800px;   margin-left: 250px;   margin-top: 150px;  } </style> <body>  <?php  session_start();  $uid = $_SESSION["uid"];  if(empty($_SESSION["uid"])){   header("location:messlogin.php");   exit;  }  ?>  <div >   <a href="publish_info.php" rel="external nofollow" >发布信息</a>   <a href="tuichuchuli.php" rel="external nofollow" >退出系统</a>   </div>  <table class="table table-bordered mess" >   <caption >    留言信息：   </caption>      <thead>    <tr>     <th>发送人</th>     <th>发送时间</th>     <th>接收人</th>     <th>信息内容</th>    </tr>   </thead>   <tbody>    <?php    require_once "./DBDA.class.php";    $db = new DBDA();    $sql = "select * from liuyan where recever='{$uid}' or recever='all'";    $arr = $db->query($sql,0);    foreach($arr as $v){     echo "<tr>     <td>{$v[1]}</td>     <td>{$v[2]}</td>     <td>{$v[3]}</td>     <td>{$v[4]}</td>    </tr>";    }    ?>       </tbody>  </table> </body></html>

上一篇：php生成条形码的图片的实例详解

下一篇：ThinkPHP开发--使用七牛云储存