Community Learn Tools Library Leisure
search
English
Home > List of blog posts > 12月-前端大作业-PHP培训线上九期班
Blogger Information
Blog 53
fans 3
comment 0
visits 55277
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
12月-前端大作业-PHP培训线上九期班
邯郸易住宋至刚
Original
935 people have browsed it

一、项目分析

准备先在首页实现动态数据

1、创建数据表

数据表有：栏目表、导航表（这两者本来也可以合并的）、图片表、新闻列表

2、数据查询

查询使用PDO预处理查询

3、代码分段

首页代码分为

index.php

  1. <?php
  2. include 'inc/header.php';
  3. include 'inc/banner.php';
  4. include 'inc/news.php';
  5. include 'inc/images.php';
  6. include 'inc/trade.php';
  7. include 'inc/footer.php';

header.php

  1. <?php
  2. require 'DB.php';
  4. ?>
  6. <!DOCTYPE html>
  7. <html lang="en">
  8. <head>
  9.     <meta charset="UTF-8">
  10.     <title>网站首页</title>
  11.     <!--    <link rel="stylesheet" href="static/css/reset.css">-->
  12.     <link rel="stylesheet" href="static/font/iconfont.css">
  13.     <link rel="stylesheet" href="static/css/index.css">
  14. </head>
  15. <body>
  16. <!--公共顶部导航区-->
  17. <header>
  18.     <?php foreach ($cates as $cate) :?>
  19.     <a href=""><?php echo $cate['name']; ?></a>
  20.     <?php endforeach; ?>
  21.     <span><a href=""><i class="iconfont icon-huiyuan2"></i>登陆</a><a href="">免费注册</a></span>
  22. </header>
  24. <!--logo+搜索框+快捷入口区-->
  25. <div class="logo">
  26.     <img src="<?php echo $logo[0]['url']?>" alt="">
  27.     <label>
  28.         <input type="search">
  29.         <a href="" class="iconfont icon-jinduchaxun"></a>
  30.     </label>
  31.     <span>
  32.         <a href="" class="iconfont icon-huiyuan1"></a>
  33.         <a href="" class="iconfont icon-danmu"></a>
  34.         <a href="" class="iconfont icon-duoxuankuang"></a>
  35.         <a href="" class="iconfont icon-jishufuwu"></a>
  36.         <a href="" class="iconfont icon-peiwangyindao"></a>
  37.         <a href="" class="iconfont icon-wenjianjia"></a>
  38.         <a href="" class="iconfont icon-huiyuan1"></a>
  39.     </span>
  40. </div>
  42. <!--主导航区-->
  43. <nav>
  44.     <div>
  45.         <span class="iconfont icon-gongdan"></span>
  46.         <span>资讯 <br> 看学</span>
  47.         <?php foreach ($navs as $nav)  :?>
  48.         <a href=""><?php echo $nav['name']; ?></a>
  49.         <?php endforeach; ?>
  50.     </div>
  52.     <div>
  53.         <span class="iconfont icon-renwujincheng"></span>
  54.         <span>资讯 <br> 看学</span>
  55.         <?php foreach ($navs as $nav)  :?>
  56.             <a href=""><?php echo $nav['name']; ?></a>
  57.         <?php endforeach; ?>
  58.     </div>
  60.     <div>
  61.         <span class="iconfont icon-gongdan"></span>
  62.         <span>资讯 <br> 看学</span>
  63.         <?php foreach ($navs as $nav)  :?>
  64.             <a href=""><?php echo $nav['name']; ?></a>
  65.         <?php endforeach; ?>
  66.     </div>
  68.     <div>
  69.         <span class="iconfont icon-DOC"></span>
  70.         <span>资讯 <br> 看学</span>
  71.         <?php foreach ($navs as $nav)  :?>
  72.             <a href=""><?php echo $nav['name']; ?></a>
  73.         <?php endforeach; ?>
  74.     </div>
  78. </nav>
  1. <!--合作网站-->
  2. <div class="title" style="background:#fff">
  3.     <span>合作网站</span>
  4. </div>
  5. <div class="my-links">
  6.     <a href="https://www.php.cn">php中文网</a>
  7.     <a href="https://www.html.cn">html中文网</a>
  8.     <a href="https://www.py.cn">python中文网</a>
  9.     <a href="https://www.php.cn">php中文网</a>
  10.     <a href="https://www.html.cn">html中文网</a>
  11.     <a href="https://www.py.cn">python中文网</a>
  12.     <a href="https://www.php.cn">php中文网</a>
  13.     <a href="https://www.html.cn">html中文网</a>
  14.     <a href="https://www.py.cn">python中文网</a>
  15.     <a href="https://www.php.cn">php中文网</a>
  16.     <a href="https://www.html.cn">html中文网</a>
  17.     <a href="https://www.py.cn">python中文网</a>
  18.     <a href="https://www.py.cn">python中文网</a>
  19.     <a href="https://www.php.cn">php中文网</a>
  20.     <a href="https://www.html.cn">html中文网</a>
  21.     <a href="https://www.py.cn">python中文网</a>
  22.     <a href="https://www.php.cn">php中文网</a>
  23.     <a href="https://www.html.cn">html中文网</a>
  24.     <a href="https://www.py.cn">python中文网</a>
  25.     <a href="https://www.php.cn">php中文网</a>
  26.     <a href="https://www.html.cn">html中文网</a>
  27.     <a href="https://www.py.cn">python中文网</a>
  28.     <a href="https://www.php.cn">php中文网</a>
  29.     <a href="https://www.html.cn">html中文网</a>
  30.     <a href="https://www.py.cn">python中文网</a>
  31.     <a href="https://www.py.cn">python中文网</a>
  32. </div>
  34. <!--页底部-->
  35. <footer>
  36.     <div>
  37.         <a href="">简介</a>
  38.         <a href="">联系我们</a>
  39.         <a href="">招聘信息</a>
  40.         <a href="">友情链接</a>
  41.         <a href="">用户服务协议</a>
  42.         <a href="">隐私权声明</a>
  43.         <a href="">法律投诉声明</a>
  44.     </div>
  45.     <div><span>LOGO</span></div>
  46.     <div>
  47.         <p>2019 fengniao.com. All rights reserved . 安徽闹着玩有限公司（无聊网）版权所有</p>
  48.         <p>皖ICP证150110号 京ICP备14323013号-2 皖公网安备110108024357788号</p>
  49.         <p>违法和不良信息举报电话: 0551-1234567 举报邮箱: admin@baidu.com</p>
  50.     </div>
  51.     <div>
  52.         <p>关注公众号</p>
  53.         <img src="<?=$erwei[0]['url'];?>" alt="">
  54.     </div>
  55. </footer>
  56. </body>
  57. </html>

banner.php

  1. <!--轮播图-->
  2. <?php
  3. require 'connect.php';
  5. //获取轮播图片
  6. $sql = "SELECT * FROM `picture` WHERE `name`= 'banner2'";
  7. $stmt = $pdo->prepare($sql);
  8. $stmt -> execute();
  9. $banner = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  11. //获取轮播右边图片
  12. $sql = "SELECT * FROM `picture` WHERE `name`= 'banner-right'";
  13. $stmt = $pdo->prepare($sql);
  14. $stmt -> execute();
  15. $banner_right = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  17. ?>
  19. <div class="slider">
  20.     <img src="<?php echo $banner[0]['url'] ?>" alt="">
  21.     <img src="<?php echo $banner_right[0]['url'] ?>" alt="">
  22. </div>

news.php

  1. <!--新闻资讯区-->
  2. <div class="news">
  3.     <div class="title">
  4.         <a>新闻资讯</a>
  5.         <a href="">更多</a>
  6.     </div>
  8.     <div class="content">
  9.         <div class="pic">
  10.             <a href=""><img src="<?php echo $n_1[0]['url'] ?>" alt="" class="first-img"></a>
  11.             <a href=""><img src="<?php echo $n_2[0]['url'] ?>" alt=""></a>
  12.             <a href=""><img src="<?php echo $n_3[0]['url'] ?>" alt=""></a>
  13.             <a href="">三星Note10/10+发布 <br> 搭载挖孔前摄</a>
  14.             <a href="">小米公布6400万 <br> 和1亿像素手机信息</a>
  15.         </div>
  17.         <div class="list">
  18.             <a href="">性价比广角 腾龙17-28F2.8评测</a>
  19.             <ul>
  20.                 <?php foreach ($news as $new) : ?>
  21.                 <li><span>[新闻]</span><a href=""><?php echo $new['title'];?></a></li>
  22.                 <?php endforeach;?>
  24.                 <?php foreach ($news as $new) : ?>
  25.                 <li><span>[新闻]</span><a href=""><?php echo $new['title'];?></a></li>
  26.                 <?php endforeach;?>
  27.                 <!-- <li><span>[新闻]</span><a href="">Entaniya宣布推出Super 35 PL卡口鱼眼镜头</a></li>
  28.                 <li><span>[新闻]</span><a href="">轻便灵巧可变形 JOBY入门迷你三脚架套装试用</a></li>
  29.                 <li><span>[新闻]</span><a href="">乐摄宝Photo Active BP 300 AW背包评测</a></li>
  30.                 <li><span>[新闻]</span><a href="">佳能注册相机无线充电和眼控对焦专利</a></li>
  31.                 <li><span>[新闻]</span><a href="">Entaniya宣布推出Super 35 PL卡口鱼眼镜头</a></li>
  32.                 <li><span>[新闻]</span><a href="">轻便灵巧可变形 JOBY入门迷你三脚架套装试用</a></li>
  33.                 <li><span>[新闻]</span><a href="">乐摄宝Photo Active BP 300 AW背包评测</a></li>
  34.                 <li><span>[新闻]</span><a href="">乐摄宝Photo Active BP 300 AW背包评测</a></li> -->
  35.             </ul>
  36.         </div>
  38.         <div class="list">
  39.             <a href="">性价比广角 腾龙17-28F2.8评测</a>
  40.             <ul>
  41.                 <?php foreach ($news as $new) : ?>
  42.                 <li><span>[新闻]</span><a href=""><?php echo $new['title'];?></a></li>
  43.                 <?php endforeach;?>
  45.                 <?php foreach ($news as $new) : ?>
  46.                 <li><span>[新闻]</span><a href=""><?php echo $new['title'];?></a></li>
  47.                 <?php endforeach;?>
  48.                 <!-- <li><span>[新闻]</span><a href="">佳能注册相机无线充电和眼控对焦专利</a></li>
  49.                 <li><span>[新闻]</span><a href="">Entaniya宣布推出Super 35 PL卡口鱼眼镜头</a></li>
  50.                 <li><span>[新闻]</span><a href="">轻便灵巧可变形 JOBY入门迷你三脚架套装试用</a></li>
  51.                 <li><span>[新闻]</span><a href="">乐摄宝Photo Active BP 300 AW背包评测</a></li>
  52.                 <li><span>[新闻]</span><a href="">佳能注册相机无线充电和眼控对焦专利</a></li>
  53.                 <li><span>[新闻]</span><a href="">Entaniya宣布推出Super 35 PL卡口鱼眼镜头</a></li>
  54.                 <li><span>[新闻]</span><a href="">轻便灵巧可变形 JOBY入门迷你三脚架套装试用</a></li>
  55.                 <li><span>[新闻]</span><a href="">乐摄宝Photo Active BP 300 AW背包评测</a></li>
  56.                 <li><span>[新闻]</span><a href="">乐摄宝Photo Active BP 300 AW背包评测</a></li> -->
  57.             </ul>
  58.         </div>
  59.     </div>
  60. </div>

images.php

  1. <!--二手交易专区-->
  2. <div class="title">
  3.     <span>二手交易</span>
  4. </div>
  6. <div class="second-hand">
  7.     <div>
  8.         <a href="">抢好货</a>
  9.         <span>0低价, 便捷,安全,快速</span>
  10.     </div>
  11.     <div>
  12.         <span>热门分类</span>
  13.         <a href="">美女写真</a>
  14.         <a href="">日本美女</a>
  15.         <a href="">美国美女</a>
  16.         <a href="">国内美女</a>
  17.         <a href="">AV美女</a>
  18.     </div>
  20.     <?php foreach ($shop1 as $s1) : ?>
  21.             <a href=""><img src="<?php echo $s1['url']; ?>" alt="" width="176" height="122"></a>
  22.     <?php endforeach; ?>
  24.     <!-- <a href=""><img src="static/images/shop/shop1.jpg" alt="" width="176" height="120"></a>
  25.     <a href=""><img src="static/images/shop/shop2.jpg" alt="" width="176" height="120"></a>
  26.     <a href=""><img src="static/images/shop/shop3.jpg" alt="" width="176" height="120"></a>
  27.     <a href=""><img src="static/images/shop/shop4.jpg" alt="" width="176" height="120"></a> -->
  29.     <?php foreach ($shop1 as $s1) : ?>
  30.         <div class="detail">
  31.         <a href=""><?php echo $s1['title']; ?></a>
  32.         <div>
  33.             <a href="">
  34.                 <span>&yen; 333</span>
  35.                 <span>美女</span>
  36.             </a>
  37.         </div>
  39.     </div>
  40.     <?php endforeach; ?>
  42.     <!-- <div class="detail">
  43.         <a href=""><?php echo $s1['title']; ?></a>
  44.         <div>
  45.             <a href="">
  46.                 <span>&yen; 333</span>
  47.                 <span>美女</span>
  48.             </a>
  49.         </div>
  51.     </div>
  52.     <div class="detail">
  53.         <a href="">美女性感写真海报墙面贴画艺术装画</a>
  54.         <div>
  55.             <a href="">
  56.                 <span>&yen; 333</span>
  57.                 <span>美女</span>
  58.             </a>
  59.         </div>
  60.     </div>
  61.     <div class="detail">
  62.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  63.         <div>
  64.             <a href="">
  65.                 <span>&yen; 333</span>
  66.                 <span>美女</span>
  67.             </a>
  68.         </div>
  69.     </div>
  70.     <div class="detail">
  71.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  72.         <div>
  73.             <a href="">
  74.                 <span>&yen; 333</span>
  75.                 <span>美女</span>
  76.             </a>
  77.         </div>
  78.     </div> -->
  80.     <?php foreach ($shop2 as $s2) : ?>
  81.             <a href=""><img src="<?php echo $s2['url']; ?>" alt="" width="176" height="122"></a>
  82.     <?php endforeach; ?>
  84.     <!-- <a href=""><img src="static/images/shop/shop1.jpg" alt="" width="176" height="120"></a>
  85.     <a href=""><img src="static/images/shop/shop2.jpg" alt="" width="176" height="120"></a>
  86.     <a href=""><img src="static/images/shop/shop3.jpg" alt="" width="176" height="120"></a>
  87.     <a href=""><img src="static/images/shop/shop4.jpg" alt="" width="176" height="120"></a> -->
  89.     <?php foreach ($shop1 as $s1) : ?>
  90.         <div class="detail">
  91.         <a href=""><?php echo $s1['title']; ?></a>
  92.         <div>
  93.             <a href="">
  94.                 <span>&yen; 333</span>
  95.                 <span>美女</span>
  96.             </a>
  97.         </div>
  99.     </div>
  100.     <?php endforeach; ?>
  102.     <!-- <a href=""><img src="static/images/shop/shop5.jpg" alt="" width="176" height="120"></a>
  103.     <a href=""><img src="static/images/shop/shop6.jpg" alt="" width="176" height="120"></a>
  104.     <a href=""><img src="static/images/shop/shop7.jpg" alt="" width="176" height="120"></a>
  105.     <a href=""><img src="static/images/shop/shop8.jpg" alt="" width="176" height="120"></a>
  107.     <div class="detail">
  108.         <a href="">美女性感写真海报墙艺术装饰画贴画图画</a><br>
  109.         <div>
  110.             <a href="">
  111.                 <span>&yen; 333</span>
  112.                 <span>美女</span>
  113.             </a>
  114.         </div>
  115.     </div>
  116.     <div class="detail">
  117.         <a href="">美女性感写真海报墙面贴画艺术装画</a>
  118.         <div>
  119.             <a href="">
  120.                 <span>&yen; 333</span>
  121.                 <span>美女</span>
  122.             </a>
  123.         </div>
  124.     </div>
  125.     <div class="detail">
  126.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  127.         <div>
  128.             <a href="">
  129.                 <span>&yen; 333</span>
  130.                 <span>美女</span>
  131.             </a>
  132.         </div>
  133.     </div>
  134.     <div class="detail">
  135.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  136.         <div>
  137.             <a href="">
  138.                 <span>&yen; 333</span>
  139.                 <span>美女</span>
  140.             </a>
  141.         </div>
  142.     </div> -->
  144.     <div>
  145.         <?php foreach ($ads as $ad) : ?>
  146.             <a href=""><img src="<?php echo $ad['url']; ?>" alt="" width="180" height="112"></a>
  147.         <?php endforeach; ?>
  148.         <!-- <a href=""><img src="<?php echo $ad['url']; ?>" alt="" width="180" height="112"></a>
  149.         <a href=""><img src="static/images/ad/2.png" alt="" width="180" height="112"></a>
  150.         <a href=""><img src="static/images/ad/3.png" alt="" width="180" height="112"></a>
  151.         <a href=""><img src="static/images/ad/4.png" alt="" width="180" height="112"></a>
  153.         <a href=""><img src="static/images/ad/image.png" alt="" width="393" height="56"></a>
  154.         <a href=""><img src="static/images/ad/ad2.jpg" alt="" width="393" height="56"></a> -->
  155.         <?php foreach ($ads2 as $ad2) : ?>
  156.             <a href=""><img src="<?php echo $ad2['url']; ?>" alt="" width="393" height="56"></a>
  157.         <?php endforeach; ?>
  158.     </div>
  159. </div>

