微信公众号 讲师中心
首页
文章
后端开发 web前端 数据库 开发工具 php框架 常见问题 科技 Java 系统教程 电脑教程 硬件教程 手机教程 软件教程 游戏教程 自媒体 新闻
专题
后端开发 web前端 数据库 开发工具 php框架 科技 Java 系统教程 电脑教程 硬件教程 手机教程 软件教程 游戏教程 新闻
AI工具
AI 聊天问答 Agent智能体 AI 文本写作 AI 绘画作图 AI 设计工具 AI 视频创作 AI 音频制作 AI 办公学习 AI 编程开发 Prompt指令
学习
大前端 后端开发 数据库 移动端 运维开发 计算机基础
编程手册
大前端 后端开发 数据库 移动端 运维开发 计算机基础
下载
js特效 网站源码 工具下载 类库下载 网站素材 学习资源 插件扩展 手机/移动开发 手机游戏
搜索
后端开发 web前端 数据库 开发工具 php框架 常见问题 科技 Java 系统教程 电脑教程 硬件教程 手机教程 软件教程 游戏教程
自媒体 新闻
首页 > 博客列表 > 12月-前端大作业-PHP培训线上九期班
博主信息
博文 53
粉丝 3
评论 0
访问量 66961
专题推荐
更多>
相关推荐
热门教程
更多>
相关教程
热门推荐
最新课程
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
12月-前端大作业-PHP培训线上九期班
邯郸易住宋至刚
原创
1169人浏览过

一、项目分析

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

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

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

批改老师：天蓬老师天蓬老师

批改状态：合格

老师批语：你这个作业,提交的有点晚了, 不过还算是完成了
本博文版权归博主所有，转载请注明地址！如有侵权、违法，请联系admin@php.cn举报处理！
全部评论 文明上网理性发言，请遵守新闻评论服务协议
0条评论
作者最新博文
关于我们 免责申明 举报中心 意见反馈 讲师合作 广告合作 最新更新 English
php中文网：公益在线php培训，帮助PHP学习者快速成长！
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号

  • PHP学习

  • 技术支持

  • 返回顶部
    • 登录PHP中文网，和优秀的人一起学习！
    全站2000+教程免费学
    微信扫码登录