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 抖音咸鱼付款链接转码支付宝
  • ¥15 ubuntu22.04上安装ursim-3.15.8.106339遇到的问题
  • ¥15 求螺旋焊缝的图像处理
  • ¥15 blast算法(相关搜索:数据库)
  • ¥15 请问有人会紧聚焦相关的matlab知识嘛?
  • ¥15 网络通信安全解决方案
  • ¥50 yalmip+Gurobi
  • ¥20 win10修改放大文本以及缩放与布局后蓝屏无法正常进入桌面
  • ¥15 itunes恢复数据最后一步发生错误
  • ¥15 关于#windows#的问题:2024年5月15日的win11更新后资源管理器没有地址栏了顶部的地址栏和文件搜索都消失了