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!