欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

php留言本全套分享,记录在博客

程序员文章站 2022-05-24 15:03:14
...
1.admin_login.php
<?php
include("conn.php");
$dbname = "SELECT *from admin ";
$query = mysql_query($dbname); 
$rs=mysql_fetch_array($query);
//   echo $rs['name']; //检测打印出admin表有没有错误
   if (!empty($_POST['sub1'])) {
      $name = $_POST['name'];
      $passwd = $_POST['passwd']; 
      if ($name != $rs['name'] || $passwd != $rs['passwd']) {
        echo '输入错误';
      } else {
        echo "输入正确,马上跳转到管理员后台";
        header("refresh:3,url='admin.php'");
      }
   }
?>
 
<html>
 <head>
   <meta http-equiv="content-type" content="text/html" charset="utf8" />
   <title>管理员登陆</title>
 </head>
 <body>
   <table>
     <form method="post" action="admin_login.php">
        <tr>
          <td>用户名:</td>
          <td><input type="text" name="name" value="" /></td>
        </tr>       
        <tr>
          <td>密码:</td>
          <td><input type="password" name="passwd" value="" /></td>
        </tr>
        <tr>
          <td><input type="submit" name="sub1" value="提交" /></td>
        </tr>
     </form>
   </table>
 </body>
</html>

2.admin.php

<h1>管理员后台</h1>
<?php 
 
   include("conn.php");
   $sql="select * from user";
   $query = mysql_query($sql);
    
   while ($rs = mysql_fetch_array($query)) {
     
 ?>
 <html>
  <head>
    <meta http-equiv="content-type" content="text/html" charset="utf8" />
    <title>管理员后台</title>
  </head>
  <body>
  <hr />
    <table>
      <form method="post" action="index.php">
        <tr>
        <td>用户名:</td>
        <td><?php echo $rs['username']; ?>&nbsp;&nbsp;<a href="edit.php?id=<?php echo $rs['id'] ?>">编辑</a> &nbsp;&nbsp;<a href="del.php?del=<?php echo $rs['id'] ?>">删除</a></td>
        </tr>
        <tr>
        <td>留言时间:</td>
        <td><?php echo $rs['dates']; ?></td>
        </tr>
        <tr>
        <td>邮件:</td>
        <td><?php echo $rs['email']; ?></td>
        </tr>
        <tr>
        <td>内容:</td>
        <td><?php echo $rs['content']; ?></td>
        </tr>
        <tr>
        <td>反馈网址:</td>
        <td><?php echo $rs['refer_url']; ?></td>
        </tr>
      </form>
    </table>
  </body>
 </html>
 <?php 
 }
  
  ?>

3.conn.php

<?php 
   //连接数据库的变量设置
   $db = "bbs"; //数据表
   $local = "localhost"; //mysql 主机,默认 localhost
   $name = "root";//mysql 用户名
   $passwd = "3363064"; //mysql 连接密码
   $conn=mysql_connect($local,$name,$passwd);
   mysql_select_db($db,$conn);  //测试数据库是否成功,在前方加上 $query = ,然后删除下面的注释
  //检测是否连接成功的代码测试
//    if ($query) {
//      echo "连接成功";
//    }else {
//      echo "fail";
//    }
 ?>

4.del.php

<?php 
   include("conn.php");
   if(!empty($_GET['del'])){
   $del = $_GET['del'];
   $sql = "DELETE from `user` where id = '$del'";
   $query = mysql_query($sql);
   if ($query) {
    echo "删除成功!";
     header("refresh:3;url='admin.php'");
   }else {
    echo "删除失败".mysql_error();
   }
}
 ?>

5. edit.php

<?php 
 
  include("conn.php");
  if(!empty($_GET['id'])){ //如果获取的id不是为空
  $sql = "SELECT * FROM user where id =  '".$_GET['id']."'";//数据库语句,选择id
  $query = mysql_query($sql);//执行mysql 语句
  $rs = mysql_fetch_array($query);//读取表中的数组
  }
   
  if (!empty($_POST['sub'])) {
     $username = $_POST['username'];
     $email = $_POST['email'];
     $content = $_POST['content'];
     $refer_url = $_POST['refer_url'];
      
     $mysql = "UPDATE USER SET `username` = '$username',`email` = '$email',`content` = '$content',`refer_url` = '$refer_url'";
     if (mysql_query($mysql)) {
        echo "修改成功!";
        header("refresh:5;url = 'admin.php'");
     }else {
        echo "修改失败";
     }
    }
 ?>
 <html>
  <head>
    <meta http-equiv="content-type" content="text/html" charset="utf8" />
    <title>潮叹潮城网-意见反馈</title>
  </head>
  <body>
    <table>
      <form method="post" action="edit.php">
        <tr>
          <td>用户名:</td>
          <td><input type="text" name="username" value="<?php echo $rs['username'] ;?>" /></td>
        </tr>
        <tr>
          <td>邮箱:</td>
          <td><input type="text" name="email" value="<?php echo $rs['email'] ;?>" />请输入你的邮箱,方便我们及时取得联系</td>
        </tr>
        <tr>
          <td>内容:</td>
          <td><textarea name="content" cols="50" rows="5"><?php echo $rs['content'] ;?></textarea></td>
        </tr>
        <tr>
          <td>反馈网址:</td>
          <td><input type="text" name="refer_url" value="<?php echo $rs['refer_url'] ;?>" /></td>
        </tr>
        <tr>
         <td><input type="submit" name="sub" value="提交" /></td>
        </tr>
      </form>
    </table>
  </body>
 </html>

6.index.php

<?php 
 
   include("conn.php"); //连接数据库文件
    if (!empty($_POST['sub'])) {
      $username = $_POST['username'];
      $email = $_POST['email'];
      $content = $_POST['content'];
      $refer_url = $_POST['refer_url'];
       
      $sql = "insert into `user` (`id`,`username`,`dates`,`email`,`content`,`refer_url`) VALUES (null,'$username',now(),'$email','$content','$refer_url')";
      $query = mysql_query($sql);
         if ($query) {
            echo("潮城君已经收到你的信息啦,我们会加快步伐改进的。谢谢你的建议!<br />");
            echo("<a href='http://imchaotan.com'>5秒后将自动跳转到潮城首页,如果没有跳转你可以直接点击此连接</a>");
            header("refresh:5;url='index.php'");
         }else {
            echo "对不起,潮城君忙碌....能重新再试一遍吗?>_< ".mysql_error();
            header("refresh:5;url='index.php'");
             
         }
    } 
  
 ?>
  
 <html>
  <head>
    <meta http-equiv="content-type" content="text/html" charset="utf8" />
    <title>潮叹潮城网-意见反馈</title>
  </head>
  <body>
    <table>
      <form method="post" action="index.php">
        <tr>
          <td>用户名:</td>
          <td><input type="text" name="username" value="" /></td>
        </tr>
        <tr>
          <td>邮箱:</td>
          <td><input type="text" name="email" value="" />请输入你的邮箱,方便我们及时取得联系</td>
        </tr>
        <tr>
          <td>内容:</td>
          <td><textarea name="content" cols="50" rows="5">说点什么?</textarea></td>
        </tr>
        <tr>
          <td>反馈网址:</td>
          <td><input type="text" name="refer_url" value="" /></td>
        </tr>
        <tr>
         <td><input type="submit" name="sub" value="提交" /></td>
        </tr>
      </form>
    </table>
  </body>
 </html>