douzongmu2543 2015-08-06 15:37
浏览 90
已采纳

将数据推送到php 5.3 vs 5.5中的数组

I'm a stumped with this problem. I'm getting no error messages. My code works when I test locally (php 5.5). The server my company uses is php 5.3.3. My code does not work on the server. When I do a var_dump I get an empty array. Locally my array populates with data from my SQL db.

Here is my code. I think my syntax is correct, but at this point I'm not sure.

<?php

$sql = "SELECT * FROM $table";
$get_result = $db->query($sql);

$events = array();

foreach ($get_result as $row) {
    echo $row['event'] . '<br>';

    $date = $row['d1'];
    $ymd = date('Y-m-d', strtotime($date));

    $date2 = $row['d2'];
    $ymd2 = date('Y-m-d', strtotime($date2));

    $date3 = $row['d3'];
    $ymd3 = date('Y-m-d', strtotime($date3));

    $date4 = $row['d4'];
    $ymd4 = date('Y-m-d', strtotime($date4));

    $date5 = $row['d5'];
    $ymd5 = date('Y-m-d', strtotime($date5));
    if ($row['approved'] == 'yes') {
        if ($row['d1'] != '0000-00-00') {
            $events[] = array('id' => '' . $row['id'] . '',
                'date' => '' . $ymd . ' ' . $row['start'] . '',
                'title' => '' . $row['event'] . '',
                'description' => '' . $row['descrip'] . '',
                'startTime' => '' . $row['start'] . '',
                'endTime' => '' . $row['end'] . '',
                'url' => 'event_details.html?id=' . $row['id'] . '&data=events',
                'location' => '' . $row['addy1'] . ' ' . $row['addy2'] . ' ' . $row['addy3'] . ' ' . $row['city'] . ' ' . $row['state'] . ' ' . $row['zip'] . '',
                'eventUrl' => '' . $row['event_url'] . '',
                'subName' => '' . $row['subName'] . '',
                'subEmail' => '' . $row['subEmail'],
            );
        }
        if ($row['d2'] != '0000-00-00') {
            $events[] = array('id' => '' . $row['id'] . '',
                'date' => '' . $ymd2 . ' ' . $row['start'] . '',
                'title' => '' . $row['event'] . '',
                'description' => '' . $row['descrip'] . '',
                'startTime' => '' . $row['start'] . '',
                'endTime' => '' . $row['end'] . '',
                'url' => 'event_details.html?id=' . $row['id'] . '&data=events',
                'location' => '' . $row['addy1'] . ' ' . $row['addy2'] . ' ' . $row['addy3'] . ' ' . $row['city'] . ' ' . $row['state'] . ' ' . $row['zip'] . '',
                'eventUrl' => '' . $row['event_url'] . '',
                'subName' => '' . $row['subName'] . '',
                'subEmail' => '' . $row['subEmail'],
            );
        }
        if ($row['d3'] != '0000-00-00') {
            $events[] = array('id' => '' . $row['id'] . '',
                'date' => '' . $ymd3 . ' ' . $row['start'] . '',
                'title' => '' . $row['event'] . '',
                'description' => '' . $row['descrip'] . '',
                'startTime' => '' . $row['start'] . '',
                'endTime' => '' . $row['end'] . '',
                'url' => 'event_details.html?id=' . $row['id'] . '&data=events',
                'location' => '' . $row['addy1'] . ' ' . $row['addy2'] . ' ' . $row['addy3'] . ' ' . $row['city'] . ' ' . $row['state'] . ' ' . $row['zip'] . '',
                'eventUrl' => '' . $row['event_url'] . '',
                'subName' => '' . $row['subName'] . '',
                'subEmail' => '' . $row['subEmail'],
            );
        }
        if ($row['d4'] != '0000-00-00') {
            $events[] = array('id' => '' . $row['id'] . '',
                'date' => '' . $ymd4 . ' ' . $row['start'] . '',
                'title' => '' . $row['event'] . '',
                'description' => '' . $row['descrip'] . '',
                'startTime' => '' . $row['start'] . '',
                'endTime' => '' . $row['end'] . '',
                'url' => 'event_details.html?id=' . $row['id'] . '&data=events',
                'location' => '' . $row['addy1'] . ' ' . $row['addy2'] . ' ' . $row['addy3'] . ' ' . $row['city'] . ' ' . $row['state'] . ' ' . $row['zip'] . '',
                'eventUrl' => '' . $row['event_url'] . '',
                'subName' => '' . $row['subName'] . '',
                'subEmail' => '' . $row['subEmail'],
            );
        }
        if ($row['d5'] != '0000-00-00') {
            $events[] = array('id' => '' . $row['id'] . '',
                'date' => '' . $ymd5 . ' ' . $row['start'] . '',
                'title' => '' . $row['event'] . '',
                'description' => '' . $row['descrip'] . '',
                'startTime' => '' . $row['start'] . '',
                'endTime' => '' . $row['end'] . '',
                'url' => 'event_details.html?id=' . $row['id'] . '&data=events',
                'location' => '' . $row['addy1'] . ' ' . $row['addy2'] . ' ' . $row['addy3'] . ' ' . $row['city'] . ' ' . $row['state'] . ' ' . $row['zip'] . '',
                'eventUrl' => '' . $row['event_url'] . '',
                'subName' => '' . $row['subName'] . '',
                'subEmail' => '' . $row['subEmail'],
            );
        }
    }
}

var_dump($events);

Thoughts? Thanks for any insight you can provide!

  • 写回答

1条回答 默认 最新

  • dongzhang6021 2015-08-06 17:36
    关注

    This issue wasn't with syntax, though it did deal with different versions of PHP. JSON_PRETTY_PRINT was the culprit. Apparently is not compliant with PHP versions earlier then 5.4. Removing that seems to have solved the problem.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 outlook无法配置成功
  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题