首页 >php教程 >PHP源码 >php留言本全套分享,记录在博客

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

PHP中文网
PHP中文网原创
2016-05-25 17:00:22990浏览

1.admin_login.php

<?php
include("conn.php");
$dbname = "SELECT *from admin ";
$query = mysql_query($dbname); 
$rs=mysql_fetch_array($query);
//   echo $rs[&#39;name&#39;]; //检测打印出admin表有没有错误
   if (!empty($_POST[&#39;sub1&#39;])) {
      $name = $_POST[&#39;name&#39;];
      $passwd = $_POST[&#39;passwd&#39;]; 
      if ($name != $rs[&#39;name&#39;] || $passwd != $rs[&#39;passwd&#39;]) {
        echo &#39;输入错误&#39;;
      } else {
        echo "输入正确,马上跳转到管理员后台";
        header("refresh:3,url=&#39;admin.php&#39;");
      }
   }
?>
 
<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[&#39;username&#39;]; ?>  <a href="edit.php?id=<?php echo $rs[&#39;id&#39;] ?>">编辑</a>   <a href="del.php?del=<?php echo $rs[&#39;id&#39;] ?>">删除</a></td>
        </tr>
        <tr>
        <td>留言时间:</td>
        <td><?php echo $rs[&#39;dates&#39;]; ?></td>
        </tr>
        <tr>
        <td>邮件:</td>
        <td><?php echo $rs[&#39;email&#39;]; ?></td>
        </tr>
        <tr>
        <td>内容:</td>
        <td><?php echo $rs[&#39;content&#39;]; ?></td>
        </tr>
        <tr>
        <td>反馈网址:</td>
        <td><?php echo $rs[&#39;refer_url&#39;]; ?></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[&#39;del&#39;])){
   $del = $_GET[&#39;del&#39;];
   $sql = "DELETE from `user` where id = &#39;$del&#39;";
   $query = mysql_query($sql);
   if ($query) {
    echo "删除成功!";
     header("refresh:3;url=&#39;admin.php&#39;");
   }else {
    echo "删除失败".mysql_error();
   }
}
 ?>

5. edit.php

<?php 
 
  include("conn.php");
  if(!empty($_GET[&#39;id&#39;])){ //如果获取的id不是为空
  $sql = "SELECT * FROM user where id =  &#39;".$_GET[&#39;id&#39;]."&#39;";//数据库语句,选择id
  $query = mysql_query($sql);//执行mysql 语句
  $rs = mysql_fetch_array($query);//读取表中的数组
  }
   
  if (!empty($_POST[&#39;sub&#39;])) {
     $username = $_POST[&#39;username&#39;];
     $email = $_POST[&#39;email&#39;];
     $content = $_POST[&#39;content&#39;];
     $refer_url = $_POST[&#39;refer_url&#39;];
      
     $mysql = "UPDATE USER SET `username` = &#39;$username&#39;,`email` = &#39;$email&#39;,`content` = &#39;$content&#39;,`refer_url` = &#39;$refer_url&#39;";
     if (mysql_query($mysql)) {
        echo "修改成功!";
        header("refresh:5;url = &#39;admin.php&#39;");
     }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[&#39;username&#39;] ;?>" /></td>
        </tr>
        <tr>
          <td>邮箱:</td>
          <td><input type="text" name="email" value="<?php echo $rs[&#39;email&#39;] ;?>" />请输入你的邮箱,方便我们及时取得联系</td>
        </tr>
        <tr>
          <td>内容:</td>
          <td><textarea name="content" cols="50" rows="5"><?php echo $rs[&#39;content&#39;] ;?></textarea></td>
        </tr>
        <tr>
          <td>反馈网址:</td>
          <td><input type="text" name="refer_url" value="<?php echo $rs[&#39;refer_url&#39;] ;?>" /></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[&#39;sub&#39;])) {
      $username = $_POST[&#39;username&#39;];
      $email = $_POST[&#39;email&#39;];
      $content = $_POST[&#39;content&#39;];
      $refer_url = $_POST[&#39;refer_url&#39;];
       
      $sql = "insert into `user` (`id`,`username`,`dates`,`email`,`content`,`refer_url`) VALUES (null,&#39;$username&#39;,now(),&#39;$email&#39;,&#39;$content&#39;,&#39;$refer_url&#39;)";
      $query = mysql_query($sql);
         if ($query) {
            echo("潮城君已经收到你的信息啦,我们会加快步伐改进的。谢谢你的建议!<br />");
            echo("<a href=&#39;http://imchaotan.com&#39;>5秒后将自动跳转到潮城首页,如果没有跳转你可以直接点击此连接</a>");
            header("refresh:5;url=&#39;index.php&#39;");
         }else {
            echo "对不起,潮城君忙碌....能重新再试一遍吗?>_< ".mysql_error();
            header("refresh:5;url=&#39;index.php&#39;");
             
         }
    } 
  
 ?>
  
 <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>
声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn