PHP+MYSQL实现个人博客网站 PHP动态网页设计

效果展示：

开发环境：

网站前台：html+div+css+js

动态技术：PHP+MYSQL

开发环境：PHPSTUDY（兼容XAMPP，WAMP，APPSERV，Laragon）等，了解区别

数据表：5张，`admin``article``conf``guest``note`

功能列表：

前台功能：

首页,我的日记,我的相册,留言版,注册,登录

后台功能：

日志管理 日志列表、日志增加、相册管理、相册列表、相册上传、留言营理、留言列表、系统设置、网站设置、退出登录

数据库连接：

<?phpglobal $conn;$host = "127.0.0.1";$username = "root";$password = "root";$database = "";$conn = mysqli_connect($host, $username, $password, $database);mysqli_query($conn, "set names utf8");error_reporting(0);session_start();// 作业窝 网页设计源码下载

注册：

<?php include 'includes/conn.php';if ($_POST){include 'includes/basic.func.php';$_clean = array();$_clean['username'] = _check_username($_POST['username'],2,20);$_clean['password'] = _check_password($_POST['password'],$_POST['repassword'],6);$query = mysqli_query($conn,"select username from guest where username = '{$_clean['username']}'");if(mysqli_fetch_array($query,MYSQLI_ASSOC)){_alert_back('此用户已经被注册');die;};$add = mysqli_query($conn,"insert into guest (username,password,email,qq,date) values ('{$_POST['username']}','{$_POST['password']}','{$_POST['email']}','{$_POST['qq']}',now())");if($add){_alert_location('恭喜你，注册成功','index.php');}};

登录：

<?phpob_start();include 'includes/conn.php';if ($_POST['type'] == '0') {$query = mysqli_query($conn, "select * from guest where username='{$_POST['username']}' && password='{$_POST['password']}'");$rows = mysqli_fetch_array($query, MYSQLI_ASSOC);if (!$rows) {echo "<script type='text/javascript'>alert('对不起，您输入的帐号或者密码有误!');history.back();</script>";} else {$_SESSION['username'] = $_POST['username'];$_SESSION['uid'] = $rows['id'];echo "<script type='text/javascript'>alert('登录成功');window.location.href='index.php';</script>";}}if ($_POST['type'] == '1') {$query = mysqli_query($conn, "select * from admin where username='{$_POST['username']}' && password='{$_POST['password']}'");$rows = mysqli_fetch_array($query, MYSQLI_ASSOC);if (!$rows) {echo "<script type='text/javascript'>alert('对不起，您输入的帐号或者密码有误 !');history.back();</script>";} else {$_SESSION['username'] = $_POST['username'];echo "<script type='text/javascript'>alert('登录成功');window.location.href='admin/mannote.php';</script>";}}

数据库：

-- 数据库： `db`---- ------------------------------------------------------------ 表的结构 `admin`--CREATE TABLE `admin` (`id` mediumint(3) NOT NULL,`username` varchar(40) NOT NULL,`password` varchar(40) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;---- 转存表中的数据 `admin`--INSERT INTO `admin` (`id`, `username`, `password`) VALUES(1, 'admin', 'admin');-- ------------------------------------------------------------ 表的结构 `article`--CREATE TABLE `article` (`id` mediumint(3) NOT NULL,`title` varchar(40) NOT NULL,`content` text NOT NULL,`catid` int(11) NOT NULL,`img` varchar(40) NOT NULL,`date` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;---- 表的结构 `conf`--CREATE TABLE `conf` (`id` mediumint(3) NOT NULL,`key_name` varchar(40) NOT NULL,`txt` text NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;-- ------------------------------------------------------------ 表的结构 `guest`--CREATE TABLE `guest` (`id` mediumint(6) UNSIGNED NOT NULL,`username` varchar(20) NOT NULL,`password` varchar(40) NOT NULL,`email` varchar(40) NOT NULL DEFAULT '',`qq` char(20) DEFAULT NULL,`date` datetime NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC;-- ------------------------------------------------------------ 表的结构 `note`--CREATE TABLE `note` (`id` mediumint(3) NOT NULL,`title` varchar(40) NOT NULL,`about` text NOT NULL,`uid` int(10) NOT NULL,`pid` int(10) NOT NULL,`date` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;---- 转存表中的数据 `note`---- ------------------------------------------------------------ 表的结构 `xiangce`--CREATE TABLE `xiangce` (`id` mediumint(3) NOT NULL,`title` varchar(40) NOT NULL,`img` varchar(40) NOT NULL,`date` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;---- 转存表中的数据 `xiangce`--INSERT INTO `xiangce` (`id`, `title`, `img`, `date`) VALUES(2, '日历', '16151811377.png', '-12-09'),(3, '镜子里的自己', '16151825853.png', '-12-09'),(4, '锤炼自我', '16151845276.png', '-12-09');---- 转储表的索引------ 表的索引 `admin`--ALTER TABLE `admin`ADD PRIMARY KEY (`id`) USING BTREE;---- 表的索引 `article`--ALTER TABLE `article`ADD PRIMARY KEY (`id`) USING BTREE;---- 表的索引 `conf`--ALTER TABLE `conf`ADD PRIMARY KEY (`id`) USING BTREE;---- 表的索引 `guest`--ALTER TABLE `guest`ADD PRIMARY KEY (`id`) USING BTREE;---- 表的索引 `note`--ALTER TABLE `note`ADD PRIMARY KEY (`id`) USING BTREE;---- 表的索引 `xiangce`--ALTER TABLE `xiangce`ADD PRIMARY KEY (`id`) USING BTREE;---- 在导出的表使用AUTO_INCREMENT------ 使用表AUTO_INCREMENT `admin`--ALTER TABLE `admin`MODIFY `id` mediumint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;---- 使用表AUTO_INCREMENT `article`--ALTER TABLE `article`MODIFY `id` mediumint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;---- 使用表AUTO_INCREMENT `conf`--ALTER TABLE `conf`MODIFY `id` mediumint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;---- 使用表AUTO_INCREMENT `guest`--ALTER TABLE `guest`MODIFY `id` mediumint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;---- 使用表AUTO_INCREMENT `note`--ALTER TABLE `note`MODIFY `id` mediumint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;---- 使用表AUTO_INCREMENT `xiangce`--ALTER TABLE `xiangce`MODIFY `id` mediumint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;COMMIT;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

作者建议：

适合PHP动态网页设计期末作业作业，专科院校简单的PHP网站毕业设计，适合要求带注册，登录，后台管理，留言，增删改查的大学网页期末课程

源代码下载：

/goods-87.html

*注意：仅供学习参考，转载请注明出处。感谢支持。