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']; ?> <a href="edit.php?id=<?php echo $rs['id'] ?>">编辑</a> <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>