简体中文（ZH-CN）English（EN）繁体中文（ZH-TW）日本語（JA）한국어（KO）Melayu（MS）Français（FR）Deutsch（DE）
Home
Article
Q&A
Course
Topic
Download
Game
Dictionary
Recent Updates

博客列表 >12月-前端大作业-PHP培训线上九期班

12月-前端大作业-PHP培训线上九期班

邯郸易住宋至刚
邯郸易住宋至刚原创
2019年12月22日 00:11:38932浏览

一、项目分析

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

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跳转

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

上一条：JS/Jquery第课 定义函数，继续数组讲解 12月17号作业下一条：前端第十七课：javascript基础6-PHP培训九期线上班
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多