php留言本全套分享，记录在博客
- PHP中文网Original
- 2016-05-25 17:00:22991Durchsuche
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>Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：php下载excel文件，文件无法打开错误Nächster Artikel：php截取中文字符