search

博客列表 >第十期PHP仿蜂鸟网数据库数据渲染页面（2020-01-17）

第十期PHP仿蜂鸟网数据库数据渲染页面（2020-01-17）

齐齐
齐齐原创
2020年02月07日 23:19:00657浏览

新建数据库，建数据表

新闻资讯

图片专区


二手交易

合作单位

公共部分

连接数据库

  1. namespace pdo;
  2. use PDO;
  3. //1.连接数据库
  4. //数据源
  5. $dsb="mysql:host=localhost;dbname=phpedu;";
  6. //用户名
  7. $name="root";
  8. //密码
  9. $pwd="root";
  10. //实例化pdo类
  11. $pdo=new PDO($dsb,$name,$pwd);
  12. //2.操作数据库
  13. //准备sql语句
  14. //3.关闭数据库

头部文件(路径：public/)

  1.     //   载入连接数据库文件
  2. <?php include "pdo.php" ?>
  3. <nav class="public-header">
  4.     <a href="">网站首页</a>
  5.     <a href="">专题</a>
  6.     <a href="">网站导航</a>
  7.     <a href="">二手商品</a>
  8.     <a href="">讨论区</a>
  9.     <span>
  10.         <a href=""><i class="iconfont icon-huiyuan2"></i>登陆</a>
  11.         <a href="">免费注册</a>
  12.     </span>
  13. </nav>

底部文件

  1. <footer class="public-footer">
  2.     <div>
  3.         <a href="">简介</a>
  4.         <a href="">联系我们</a>
  5.         <a href="">招聘信息</a>
  6.         <a href="">友情链接</a>
  7.         <a href="">用户服务协议</a>
  8.         <a href="">隐私权声明</a>
  9.         <a href="">法律投诉声明</a>
  10.     </div>
  11.     <div><span>LOGO</span></div>
  12.     <div>
  13.         <p>2019 fengniao.com. All rights reserved . 安徽闹着玩有限公司（无聊网）版权所有</p>
  14.         <p>皖ICP证150110号 京ICP备14323013号-2 皖公网安备110108024357788号</p>
  15.         <p>违法和不良信息举报电话: 0551-1234567 举报邮箱: admin@baidu.com</p>
  16.     </div>
  17.     <div>
  18.         <p>关注公众号</p>
  19.         <img src="static/images/erwei-code.png" alt="">
  20.     </div>
  21. </footer>

公共推荐图文列表

  1. <div class="article-public-recommend">
  2.     <h3>推荐阅读</h3>
  3.     <div class="img-list">
  4.         <?php
  5.         $img="select * from `edu_img` limit 8";
  6.         $stmt=$pdo->prepare($img);
  7.         $stmt->execute();
  8.         $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  9.         foreach ($dates as $date):?>
  10.             <div>
  11.                 <a href="iview.php?id=<?php echo $date['id']?>"><img src="<?php echo $date['litpic']?>" alt=""></a>
  12.                 <a href="iview.php?id=<?php echo $date['id']?>"><?php echo $date['title']?></a>
  13.             </div>
  14.         <?php endforeach;?>
  15.     </div>
  17. </div>

网站首页

php代码

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <!--    当前文档要用到阿里字体图标-->
  6.     <link rel="stylesheet" href="static/font/iconfont.css">
  7.     <link rel="stylesheet" href="index.css">
  8.     <title>全站首页</title>
  9. </head>
  10. <body>
  11. <!--公共页眉-->
  12. <?php include __DIR__ ."/public/head.php"?>
  14. <!--主体全部放在main元素中-->
  15. <main>
  16. <!--    首页头部导航与轮播-->
  17.     <div class="index-header">
  18.         <div class="content">
  19.             <!--logo与搜索框,快速入口-->
  20.             <div class="log-search">
  21.                 <a href="" class="logo"><img src="static/images/logo.png" alt=""></a>
  22.                 <div class="search">
  23.                     <input type="search" name="search" id="search">
  24.                     <label for="search" class="iconfont icon-jinduchaxun"></label>
  25.                 </div>
  26.                 <div class="quick-entry">
  27.                     <a href="" class="iconfont icon-huiyuan1"></a>
  28.                     <a href="" class="iconfont icon-danmu1"></a>
  29.                     <a href="" class="iconfont icon-fabu"></a>
  30.                     <a href="" class="iconfont icon-fangda"></a>
  31.                     <a href="" class="iconfont icon-huiyuan2"></a>
  32.                     <a href="" class="iconfont icon-dianzan"></a>
  33.                 </div>
  34.             </div>
  36.             <!--主导航-->
  37.             <div class="main-nav">
  38.                 <!--导航详情1-->
  39.                 <div class="nav-detail">
  40.                     <!--左侧图标与描述-->
  41.                     <div class="pic">
  42.                         <span class="iconfont icon-gongdan"></span>
  43.                         <div>
  44.                             <span>资讯</span>
  45.                             <span>学习</span>
  46.                         </div>
  47.                     </div>
  48.                     <!--右侧导航链接-->
  49.                     <div class="links">
  50.                         <a href="">器材</a>
  51.                         <a href="">大师</a>
  52.                         <a href="">学院</a>
  53.                         <a href="">实战</a>
  54.                         <a href="">大赛</a>
  55.                         <a href="">裤子</a>
  56.                         <a href="">影视</a>
  57.                         <a href="">其它</a>
  58.                     </div>
  59.                 </div>
  60.                 <!--导航详情2-->
  61.                 <div class="nav-detail">
  62.                     <!--左侧图标与描述-->
  63.                     <div class="pic">
  64.                         <span class="iconfont icon-renwujincheng"></span>
  65.                         <div>
  66.                             <span>爱好</span>
  67.                             <span>姐妹</span>
  68.                         </div>
  69.                     </div>
  70.                     <!--右侧导航链接-->
  71.                     <div class="links">
  72.                         <a href="">有品</a>
  73.                         <a href="">图片</a>
  74.                         <a href="">喝水</a>
  75.                         <a href="">飞机</a>
  76.                         <a href="">坦克</a>
  77.                         <a href="">气球</a>
  78.                         <a href="">毛线</a>
  79.                         <a href="">其它</a>
  80.                     </div>
  81.                 </div>
  82.                 <!--导航详情3-->
  83.                 <div class="nav-detail">
  84.                     <!--左侧图标与描述-->
  85.                     <div class="pic">
  86.                         <span class="iconfont icon-gongdan"></span>
  87.                         <div>
  88.                             <span>软件</span>
  89.                             <span>技能</span>
  90.                         </div>
  91.                     </div>
  92.                     <!--右侧导航链接-->
  93.                     <div class="links">
  94.                         <a href="">学习</a>
  95.                         <a href="">爱国</a>
  96.                         <a href="">敬业</a>
  97.                         <a href="">友善</a>
  98.                         <a href="">富强</a>
  99.                         <a href="">互助</a>
  100.                         <a href="">仁义</a>
  101.                         <a href="">其它</a>
  102.                     </div>
  103.                 </div>
  104.                 <!--导航详情4-->
  105.                 <div class="nav-detail">
  106.                     <!--左侧图标与描述-->
  107.                     <div class="pic">
  108.                         <span class="iconfont icon-DOC"></span>
  109.                         <div>
  110.                             <span>编程</span>
  111.                             <span>美女</span>
  112.                         </div>
  113.                     </div>
  114.                     <!--右侧导航链接-->
  115.                     <div class="links">
  116.                         <a href="">吃饭</a>
  117.                         <a href="">周易</a>
  118.                         <a href="">黄山</a>
  119.                         <a href="">合肥</a>
  120.                         <a href="">上海</a>
  121.                         <a href="">杭州</a>
  122.                         <a href="">北京</a>
  123.                         <a href="">其它</a>
  124.                     </div>
  125.                 </div>
  126.             </div>
  128.             <!--轮播图-->
  129.             <div class="slider">
  130.                 <a href=""><img src="static/images/2.jpg" alt=""></a>
  131.                 <a href=""><img src="static/images/banner-right.jpg" alt=""></a>
  132.             </div>
  133.         </div>
  134.     </div>
  136. <!--    新闻资讯-->
  137.     <!--引入大标题组件-->
  138.     <div class="public-headline">
  139.         <span>新闻资讯</span>
  140.     </div>
  141.     <div class="index-news">
  143.         <!--    左侧图片列表-->
  144.         <div class="imgs">
  145.             <?php
  146.             $img="select * from `edu_new` limit 1";
  147.             $stmt=$pdo->prepare($img);
  148.             $stmt->execute();
  149.             $date=$stmt->fetch(PDO::FETCH_ASSOC);
  150.             echo '<a href="view.php?id='.$date["id"].'"><img src="'.$date["litpic"].'" alt="" class="first-img"></a>'
  151.             ?>
  152.             <?php
  153.             $img="select * from `edu_new` limit 1,2";
  154.             $stmt=$pdo->prepare($img);
  155.             $stmt->execute();
  156.             $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  157.             foreach ($dates as $date):?>
  158.                 <div><a href="view.php?id=<?php echo $date['id']?>"><img src="<?php echo $date['litpic']?>" alt=""></a>
  159.                 <a href=""><?php echo $date['title']?></a>
  160.                 </div>
  161.             <?php endforeach;?>
  163.         </div>
  165.         <!--    中间与右边信息列表共用样式-->
  166.         <div class="list">
  167.             <?php
  168.             $img="select * from `edu_new` limit 1";
  169.             $stmt=$pdo->prepare($img);
  170.             $stmt->execute();
  171.             $date=$stmt->fetch(PDO::FETCH_ASSOC);
  172.             echo '<a href="view.php?id='.$date["id"].'">'.$date["title"].'</a>'
  173.             ?>
  174.             <ul>
  175.                 <?php
  176.                 $img="select * from `edu_new` limit 1,9";
  177.                 $stmt=$pdo->prepare($img);
  178.                 $stmt->execute();
  179.                 $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  180.                 foreach ($dates as $date):?>
  181.                     <li><span>[新闻]</span><a href="view.php?id=<?php echo $date['id']?>"><?php echo $date['title']?></a></li>
  182.                 <?php endforeach;?>
  184.             </ul>
  185.         </div>
  187.         <div class="list">
  188.             <?php
  189.             $img="select * from `edu_new` limit 3,1";
  190.             $stmt=$pdo->prepare($img);
  191.             $stmt->execute();
  192.             $date=$stmt->fetch(PDO::FETCH_ASSOC);
  193.             echo '<a href="view.php?id='.$date["id"].'">'.$date["title"].'</a>'
  194.             ?>
  195.             <ul>
  196.                 <?php
  197.                 $img="select * from `edu_new` limit 3,9";
  198.                 $stmt=$pdo->prepare($img);
  199.                 $stmt->execute();
  200.                 $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  201.                 foreach ($dates as $date):?>
  202.                     <li><span>[促销]</span><a href="view.php?id=<?php echo $date['id']?>"><?php echo $date['title']?></a></li>
  203.                 <?php endforeach;?>
  205.             </ul>
  206.         </div>
  207.     </div>
  209.     <!--引入大标题组件-->
  210.     <div class="public-headline">
  211.         <span>图片专区</span>
  212.     </div>
  213. <!--    图文列表专区-->
  214.     <div class="public-image-list">
  215.         <?php
  216.         $img="select * from ` edu_img_typeid`";
  217.         $stmt=$pdo->prepare($img);
  218.         $stmt->execute();
  219.         $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  220.         $img1="select * from `edu_img`";
  221.         $stmt1=$pdo->prepare($img1);
  222.         $stmt1->execute();
  223.         $dates1=$stmt1->fetchAll(PDO::FETCH_ASSOC);
  224.         foreach ($dates as $date):?>
  225.         <div class="list">
  226.             <div class="title">
  227.                 <a href="<?php echo $date['url']?>"><?php echo $date['typename']?></a>
  228.                 <span>纵观摄影艺术</span>
  229.             </div>
  230.             <div class="img-list">
  231.                 <?foreach ($dates1 as $date1):?>
  232.                 <?php if($date['id']===$date1['typeid']):?>
  233.                 <div>
  234.                     <a href="iview.php?id=<?php echo $date1['id']?>"><img src="<?php echo $date1['litpic']?>" alt=""></a>
  235.                     <a href="iview.php?id=<?php echo $date1['id']?>"><?php echo $date1['title']?></a>
  236.                 </div>
  237.                <?php endif;?>
  238.                 <?php endforeach;?>
  239.                 </div>
  240.             </div>
  241.         <?php endforeach;?>
  244.     </div>
  246. <!--    二手交易专区-->
  247.     <!--引入大标题组件-->
  248.     <div class="public-headline">
  249.         <span>二手交易</span>
  250.     </div>
  252.     <!--二手交易专区-->
  253.     <div class="public-second-hand">
  254.         <!-- 标题1-->
  255.         <div class="title1">
  256.             <a href="">抢好货</a>
  257.             <span>0低价, 便捷,安全,快速</span>
  258.         </div>
  259.         <!-- 标题2-->
  260.         <div class="title2">
  261.             <span>热门分类</span>
  262.             <a href="">美女写真</a>
  263.             <a href="">日本美女</a>
  264.             <a href="">美国美女</a>
  265.             <a href="">国内美女</a>
  266.             <a href="">AV美女</a>
  267.         </div>
  268.         <!--商品展示区-->
  269.         <div class="goods">
  270.             <!--左侧商品列表-->
  271.             <div class="goods-list">
  272.                 <!-- 商品简介-->
  273.                 <?php
  274.                 $img="select * from `edu_shop` limit 8";
  275.                 $stmt=$pdo->prepare($img);
  276.                 $stmt->execute();
  277.                 $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  278.                 foreach ($dates as $date):?>
  279.                     <div class="intro">
  280.                         <a href="shop.php?id=<?php echo $date['id']?>"><img src="<?php echo $date['litpic']?>" alt="" width="176" height="120"></a>
  281.                         <a href="shop.php?id=<?php echo $date['id']?>"><?php echo $date['title']?></a>
  282.                         <div>
  283.                             <span>¥ <?php echo $date['money']?></span>
  284.                             <span><?php echo $date['tags']?></span>
  285.                         </div>
  286.                     </div>
  287.                 <?php endforeach;?>
  292.             </div>
  293.             <!--右侧功能快速入口-->
  294.             <div class="quick-entry">
  295.                 <a href=""><img src="static/images/ad/1.png" alt="" ></a>
  296.                 <a href=""><img src="static/images/ad/2.png" alt=""></a>
  297.                 <a href=""><img src="static/images/ad/3.png" alt=""></a>
  298.                 <a href=""><img src="static/images/ad/4.png" alt=""></a>
  299.                 <div>
  300.                     <a href=""><img src="static/images/ad/image.png" alt=""></a>
  301.                     <a href=""><img src="static/images/ad/ad2.jpg" alt=""></a>
  302.                 </div>
  303.             </div>
  304.         </div>
  305.     </div>
  307. <!--    大标题-->
  308.     <div class="public-headline">
  309.         <span>合作单位</span>
  310.     </div>
  311. <!--    合作友情链接-->
  312.     <div class="index-frend-links">
  313.         <?php
  314.         $img="select * from `edu_flink`";
  315.         $stmt=$pdo->prepare($img);
  316.         $stmt->execute();
  317.         $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  318.         foreach ($dates as $date):?>
  319.             <a href="<?php echo $date['url']?>"><?php echo $date['name']?></a>
  320.         <?php endforeach;?>
  322.     </div>
  323. </main>
  326. <!--公共页脚-->
  327. <?php include __DIR__ ."/public/footer.php" ?>
  328. </body>
  329. </html>

运行结果

新闻列表页

php代码

  1. <!DOCTYPE html>
  2. <html lang="en">
  4. <head>
  5.     <meta charset="UTF-8">
  6.     <link rel="stylesheet" href="article_list.css">
  7.     <title>文章系统列表页</title>
  8. </head>
  10. <body>
  11. <!--公共页眉-->
  12. <?php include __DIR__ ."/public/head.php"?>
  13. <!--文章系统公共头部-->
  14. <div class="article-header">
  15.     <div class="content">
  16.         <img src="static/images/ar-logo.png" alt="">
  17.         <a href="">财经</a>&gt;<span>正文</span>
  18.         <div class="search">
  19.             <input type="search" id="search" placeholder="搜索关键字">
  20.             <label class="iconfont icon-sousuo2" for="search"></label>
  21.         </div>
  22.     </div>
  23. </div>
  24. <!--将列表与评论放在一个main元素中-->
  25. <main>
  26.     <!--公共评论列表1-->
  27.     <div class="public-comment-list">
  28.         <h3>最新评论</h3>
  29.         <ul>
  30.             <?php
  31.             $sql="select * from `edu_new` order by `comment` desc limit 10;";
  32.             $stmt=$pdo->prepare($sql);
  33.             $stmt->execute();
  34.             $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  35.             foreach ($dates as $date):?>
  36.                 <li> <a href="view.php?id=<?php echo $date['id']?>"><?php echo mb_substr($date['title'],0,20)?></a></li>
  37.             <?php endforeach;?>
  38.         </ul>
  39.     </div>
  40.     <!--公共评论列表2-->
  41.     <div class="public-comment-list">
  42.         <h3>最新评论</h3>
  43.         <ul>
  44.             <?php
  45.             $sql="select * from `edu_new` order by `comment` desc limit 10;";
  46.             $stmt=$pdo->prepare($sql);
  47.             $stmt->execute();
  48.             $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  49.             foreach ($dates as $date):?>
  50.                 <li> <a href="view.php?id=<?php echo $date['id']?>"><?php echo mb_substr($date['title'],0,20)?></a></li>
  51.             <?php endforeach;?>
  52.         </ul>
  53.     </div>
  54.     <!--文章系统图文列表-->
  55.     <div class="article-list-content">
  56.         <div class="top-nav">
  57.             <a href="">头条</a>
  58.             <a href="">热文</a>
  59.             <a href="">直播</a>
  60.             <a href="" id="active">新闻</a>
  61.             <a href="">政策地图</a>
  62.             <a href="">相对论</a>
  63.             <a href="">人物</a>
  64.             <a href="">行情</a>
  65.             <a href="">投研</a>
  66.             <a href="">技术</a>
  67.             <a href="">百科</a>
  68.         </div>
  69.         <?php
  70.         $img="select * from `edu_new` limit 5";
  71.         $stmt=$pdo->prepare($img);
  72.         $stmt->execute();
  73.         $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  74.         foreach ($dates as $date):?>
  75.             <div class="img-list">
  76.                 <a href="view.php?id=<?php echo $date['id']?>"><img src="<?php echo $date['litpic']?>" alt="" width="272"></a>
  77.                 <div class="intro">
  78.                     <div class="title">
  79.                         <a href="view.php?id=<?php echo $date['id']?>"><?php echo $date['title']?></a>
  80.                         <span><?php echo $date['description']?></span>
  81.                     </div>
  82.                     <div class="time">
  83.                         <a href="view.php?id=<?php echo $date['id']?>"><?php echo $date['source']?> · 46 分钟前</a>
  84.                         <span><i class="iconfont icon-icon_yulan"></i>2233</span>
  85.                     </div>
  86.                 </div>
  87.             </div>
  88.         <?php endforeach;?>
  91.     </div>
  92.     <!--文章系统公共推荐图文列表-->
  93.     <?php include __DIR__ ."/public/img_com.php"?>
  94.     <!--    分页条-->
  95.     <div class="public-paginate">
  96.         <a href="">&lt;</a>
  97.         <a href="">1</a>
  98.         <a href="">2</a>
  99.         <a href="">3</a>
  100.         <a href="">4</a>
  101.         <a href="">5</a>
  102.         <a href="">6</a>
  103.         <a href="">7</a>
  104.         <a href="">8</a>
  105.         <a href="">&gt;</a>
  106.     </div>
  107. </main>
  108. <!--公共页脚-->
  109. <?php include __DIR__ ."/public/footer.php"?>
  110. </body>
  112. </html>

