RError.com

RError.com Logo RError.com Logo

RError.com Navigation

  • 主页

Mobile menu

Close
  • 主页
  • 系统&网络
    • 热门问题
    • 最新问题
    • 标签
  • Ubuntu
    • 热门问题
    • 最新问题
    • 标签
  • 帮助
主页 / 问题 / 1307158
Accepted
Moonwolf45
Moonwolf45
Asked:2022-07-21 00:47:11 +0000 UTC2022-07-21 00:47:11 +0000 UTC 2022-07-21 00:47:11 +0000 UTC

PHP 使用 json

  • 772

一般来说,使用yii2的动态表单和多字段扩展,我将数据集存储在mysql中的json字段中,我为站点编写了一个api,我显示了所有这些东西,我格式化了数组,并尝试返回它,但是我有同样的 json 字符串,看起来像这样:

[
    {
        "hour": "14", 
        "minutes": [
            {"minute": "00", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "10", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "20", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "30", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "40", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "50", "count_ticket": 1, "count_ticket_left": 1}
        ], 
        "price_stud": "1", 
        "price_adults": "1", 
        "tickets_left": "6", 
        "count_tickets": "6", 
        "price_children": "1"
    }, {
        "hour": "15", 
        "minutes": [
            {"minute": "00", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "10", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "20", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "30", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "40", "count_ticket": 1, "count_ticket_left": 1}, 
            {"minute": "50", "count_ticket": 1, "count_ticket_left": 1}
        ], 
        "price_stud": "1", 
        "price_adults": "1", 
        "tickets_left": "6", 
        "count_tickets": "6", 
        "price_children": "1"
    }
]

一般来说,什么可以更简单,但由于某种原因,我被困在这一点上,我正试图像这样获得这个奇迹:

foreach ($scheduleTickets as $ticket) {
    $new_date_ticket = new DateTime($ticket['date']);
    $norm_date = $new_date_ticket->format('d.m.Y');
    if ((int)$ticket['status'] == Tickets::STATUS_ON) {
        $allowTickets[$norm_date] = [];
        $allowTickets[$norm_date]['tickets'] = (int)$ticket['tickets_left'];
        $allowTickets[$norm_date]['hours'] = [];
        if ((int)$ticket['tickets_left'] > 0) {
            $i = 0;
            Yii::info($ticket);
            Yii::info($ticket['schedule_minute']);
            foreach ($ticket['schedule_minute'] as $time_hour) {
                Yii::info($time_hour);
                $allowTickets[$norm_date]['hours'][$i]['value'] = (int)$time_hour->hour;
                $allowTickets[$norm_date]['hours'][$i]['label'] = (string)$time_hour->hour;
                $allowTickets[$norm_date]['hours'][$i]['tickets'] = $time_hour->tickets_left;
                $allowTickets[$norm_date]['hours'][$i]['price_children'] = $time_hour->price_children;
                $allowTickets[$norm_date]['hours'][$i]['price_stud'] = $time_hour->price_stud;
                $allowTickets[$norm_date]['hours'][$i]['price_adults'] = $time_hour->price_adults;
                $allowTickets[$norm_date]['hours'][$i]['minutes'] = [];
                if ((int)$time_hour->tickets_left > 0) {
                    $y = 0;
                    foreach ($time_hour['minutes'] as $time_minute) {
                        $allowTickets[$norm_date]['hours'][$i]['minutes'][$y]['value'] = (int)$time_minute->minute;
                        $allowTickets[$norm_date]['hours'][$i]['minutes'][$y]['label'] = (string)$time_minute->minute;
                        $allowTickets[$norm_date]['hours'][$i]['minutes'][$y]['tickets'] = $time_minute->count_ticket_left;
                        $y++;
                    }
                }
                $i++;
            }
        }
    }
}

一般来说,我需要你的帮助,如何访问这些数据?

php
  • 1 1 个回答
  • 10 Views