trade.php

  1. <!--二手交易专区-->
  2. <div class="title">
  3.     <span>二手交易</span>
  4. </div>
  6. <div class="second-hand">
  7.     <div>
  8.         <a href="">抢好货</a>
  9.         <span>0低价, 便捷,安全,快速</span>
  10.     </div>
  11.     <div>
  12.         <span>热门分类</span>
  13.         <a href="">美女写真</a>
  14.         <a href="">日本美女</a>
  15.         <a href="">美国美女</a>
  16.         <a href="">国内美女</a>
  17.         <a href="">AV美女</a>
  18.     </div>
  20.     <?php foreach ($shop1 as $s1) : ?>
  21.             <a href=""><img src="<?php echo $s1['url']; ?>" alt="" width="176" height="122"></a>
  22.     <?php endforeach; ?>
  24.     <!-- <a href=""><img src="static/images/shop/shop1.jpg" alt="" width="176" height="120"></a>
  25.     <a href=""><img src="static/images/shop/shop2.jpg" alt="" width="176" height="120"></a>
  26.     <a href=""><img src="static/images/shop/shop3.jpg" alt="" width="176" height="120"></a>
  27.     <a href=""><img src="static/images/shop/shop4.jpg" alt="" width="176" height="120"></a> -->
  29.     <?php foreach ($shop1 as $s1) : ?>
  30.         <div class="detail">
  31.         <a href=""><?php echo $s1['title']; ?></a>
  32.         <div>
  33.             <a href="">
  34.                 <span>&yen; 333</span>
  35.                 <span>美女</span>
  36.             </a>
  37.         </div>
  39.     </div>
  40.     <?php endforeach; ?>
  42.     <!-- <div class="detail">
  43.         <a href=""><?php echo $s1['title']; ?></a>
  44.         <div>
  45.             <a href="">
  46.                 <span>&yen; 333</span>
  47.                 <span>美女</span>
  48.             </a>
  49.         </div>
  51.     </div>
  52.     <div class="detail">
  53.         <a href="">美女性感写真海报墙面贴画艺术装画</a>
  54.         <div>
  55.             <a href="">
  56.                 <span>&yen; 333</span>
  57.                 <span>美女</span>
  58.             </a>
  59.         </div>
  60.     </div>
  61.     <div class="detail">
  62.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  63.         <div>
  64.             <a href="">
  65.                 <span>&yen; 333</span>
  66.                 <span>美女</span>
  67.             </a>
  68.         </div>
  69.     </div>
  70.     <div class="detail">
  71.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  72.         <div>
  73.             <a href="">
  74.                 <span>&yen; 333</span>
  75.                 <span>美女</span>
  76.             </a>
  77.         </div>
  78.     </div> -->
  80.     <?php foreach ($shop2 as $s2) : ?>
  81.             <a href=""><img src="<?php echo $s2['url']; ?>" alt="" width="176" height="122"></a>
  82.     <?php endforeach; ?>
  84.     <!-- <a href=""><img src="static/images/shop/shop1.jpg" alt="" width="176" height="120"></a>
  85.     <a href=""><img src="static/images/shop/shop2.jpg" alt="" width="176" height="120"></a>
  86.     <a href=""><img src="static/images/shop/shop3.jpg" alt="" width="176" height="120"></a>
  87.     <a href=""><img src="static/images/shop/shop4.jpg" alt="" width="176" height="120"></a> -->
  89.     <?php foreach ($shop1 as $s1) : ?>
  90.         <div class="detail">
  91.         <a href=""><?php echo $s1['title']; ?></a>
  92.         <div>
  93.             <a href="">
  94.                 <span>&yen; 333</span>
  95.                 <span>美女</span>
  96.             </a>
  97.         </div>
  99.     </div>
  100.     <?php endforeach; ?>
  102.     <!-- <a href=""><img src="static/images/shop/shop5.jpg" alt="" width="176" height="120"></a>
  103.     <a href=""><img src="static/images/shop/shop6.jpg" alt="" width="176" height="120"></a>
  104.     <a href=""><img src="static/images/shop/shop7.jpg" alt="" width="176" height="120"></a>
  105.     <a href=""><img src="static/images/shop/shop8.jpg" alt="" width="176" height="120"></a>
  107.     <div class="detail">
  108.         <a href="">美女性感写真海报墙艺术装饰画贴画图画</a><br>
  109.         <div>
  110.             <a href="">
  111.                 <span>&yen; 333</span>
  112.                 <span>美女</span>
  113.             </a>
  114.         </div>
  115.     </div>
  116.     <div class="detail">
  117.         <a href="">美女性感写真海报墙面贴画艺术装画</a>
  118.         <div>
  119.             <a href="">
  120.                 <span>&yen; 333</span>
  121.                 <span>美女</span>
  122.             </a>
  123.         </div>
  124.     </div>
  125.     <div class="detail">
  126.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  127.         <div>
  128.             <a href="">
  129.                 <span>&yen; 333</span>
  130.                 <span>美女</span>
  131.             </a>
  132.         </div>
  133.     </div>
  134.     <div class="detail">
  135.         <a href="">美女性感写真海饰画酒吧卧室贴画图画</a>
  136.         <div>
  137.             <a href="">
  138.                 <span>&yen; 333</span>
  139.                 <span>美女</span>
  140.             </a>
  141.         </div>
  142.     </div> -->
  144.     <div>
  145.         <?php foreach ($ads as $ad) : ?>
  146.             <a href=""><img src="<?php echo $ad['url']; ?>" alt="" width="180" height="112"></a>
  147.         <?php endforeach; ?>
  148.         <!-- <a href=""><img src="<?php echo $ad['url']; ?>" alt="" width="180" height="112"></a>
  149.         <a href=""><img src="static/images/ad/2.png" alt="" width="180" height="112"></a>
  150.         <a href=""><img src="static/images/ad/3.png" alt="" width="180" height="112"></a>
  151.         <a href=""><img src="static/images/ad/4.png" alt="" width="180" height="112"></a>
  153.         <a href=""><img src="static/images/ad/image.png" alt="" width="393" height="56"></a>
  154.         <a href=""><img src="static/images/ad/ad2.jpg" alt="" width="393" height="56"></a> -->
  155.         <?php foreach ($ads2 as $ad2) : ?>
  156.             <a href=""><img src="<?php echo $ad2['url']; ?>" alt="" width="393" height="56"></a>
  157.         <?php endforeach; ?>
  158.     </div>
  159. </div>