运行结果

新闻详情页

php代码

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <!--    当前文档要用到阿里字体图标-->
  6.     <link rel="stylesheet" href="static/font/iconfont.css">
  7.     <link rel="stylesheet" href="article_detail.css">
  8.     <title>文章系统详情页</title>
  9. </head>
  10. <body>
  11. <!--公共页眉-->
  12. <?php include __DIR__ ."/public/head.php"?>
  13. <?php
  14. $aid=$_GET['id'];
  15. $img = "select * from `edu_new` where id=:id";
  16. $stmt = $pdo->prepare($img);
  17. $stmt->execute(['id'=>$aid]);
  18. $date = $stmt->fetch(PDO::FETCH_ASSOC);
  19. ?>
  20. <!--文章系统公共头部-->
  21. <div class="article-header">
  22.     <div class="content">
  23.         <img src="static/images/ar-logo.png" alt="">
  24.         <a href="">财经</a>&gt;<span>正文</span>
  25.         <div class="search">
  26.             <input type="search" id="search" placeholder="搜索关键字">
  27.             <label class="iconfont icon-sousuo2" for="search"></label>
  28.         </div>
  29.     </div>
  30. </div>
  32. <!--将列表与评论放在一个main元素中-->
  33. <main>
  34.     <!--公共评论列表-->
  35.     <div class="public-comment-list">
  36.         <h3>最新评论</h3>
  37.         <ul>
  38.             <?php
  39.             $sql="select * from `edu_new` order by `comment` desc limit 10;";
  40.             $stmt=$pdo->prepare($sql);
  41.             $stmt->execute();
  42.             $dates=$stmt->fetchAll(PDO::FETCH_ASSOC);
  43.             foreach ($dates as $date):?>
  44.                 <li> <a href="view.php?id=<?php echo $date['id']?>"><?php echo mb_substr($date['title'],0,20)?></a></li>
  45.             <?php endforeach;?>
  46.         </ul>
  47.     </div>
  48.     <?php
  49.     $aid=$_GET['id'];
  50.     $img = "select * from `edu_new` where id=:id";
  51.     $stmt = $pdo->prepare($img);
  52.     $stmt->execute(['id'=>$aid]);
  53.     $date = $stmt->fetch(PDO::FETCH_ASSOC);
  54.     ?>
  55.     <!--文章系统内容详情-->
  56.     <div class="article_detail">
  57.         <h1><?php echo $date['title'] ?></h1>
  58.         <div>
  59.             <span>发布时间：<?php echo date('Y年m月d日',$date['pubdate'])?></span>
  60.             <span>来源: <?php echo $date['source']?></span>
  61.             <span>阅读量:12545</span>
  62.             <span>评论数:145</span>
  63.         </div>
  64.         <div>
  65.             <?php echo $date['body'] ?>
  66.         </div>
  67.     </div>
  69.     <!--点赞-->
  70.     <div class="article-detail-like">
  71.         <span>赞</span>
  72.         <span>踩</span>
  73.     </div>
  75.     <!--公共评论与回复-->
  76.     <div class="public-comment-reply">
  77.         <!--    评论区-->
  78.         <div class="comment">
  79.             <h3>我要评论</h3>
  80.             <div>
  81.                 <label for="comment"><img src="static/images/user.png" alt=""></label>
  82.                 <textarea name="" id="comment"></textarea>
  83.             </div>
  84.             <button>发表评论</button>
  85.         </div>
  87.         <!--    回复区-->
  88.         <div class="reply">
  89.             <h3>最新回复</h3>
  90.             <div>
  91.                 <img src="static/images/user.png" alt="">
  92.                 <div class="detail">
  93.                     <span>用户昵称</span>
  94.                     <span>留言内容: php中文网,是一个有温度,有思想的学习平台</span>
  95.                     <div>
  96.                         <span>2019-12-12 15:34:23发表</span>
  97.                         <span><i class="iconfont icon-dianzan"></i>回复</span>
  98.                     </div>
  99.                 </div>
  100.             </div>
  102.             <div>
  103.                 <img src="static/images/user.png" alt="">
  104.                 <div class="detail">
  105.                     <span>用户昵称</span>
  106.                     <span>留言内容: php中文网,是一个有温度,有思想的学习平台</span>
  107.                     <div>
  108.                         <span>2019-12-12 15:34:23发表</span>
  109.                         <span><i class="iconfont icon-dianzan"></i>回复</span>
  110.                     </div>
  111.                 </div>
  112.             </div>
  114.             <div>
  115.                 <img src="static/images/user.png" alt="">
  116.                 <div class="detail">
  117.                     <span>用户昵称</span>
  118.                     <span>留言内容: php中文网,是一个有温度,有思想的学习平台</span>
  119.                     <div>
  120.                         <span>2019-12-12 15:34:23发表</span>
  121.                         <span><i class="iconfont icon-dianzan"></i>回复</span>
  122.                     </div>
  123.                 </div>
  124.             </div>
  126.             <div>
  127.                 <img src="static/images/user.png" alt="">
  128.                 <div class="detail">
  129.                     <span>用户昵称</span>
  130.                     <span>留言内容: php中文网,是一个有温度,有思想的学习平台</span>
  131.                     <div>
  132.                         <span>2019-12-12 15:34:23发表</span>
  133.                         <span><i class="iconfont icon-dianzan"></i>回复</span>
  134.                     </div>
  135.                 </div>
  136.             </div>
  137.         </div>
  138.     </div>
  140.     <!--文章系统公共推荐图文列表-->
  141.     <?php include __DIR__ ."/public/img_com.php"?>
  142. </main>
  144. <!--公共页脚-->
  145. <?php include __DIR__ ."/public/footer.php"?>
  146. </body>
  147. </html>

运行结果

案例总结

1.数据库表的结构分析至关重要，可以防止反复增加字段，加长项目时间。做这个案例的过程中，体会非常深刻。表之间的关联性差，自认为是创建表结构中最大的问题。

2.foreash循环二维数组，高效有方便。

3.页面中，可能php代码冗余，却也只能用最笨的方法来实现。猜想或许可以通过一个方法，载入不同的sql语句，能够实现查询相应条件数据。

上一条：12月18日开学第一课下一条：jquery fancybox插件
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多