在PHP中获取JSON值

Here I have store the doctor schedule in HTML table with following JSON format. It successfully store like following in the database:

[{"monday_start":"09.00 A.M","monday_end":"10.00 A.M"},{"tuesday_start":"10.00 A.M","tuesday_end":"11.00 A.M"},{"wednesday_start":"Select Date","wednesday_end":"Select Date"},{"thursday_start":"Select Date","thursday_end":"Select Date"},{"friday_start":"Select Date","friday_end":"Select Date"},{"saturday_start":"Select Date","saturday_end":"Select Date"},{"sunday_start":"Select Date","sunday_end":"Select Date"}]

Here is the HTML code:

<table class="table table-striped mb-0">
            <thead>
                <tr>
                    <th>Days</th>
                    <th>Time (From)</th>
                    <th>Time (To)</th>
                </tr>
            </thead>
            <tbody id="rows">
                <tr>
                    <td>MonDay</td>
                    <td>
                            <div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="mon_start" name="mon_start">
                                   <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div>
                   </td>
                    <td>      <div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="mon_end" name="mon_end">
                                    <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div>
                    </td>
                </tr>
                <tr>
                        <td>TuesDay</td>
                        <td>     
                               <div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="tues_start" name="tues_start">
                                   <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div>
                    </td>
                     <td>      
                           <div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="tues_end" name="tues_end">
                                    <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div>
                   </td>
                    </tr>
                    <tr>
                        <td>WednesDay</td>
                                 <td> 
                             <div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="wed_start" name="wed_start">
                                 <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div>
                        </td>
                        <td>     
                              <div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="wed_end" name="wed_end">
                                   <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div>
                            </td>
                    </tr>
                   <tr>
                                            <td>ThursDay</td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="thur_start" name="thur_start">
                                   <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="thur_end" name="thur_end">
                                     <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                        </tr>
                                        <tr>
                                            <td>FriDay</td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="fri_start" name="fri_start">
                                   <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="fri_end" name="fri_end">
                                       <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                        </tr>
                                        <tr>
                                            <td>SaturDay</td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="sat_start" name="sat_start">
                                  <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="sat_end" name="sat_end">
                                       <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                        </tr>
                                        <tr>
                                            <td>SunDay</td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="sun_start" name="sun_start">
                                      <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                            <td><div class="col-md-12">
                                <div class="form-group"> 
                                    <select class="select" id="sun_end" name="sun_end">
                                        <option value="Select Date">Select</option>  
                                        <option value="09.00 A.M">09.00 A.M</option> 
                                        <option value="10.00 A.M">10.00 A.M</option>  
                                        <option value="11.00 A.M">11.00 A.M</option>
                                        <option value="12.00 P.M">12.00 P.M</option>                          
                                        <option value="Not Available">Not Available</option>

                                    </select>
                                </div>
                            </div></td>
                                        </tr>
                                    </tbody>
                                </table>

Here is the Ajax call to send data to addschedule.php page:

<script>

      // save comment to database
            $(document).on('click', '#schedule', function () {

                var modess = $('#rows tr').map(function() {
                let $tr = $(this);

                return [ { 

               "monday_start": $(this).find('#mon_start').val(),
               "monday_end": $(this).find('#mon_end').val(),
               "tuesday_start":$(this).find('#tues_start').val(),
               "tuesday_end":$(this).find('#tues_end').val(),
               "wednesday_start":$(this).find('#wed_start').val(),
               "wednesday_end":$(this).find('#wed_end').val(),
               "thursday_start": $(this).find('#thur_start').val(),
               "thursday_end": $(this).find('#thur_end').val(),
               "friday_start": $(this).find('#fri_start').val(),
               "friday_end": $(this).find('#fri_end').val(),
               "saturday_start": $(this).find('#sat_start').val(),
               "saturday_end": $(this).find('#sat_end').val(),
               "sunday_start": $(this).find('#sun_start').val(),
               "sunday_end": $(this).find('#sun_end').val(),
                 } ]
                 console.log(modess);
                       });

              var timetable = JSON.stringify( $.makeArray(modess) );
                    $.ajax({
                        url: "adminquery/addschedule.php", // Url to which the request is send
                        method: "POST",             // Type of request to be send, called as method
                        data:{ index1: timetable, 
                       },            
                    cache: false,

                        success: function (response) {
                            $('#success_mes').fadeIn().html(response);

                            $("success_mes").fadeIn().html(response);
                            setTimeout(function () {
                                $('#success_mes').fadeOut("Slow");
                            }, 2000);

                        }

                    });

});