1 个回答

  • Voted
  1. Best Answer
    Moonwolf45
    2022-07-21T01:06:11Z2022-07-21T01:06:11Z

    我发现了一个错误,一切都很简单,总的来说,这是工作代码:

    foreach ($scheduleTickets as $ticket) {
        $new_date_ticket = new DateTime($ticket['date']);
        $norm_date = $new_date_ticket->format('d.m.Y');
        if ((int)$ticket['status'] == Tickets::STATUS_ON) {
            $allowTickets[$norm_date] = [];
            $allowTickets[$norm_date]['tickets'] = (int)$ticket['tickets_left'];
            $allowTickets[$norm_date]['hours'] = [];
            if ((int)$ticket['tickets_left'] > 0) {
                $hours = json_decode($ticket['schedule_minute']);
                for ($h = 0; $h < count($hours); $h++) {
                    $allowTickets[$norm_date]['hours'][$h]['value'] = (int)$hours[$h]->hour;
                    $allowTickets[$norm_date]['hours'][$h]['label'] = (string)$hours[$h]->hour;
                    $allowTickets[$norm_date]['hours'][$h]['tickets'] = $hours[$h]->tickets_left;
                    $allowTickets[$norm_date]['hours'][$h]['price_children'] = $hours[$h]->price_children;
                    $allowTickets[$norm_date]['hours'][$h]['price_stud'] = $hours[$h]->price_stud;
                    $allowTickets[$norm_date]['hours'][$h]['price_adults'] = $hours[$h]->price_adults;
                    $allowTickets[$norm_date]['hours'][$h]['minutes'] = [];
                    if ((int)$hours[$h]->tickets_left > 0) {
                        $minutes = $hours[$h]->minutes;
                        for ($m = 0; $m < count($minutes); $m++) {
                            $allowTickets[$norm_date]['hours'][$h]['minutes'][$m]['value'] = (int)$minutes[$m]->minute;
                            $allowTickets[$norm_date]['hours'][$h]['minutes'][$m]['label'] = (string)$minutes[$m]->minute;
                            $allowTickets[$norm_date]['hours'][$h]['minutes'][$m]['tickets'] = $minutes[$m]->count_ticket_left;
                        }
                    }
                }
            }
        }
    }
    
    • 0

相关问题

  • mysqli 类的对象无法转换为字符串

  • 您的系统中缺少 ext-http *,您的系统中缺少 ext-mysql_xdevapi *

  • 如何从csv中删除bom?

  • 当我按下 Enter 键时,如何让 PhpStorm 的 Emmet 插件触发,就像 VS Code 一样?

  • 注释在 Symfony5 中不起作用

  • 搜索最近的地理位置点

Sidebar

Stats

  • 问题 10021
  • Answers 30001
  • 最佳答案 8000
  • 用户 6900
  • 常问
  • 回答
  • Marko Smith

    表格填充不起作用

    • 2 个回答
  • Marko Smith

    提示 50/50,有两个,其中一个是正确的

    • 1 个回答
  • Marko Smith

    在 PyQt5 中停止进程

    • 1 个回答
  • Marko Smith

    我的脚本不工作

    • 1 个回答
  • Marko Smith

    在文本文件中写入和读取列表

    • 2 个回答
  • Marko Smith

    如何像屏幕截图中那样并排排列这些块?

    • 1 个回答
  • Marko Smith

    确定文本文件中每一行的字符数

    • 2 个回答
  • Marko Smith

    将接口对象传递给 JAVA 构造函数

    • 1 个回答
  • Marko Smith

    正确更新数据库中的数据

    • 1 个回答
  • Marko Smith

    Python解析不是css

    • 1 个回答
  • Martin Hope
    Alexandr_TT 2020年新年大赛! 2020-12-20 18:20:21 +0000 UTC
  • Martin Hope
    Alexandr_TT 圣诞树动画 2020-12-23 00:38:08 +0000 UTC
  • Martin Hope
    Air 究竟是什么标识了网站访问者? 2020-11-03 15:49:20 +0000 UTC
  • Martin Hope
    Qwertiy 号码显示 9223372036854775807 2020-07-11 18:16:49 +0000 UTC
  • Martin Hope
    user216109 如何为黑客设下陷阱,或充分击退攻击? 2020-05-10 02:22:52 +0000 UTC
  • Martin Hope
    Qwertiy 并变成3个无穷大 2020-11-06 07:15:57 +0000 UTC
  • Martin Hope
    koks_rs 什么是样板代码? 2020-10-27 15:43:19 +0000 UTC
  • Martin Hope
    Sirop4ik 向 git 提交发布的正确方法是什么? 2020-10-05 00:02:00 +0000 UTC
  • Martin Hope
    faoxis 为什么在这么多示例中函数都称为 foo? 2020-08-15 04:42:49 +0000 UTC
  • Martin Hope
    Pavel Mayorov 如何从事件或回调函数中返回值?或者至少等他们完成。 2020-08-11 16:49:28 +0000 UTC

热门标签

javascript python java php c# c++ html android jquery mysql

Explore

  • 主页
  • 问题
    • 热门问题
    • 最新问题
  • 标签
  • 帮助

Footer

RError.com

关于我们

  • 关于我们
  • 联系我们

Legal Stuff

  • Privacy Policy

帮助

© 2023 RError.com All Rights Reserve   沪ICP备12040472号-5