My csv file has 3 columns for time, events, and location. I loaded each column into a separate array. Using a for loop, I displayed the arrays as an html table. However, it is not showing up. Why?
EventsScheduleFriday.php
<?php
echo "<link rel='stylesheet' type='text/css' href='../styles/styles.css' />";
$time = array();
$events = array();
$location = array();
function get_data(&$time, &$events, &$location) { //references variable declared above
$file = fopen(__DIR__."/../data/EventsScheduleFriday.csv", "r");
while(!feof($file)) { //while end of file has not been reached
$content = fgetcsv($file, ","); //converts first line of csv to an array
array_push($time, $content[0]);
array_push($events, $content[1]);
array_push($location, $content[2]);
}
fclose($file); //closes csv file
}
// put the data on the screen in readable form
function display_table(&$time, &$events, &$location) {
echo "<table class='tg'>";
for($i = 0; $i < count($time); $i++) {
echo "<tr>
";
if ($i == 0){ //create table header cell
echo "<th>";
$time[$i];
echo "</th>
";
echo "<th>";
$events[$i];
echo "</th>
";
}
else {
echo "<td class='cell-time'>";
$time[$i];
echo "</td>
";
echo "<td class='cell-descript'>";
$events[$i];
echo "<br class = 'space'>";
echo "<div class = 'table_description'>";
echo "Location: " + $location[$i];
echo "</div></td>
";
}
echo "</tr>
";
}
echo "
</table>";
}
get_data($time, $events, $location);
display_table($time, $events, $location);
?>
EventsScheduleFriday.csv
Time,Event,Location,
12:30pm,Hilby The Skinny German Juggle Boy,West State Street,
4:45pm,Hilby The Skinny German Juggle Boy,West State Street,
6pm,Finger Lakes Comedy Festival Competition 1st Round (Age 21+),Lot 10,
8pm,Stand-up Comedy Show,Acting Out NY,
10pm,All-Star Comedy Show,Acting Out NY
events.php
<div class = "schedule">
<?php include "scripts/EventsScheduleFriday.php" ?>
</div>