一个基于php的旅游博客.zip

# Trvel-Well ## day01 ### 01-配置数据 ````php <?php /** * 数据库主机 */ define('DB_HOST', '127.0.0.1'); /** * 数据库用户名 */ define('DB_USER', 'root'); /** * 数据库密码 */ define('DB_PASS', 'root'); /** * 数据库名称 */ define('DB_NAME', 'db_baixiu'); ?> ```` ### 02-封装数据库连接 functions.php ````php <?php include_once 'config.php'; //连接数据库 //1 连接 function connect(){ $conn = mysqli_connect(DB_HOST,DB_USER,DB_PASS,DB_NAME); if(!$conn){ die('连接失败'); } return $conn; } //查询 function query($conn,$sql){ $res=mysqli_query($conn,$sql); return fetch($res); } //遍历获取数据 function fetch($res){ while ($row = mysqli_fetch_assoc($res)) { $arr[]=$row; } return $arr; } ?> ```` ### 03-动态生成导航 #### 3.1在index.php引入 functions.php ````php <?php include_once 'functions.php';?> ```` #### 3.2 在_header.php 查询数据 并渲染模板 ````php <?php //连接 $conn=connect(); $sql="SELECT * from categories WHERE id !=1"; //执行sql语句 $postArr= query($conn,$sql); //print_r($postArr); ?> ```` ````php <ul class="nav"> <?php foreach ($postArr as $key => $value) { ?> <li><a href="javascript:;"><i class="fa <?php echo $value['classname'] ?>"></i><?php echo $value['name'] ?></a></li> <?php } ?> <!-- <li><a href="javascript:;"><i class="fa fa-glass"></i>奇趣事</a></li> <li><a href="javascript:;"><i class="fa fa-phone"></i>潮科技</a></li> <li><a href="javascript:;"><i class="fa fa-fire"></i>会生活</a></li> <li><a href="javascript:;"><i class="fa fa-gift"></i>美奇迹</a></li> --> </ul> ```` ### 04-最新发布 #### 4.1. 在index.php实现发布 ````php <?php include_once 'functions.php'; //读取数据 //1 连接数据库 $conn = connect(); //准备sql g $sql="SELECT p.title,p.created,p.content,p.views,p.likes,p.feature,c.`name`,u.nickname, # 根据文章id到comments表格中查找对应的评论数量 (SELECT count(id) FROM comments WHERE post_id = p.id) as commentsCount FROM posts p # 联表查询 LEFT JOIN categories c on c.id = p.category_id LEFT JOIN users u on u.id = p.user_id # 筛选一下不展示的分类 WHERE p.category_id != 1 # 倒序排列 order BY p.created desc # 限定数量 LIMIT 5"; //执行sql $newsArr =query($conn,$sql); ?> ```` #### 4.2 模板渲染 ````php+HTML <h3>最新发布</h3> <?php foreach ($newsArr as $key => $value) { ?> <div class="entry"> <div class="head"> <span class="sort"><?php echo $value['name']; ?></span> <a href="javascript:;"><?php echo $value['title'];?></a> </div> <div class="main"> <p class="info"><?php echo $value['nickname'] ; ?> 发表于 <?php echo $value['created'] ; ?></p> <p class="brief"><?php echo $value['content'] ; ?></p> <p class="extra"> <span class="reading">阅读(<?php echo $value['views'] ; ?>)</span> <span class="comment">评论(<?php echo $value['commentsCount'] ; ?>)</span> <a href="javascript:;" class="like"> <i class="fa fa-thumbs-up"></i> <span>赞(<?php echo $value['likes'] ; ?>)</span> </a> <a href="javascript:;" class="tags"> 分类：<span><?php echo $value['name'] ; ?></span> </a> </p> <a href="javascript:;" class="thumb"> <img src="static/uploads/hots_2.jpg" alt=""> </a> </div> </div> <?php } ?> </div> </div> ```` ## day02 ### 01-动态跳转界面 #### 1.1在_header.php设置href连接 ````php <ul class="nav"> <?php foreach ($postArr as $key => $value) { ?> <li><a href="list.php?categoryId=<?php echo $value['id'] ?>"><i class="fa <?php echo $value['classname'] ?>"></i><?php echo $value['name'] ?></a></li> <?php } ?> </ul> ```` #### 1.2 在list.php获取数据 并渲染模板 ````php <?php include_once 'functions.php'; $categoryId =$_GET['categoryId']; $conn = connect(); $sql="SELECT p.title,p.created,p.content,p.views,p.likes,p.feature,c.`name`,u.nickname, # 根据文章id到comments表格中查找对应的评论数量 (SELECT count(id) FROM comments WHERE post_id = p.id) as commentsCount FROM posts p # 联表查询 LEFT JOIN categories c on c.id = p.category_id LEFT JOIN users u on u.id = p.user_id # 筛选一下展示的分类 WHERE p.category_id = {$categoryId} # 限定数量 LIMIT 10"; $listArr = query($conn,$sql); //print_r($listArr); ?> ```` #### 1.3 渲染模板 ````php+HTML <div class="content"> <div class="panel new"> <h3><?php echo $listArr[0]['name'] ?></h3> <?php foreach ($listArr as $key => $value) { ?> <div class="entry"> <div class="head"> <span class="sort"><?php echo $value['name']; ?></span> <a href="javascript:;"><?php echo $value['title'];?></a> </div> <div class="main"> <p class="info"><?php echo $value['nickname'] ; ?> 发表于 <?php echo $value['created'] ; ?></p> <p class="brief"><?php echo $value['content'] ; ?></p> <p class="extra"> <span class="reading">阅读(<?php echo $value['views'] ; ?>)</span> <span class="comment">评论(<?php echo $value['commentsCount'] ; ?>)</span> <a href="javascript:;" class="like"> <i class="fa fa-thumbs-up"></i> <span>赞(<?php echo $value['likes'] ; ?>)</span> </a> <a href="javascript:;" class="tags"> 分类：<span><?php echo $value['name'] ; ?></span> </a> </p> <a href="javascript:;" class="thumb"> <img src="static/uploads/hots_2.jpg" alt=""> </a> </div> </div> <?php } ?> </div> </div> ```` ### 02-添加加载更多按钮 #### 2.1在list.php添加 ````php+HTML <div class="loadmore"> <span class="btn">加载更多</span> </div> ```` #### 2.2在static/assets/css/style.css 添加css ````css .loadmore { text-align: center; padding: 50px 0; } .loadmore .btn { border: 1px solid #ccc; border-radius: 7px; padding: 10px 20px; cursor: pointer; } ```` #### 2.3添加按钮点击事件 在list.php界面添加 ````js <script src="static/assets/vendors/jquery/jquery.js"></script> <script> $(function(){ $(".loadmore .btn").on("click",function(){ }) }); </script> ```` #### 2.4 创建加载更多 api接口 #### 在根目录创建api文件夹 里面创建 _getMorePost.php ````php <?php //加载更多的数据 接口 include_once '../functions.php'; //获取参数数据 $categoryId=$_POST['categoryId']; //分类id $currentPage=$_POST['currentPage']; //当前请求次数 $PageSize=$_POST['PageSize']; //每次获取的数量 //连接数据库 $conn = connect(); $offset =($currentPage-1)* $PageSize; //(n-1)*数量 从哪开始取值 $sql="SELECT p.title,p.created,p.content,p.views,p.likes,p.feature,c.`name`,u.nickname, # 根据文章id到comments表格中查找对应的评论数量 (SELECT count(id) FROM comments WHERE post_id = p.id) as comm