</script>

In my fetching page I coded like this to retrieve the data:

    <table class="table table-hover mb-0">
                                        <thead>
                                            <tr>
                                                <th>Day</th>
                                                <th>Time (From)</th>
                                                <th>Time (To)</th>
                                            </tr>
                                        </thead>
                                        <tbody>

                                        <?php 

                     $stmt = $conn->prepare("SELECT * FROM schedule WHERE user_id=? ");
                     $stmt->bind_param("s", $_GET['userid']);
                     $stmt->execute();
                     $result = $stmt->get_result();
                     if($result->num_rows === 0)  exit('No rows');
                     while($row = $result->fetch_assoc()) {

                     $times = json_decode($row['available_days'],true);
                     if (is_array($times) || is_object($times)) {

                     foreach($times as $key => $object) {

                           ?>


                                            <tr>
                                                <td>Monday</td>
                                                <td><?php echo   $object['monday_start']; ?></td>
                                                <td><?php echo  $object['monday_end']; ?></td>
                                            </tr>

                                            <tr>
                                                <td>tuesday</td>
                                                <td><?php echo   $object['tuesday_start']; ?></td>
                                                <td><?php echo  $object['tuesday_end']; ?></td>
                                            </tr>
                                            <tr>
                                                <td>wednesday</td>
                                                <td><?php echo   $object['wednesday_start']; ?></td>
                                                <td><?php echo  $object['wednesday_end']; ?></td>
                                            </tr>
                                            <tr>
                                                <td>thursday</td>
                                                <td><?php echo   $object['thursday_start']; ?></td>
                                                <td><?php echo  $object['thursday_end']; ?></td>
                                            </tr>
                                            <tr>
                                                <td>friday</td>
                                                <td><?php echo   $object['friday_start']; ?></td>
                                                <td><?php echo  $object['friday_end']; ?></td>
                                            </tr>
                                            <tr>
                                                <td>saturday</td>
                                                <td><?php echo   $object['saturday_start']; ?></td>
                                                <td><?php echo  $object['saturday_end']; ?></td>
                                            </tr>
                                            <tr>
                                                <td>sunday</td>
                                                <td><?php echo   $object['sunday_start']; ?></td>
                                                <td><?php echo  $object['sunday_end']; ?></td>
                                            </tr>



                                            <?php  } }   }

                                            ?>
                                        </tbody>



                                    </table>

Only first row shows the value, others shows the error showing like this: Notice: Undefined index: tuesday_start in C:\xampp\htdocs\Hospital\adminpanel\show_schedule.php on line 260Notice: Undefined index: tuesday_end in C:\xampp\htdocs\Hospital\adminpanel\show_schedule.php on line 261 for every following row.

Please help me.

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

撒拉嘿哟木头 2020-02-02 08:46

关注

The problem is here : foreach($times as $key => $object), you are looping over each day, but inside the loop you try to display the data for all days.

Here is a possible solution :

<?php 
$days = array('monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday', 'sunday'); // define all days to be displayed
foreach($days as $day)
{
   // retrieve current day data only
   // this will return the item that has a DAY_start key in it
   $dayData  = array_values(array_filter($times, function($d) use($day){return array_key_exists($day . '_start', $d);}))[0] ;
?>
<tr>
    <td><?php echo ucfirst($day); /* display the name of the day */?></td>
    <td><?php echo $dayData[$day . '_start']; /* display the current day start */?></td>
    <td><?php echo $dayData[$day . '_end']; /* display the current day end */?></td>
</tr>
<?php
}
?>

