利用mysql查询总数据条数,再php处理数据转出数组,生成随机返回到页面,可以做成刷新页面,出现不同的内容

复制代码
复制代码
复制代码
复制代码
复制代码
复制代码
复制代码
复制代码

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
create table hxfimported(
   pid int primary key auto_increment,
   pic varchar(64),
   pname varchar(32),
   price float(10,2)
);
insert into hxfimported values
(null,"img/imported-6.jpg","越南白心火龙果 ","41.9"),
(null,"img/imported-1.jpg","泰国金枕头榴莲","118.0"),
(null,"img/imported-3.jpg","澳洲混合桉树蜂蜜","99.0"),
(null,"img/imported-4.jpg","马来西亚白咖啡","65.00"),
(null,"img/imported-2.jpg","爱伦蒂全脂纯牛奶","65.00"),
(null,"img/imported-39.jpg","西班牙特级橄榄油","65.00"),
(null,"img/imported-12.jpg","越南白心火龙果 ","41.9"),
(null,"img/imported-13.jpg","马来西亚白咖啡 ","41.9"),
(null,"img/imported-19.jpg","澳洲混合桉树蜂蜜 ","41.9"),
(null,"img/imported-7.jpg","泰国金枕头榴莲 ","41.9"),
(null,"img/imported-3.jpg","越南白心火龙果 ","41.9"),
(null,"img/imported-15.jpg","爱伦蒂全脂纯牛奶 ","41.9"),
(null,"img/imported-2.jpg","西班牙特级橄榄油 ","41.9"),
(null,"img/imported-17.jpg","越南白心火龙果 ","41.9");<?php
      $conn=mysqli_connect("127.0.0.1","root","","hxf");
      $sql="set names utf8";
      mysqli_query($conn,$sql);
      $sql="select count(1) as number from hxfimported";
      $result=mysqli_query($conn,$sql);
      $data = mysqli_fetch_array($result);
      $count = $data['number'];
      $len=rand(0,$count-6);
      $sql="select pic,pname,price from hxfimported limit $len,6";
      $result=mysqli_query($conn,$sql);
      $list=array();
      if($result==false){
         echo "$len";
      }else{
           while(($row=mysqli_fetch_assoc($result))!=null){
           $list[]=$row;
        }
      }
       echo json_encode($list);
 
?><div class="imported-food common">
            <div class="weui-panel weui-panel_access">
                <a href="importedFoods.html">
                    <div class="weui-panel__hd"><p class="item-title">进口食品<span class="weui-cell-ft"></span></p></div>
                    <div class="weui-panel__bd">
                        <div class="weui-media-box weui-media-box_text">
                            <p class="weui-media-box__desc"><img src="img/imported-food-header.jpg" alt="" /></p>
                        </div>
                    </div>
               </a>
               <div class="weui-grids">
 
                </div>
            </div>
        </div>$.getJSON("hxfimported.php",{},function(data){
                var _html="";
                $.each(data,function(i,item){
                    _html+=`<a href="local-${i+1}.html" class="weui-grid">
                        <div class="weui-grid__icon">
                            <img src="${item.pic}" alt="">
                        </div>
                        <p class="weui-grid__label">${item.pname}</p>
                        <p class="weui-grid__price">¥${item.price}</p>
                    </a>`
                })
                $('.imported-food .weui-grids').append(_html);
            });
posted @   li_han  阅读(911)  评论(0编辑  收藏  举报
编辑推荐:
· DeepSeek 解答了困扰我五年的技术问题
· 为什么说在企业级应用开发中,后端往往是效率杀手?
· 用 C# 插值字符串处理器写一个 sscanf
· Java 中堆内存和栈内存上的数据分布和特点
· 开发中对象命名的一点思考
阅读排行:
· DeepSeek 解答了困扰我五年的技术问题。时代确实变了!
· PPT革命!DeepSeek+Kimi=N小时工作5分钟完成?
· What?废柴, 还在本地部署DeepSeek吗?Are you kidding?
· 赶AI大潮:在VSCode中使用DeepSeek及近百种模型的极简方法
· DeepSeek企业级部署实战指南:从服务器选型到Dify私有化落地
点击右上角即可分享
微信分享提示