数据库连接文件：connect.php

<?php
//数据库连接配置
$dbParams = [
‘type’ => ‘mysql’,
‘host’ => ‘127.0.0.1’,
‘dbname’ => ‘shop’,
‘username’=> ‘root’,
‘password’=> ‘111’
];

  1. //配置数据源dsn
  2. $dsn = "{$dbParams['type']}:host={$dbParams['host']};dbname={$dbParams['dbname']}";
  3. try {
  4.     //连接数据库
  5.     $pdo = new PDO($dsn,$dbParams['username'],$dbParams['password']);
  6. } catch (PDOException $e) {
  7.     //连接失败返回信息
  8.     die('Connection Failed' .$e->getMessage());
  9. }

数据库查询软件：DB.php

  1. <?php
  2. include __DIR__ .'/connect.php';
  4. $sql = "SELECT * FROM `picture` WHERE `name`= 'LOGO'";
  5. $stmt = $pdo->prepare($sql);
  6. $stmt -> execute();
  7. $logo = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  9. //获取栏目信息
  10. $sql = 'SELECT `id`,`name` FROM `category`';
  11. $stmt = $pdo->prepare($sql);
  12. $stmt->execute();
  13. $cates = $stmt->fetchAll(PDO::FETCH_ASSOC);
  14. //var_dump($cates);
  15. $cate_count = count($cates);    // 栏目数量
  16. //$title = $cates->title;
  18. //获取导航信息
  19. $sql = 'SELECT `id`,`name` FROM `nav`';
  20. $stmt = $pdo->prepare($sql);
  21. $stmt->execute();
  22. $navs = $stmt->fetchAll(PDO::FETCH_ASSOC);
  23. $navs_count = count($navs);    // 栏目数量
  25. //获取新闻图片1
  26. $sql = "SELECT * FROM `picture` WHERE `name`= 'n-1'";
  27. $stmt = $pdo->prepare($sql);
  28. $stmt -> execute();
  29. $n_1 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  31. //获取新闻图片2
  32. $sql = "SELECT * FROM `picture` WHERE `name`= 'n-2'";
  33. $stmt = $pdo->prepare($sql);
  34. $stmt -> execute();
  35. $n_2 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  37. //获取新闻图片3
  38. $sql = "SELECT * FROM `picture` WHERE `name`= 'n-3'";
  39. $stmt = $pdo->prepare($sql);
  40. $stmt -> execute();
  41. $n_3 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  43. //获取新闻区标题列表
  44. $sql = "SELECT * FROM `news`";
  45. $stmt = $pdo->prepare($sql);
  46. $stmt -> execute();
  47. $news = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  49. //获取图片列表
  50. $sql = "SELECT * FROM `picture` WHERE `id` > 11 LIMIT 2";
  51. $stmt = $pdo->prepare($sql);
  52. $stmt -> execute();
  53. $pictures1 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  55. for ($i=0; $i < count($pictures1) ; $i++) { 
  56.     $url1[] = $pictures1[$i]['url'];
  57.     $title1[] = $pictures1[$i]['title'];
  58. }
  60. //获取出售图片
  61. $sql = "SELECT * FROM `picture` WHERE `id` > 19 LIMIT 4";
  62. $stmt = $pdo->prepare($sql);
  63. $stmt -> execute();
  64. $shop1 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  66. //获取出售图片
  67. $sql = "SELECT * FROM `picture` WHERE `id` > 23 LIMIT 4";
  68. $stmt = $pdo->prepare($sql);
  69. $stmt -> execute();
  70. $shop2 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  72. //获取广告图片
  73. $sql = "SELECT * FROM `picture` WHERE `id` > 29 LIMIT 4";
  74. $stmt = $pdo->prepare($sql);
  75. $stmt -> execute();
  76. $ads = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  78. //获取广告图片
  79. $sql = "SELECT * FROM `picture` WHERE `id` > 33 LIMIT 2";
  80. $stmt = $pdo->prepare($sql);
  81. $stmt -> execute();
  82. $ads2 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  84. //获取二维码
  85. $sql = "SELECT * FROM `picture` WHERE `name` = 'erwei-code'";
  86. $stmt = $pdo->prepare($sql);
  87. $stmt -> execute();
  88. $erwei = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  90. //var_dump($erwei);
  91. //echo $erwei[0]['url'];
  92. //var_dump($url1,$title1);
  94. /*$url1 = [];
  95. $title1 = [];
  96. foreach ($pictures1 as $p1) {
  97.     for ($i=0; $i < count($pictures1); $i++) { 
  98.         $url1[] = $p1[$i]['url'];
  99.     $title1[] = $p1[$i]['title1'];
  100.     }
  102. }
  103. var_dump($url1,$pictures2);*/
  105. $sql = "SELECT * FROM `picture` WHERE `id` > 13 LIMIT 2";
  106. $stmt = $pdo->prepare($sql);
  107. $stmt -> execute();
  108. $pictures2 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  110. for ($i=0; $i < count($pictures2) ; $i++) { 
  111.     $url2[] = $pictures2[$i]['url'];
  112.     $title2[] = $pictures2[$i]['title'];
  113. }
  115. /*foreach ($pictures2 as $p2) {
  116.     $url2[] = $p2['url'];
  117.     $title1[] = $p2['title1'];
  118. }*/
  120. $sql = "SELECT * FROM `picture` WHERE `id` > 15 LIMIT 2";
  121. $stmt = $pdo->prepare($sql);
  122. $stmt -> execute();
  123. $pictures2 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  125. for ($i=0; $i < count($pictures2) ; $i++) { 
  126.     $url3[] = $pictures2[$i]['url'];
  127.     $title3[] = $pictures2[$i]['title'];
  128. }
  130. $sql = "SELECT * FROM `picture` WHERE `id` > 17 LIMIT 2";
  131. $stmt = $pdo->prepare($sql);
  132. $stmt -> execute();
  133. $pictures2 = $stmt ->fetchAll(PDO::FETCH_ASSOC);
  135. for ($i=0; $i < count($pictures2) ; $i++) { 
  136.     $url4[] = $pictures2[$i]['url'];
  137.     $title4[] = $pictures2[$i]['title'];
  138. }
  139. //var_dump($news);
  143. ?>

4、结果

二、总结

1、关于项目分析

没有任何经验，不知道分析什么

2、关于数据的使用

数据库查询后返回的结果类型不是很清楚，不知道返回的是一维数组还是二维数组，在遍历的时候遇到了很大的问题

3、关于单条记录查询

想查到一个指定记录不知道用什么办法，感觉用的是最LOW的查询办法

4、关于URL跳转

超级链接，网页跳来跳去的，一会儿就把自己搞晕了，不知道有什么好的办法

Correcting teacher：天蓬老师天蓬老师

Correction status：qualified

Teacher's comments：你这个作业,提交的有点晚了, 不过还算是完成了
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post