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'");
}
}
?>
<meta>
<title>管理员登陆</title>
2.admin.php
<h1>管理员后台</h1>
<?php
include("conn.php");
$sql="select * from user";
$query = mysql_query($sql);
while ($rs = mysql_fetch_array($query)) {
?>
<meta>
<title>管理员后台</title>
<hr>
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 "修改失败";
}
}
?>
<meta>
<title>潮叹潮城网-意见反馈</title>
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>5秒后将自动跳转到潮城首页,如果没有跳转你可以直接点击此连接</a>");
header("refresh:5;url='index.php'");
}else {
echo "对不起,潮城君忙碌....能重新再试一遍吗?>_
<meta>
<title>潮叹潮城网-意见反馈</title>
php免费学习视频:立即使用
踏上前端学习之旅,开启通往精通之路!从前端基础到项目实战,循序渐进,一步一个脚印,迈向巅峰!