报告相同问题？

关注问题

在php中读取json输出 json php
2013-11-11 08:24

回答 4 已采纳 Your output is regular array not JSON, so you access it as regular PHP array: $x = $array['screen
我无法在PHP中获取JSON输出 json php
2016-01-08 17:20

回答 2 已采纳 Assuming this response is stored in a variable called $response, here are some examples of accessi
无法在javascript中读取Json_encode的键值对 javascript json php
2016-08-14 18:21

回答 1 已采纳 Add this as a first line in the HEAD section of your HTML template <meta content="text/html;ch
PHP读取mssql json数据中文乱码的解决办法
2020-10-22 14:01

PHP及网页使用UTF-8编码，数据库是sql server2008,使用默认编码，当读取数据库数据时，使用php自带的json_encode()返回到前端，结果中文不显示。下面脚本之家小编给大家介绍PHP读取mssql json数据中文乱码的解决办法...
PHP获取JSON POST数据 http json php
2016-10-18 12:48

回答 1 已采纳 The following is working for me now: $inputJSON = file_get_contents('php://input'); $input= json_
使用PHP从json数据中获取内容 json php
2015-06-03 14:43

回答 1 已采纳 Assume your data is stored in a variable called $a. echo json_decode($a[0], true)['html']; will
如何从多维json数组中获取值 json php
2015-12-10 22:30

回答 1 已采纳 use $amount_total = strval($callback_json->operations[0]->amount); because [ in json is
PHP处理前端传递的json字符串对象
2022-04-04 15:02

万猿丛中最秃的帅哥的博客前端处理的数据后端接收到的值使用json_decode函数将json字符串转化为数组 json_decode($post['data'],true)
浏览器从缓存中获取JSON文件 html javascript jquery php
2016-06-25 05:26

回答 4 已采纳 You can globally disable cache using this $(document).ready(function() { $.ajaxSetup({ cache:
如何在json中获取第二个数组？ javascript json php
2014-01-02 01:46

回答 2 已采纳 your script.php works fine. It give you json result something like [{"label":"laba","value":"val
从Json中获取数组？ json php
2015-11-22 08:32

回答 3 已采纳 You might have json as a string inside json. That's why after json_decode() you still have json in
php输出json中的某个值,提取文本（txt）中json数组中的某一项值
2021-04-10 11:51

前端猿妹的博客现在我需要将json里面的某一项值提取出来，提交给支付宝。我不知道该怎么操作我要取得是数组里的 PayDeclareAmount":0.0075 这个值请问大神们有什么思路？回复内容：1.项目和第三方平台做了对接，之前的技术人员将...
如何使用javascript从json数组中获取值？ ajax javascript jquery json php
2013-04-27 11:28

回答 3 已采纳 The drivers is not an array, it is an object, you use $.each to iterate through the object element
PHP 返回 JSON 给前端 - 白码博客白码博客
2021-10-28 01:45

thatcoders的博客一丶注意事项直接用json编码array可能会返回null,因为有中文 php5.2以上的版本才可以使用js端接收也是utf8编码二丶思路首先将array进行urlencode 然后将array转成json 最后将json进行urldecode三丶上代码 ...
前台获取php后台的json,前端怎么显示后台获取的json格式数据
2021-04-21 16:30

走来走去的F小姐的博客后端getdata.php代码如下：
没有解决我的问题, 去提问

悬赏问题

¥15 Python时间序列如何拟合疏系数模型
¥15 求学软件的前人们指明方向🥺
¥50 如何增强飞上天的树莓派的热点信号强度，以使得笔记本可以在地面实现远程桌面连接
¥15 MCNP里如何定义多个源？
¥20 双层网络上信息-疾病传播
¥50 paddlepaddle pinn
¥20 idea运行测试代码报错问题
¥15 网络监控：网络故障告警通知
¥15 django项目运行报编码错误
¥15 STM32驱动继电器

码龄粉丝数原力等级 --

在PHP中获取JSON值

1条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

在PHP中获取JSON值

1条回答 默认 最新

悬赏问题

1条回答默认最新