Help with table data

[james182]

I am trying to get this array to present it as a timetable. i need to get the data to display right, i can get the data to display but if you have more than one event on the same day it breaks and if no event is on it should show an empty cell, they don't show up.

Sample Data

 [CODE]Array
(
[0] => stdClass Object
    (
        [class_id] => 1
        [class_name] => Fit Box
        [class_description] => Fitbox is a high energy aerobic workout utilizing focus pads, kick pads, heavy bags, and speed balls. This class increases muscle strength and cardiovascular fitness and also includes strength and endurance circuit style training. Excellent for co-ordination, reflexes and to pump out the adrenalin!  The class is 1 hour in duration.
        [class_time] => 06:00:00
        [class_day] => Tuesday
        [class_status] => active
        [class_colour] => Blue
    )

[1] => stdClass Object
    (
        [class_id] => 2
        [class_name] => Hot Boxing
        [class_description] => test description
        [class_time] => 08:00:00
        [class_day] => Wednesday
        [class_status] => active
        [class_colour] => grey
    )

[2] => stdClass Object
    (
        [class_id] => 3
        [class_name] => Punch Face
        [class_description] => test again
        [class_time] => 07:00:00
        [class_day] => Thursday
        [class_status] => active
        [class_colour] => grey
    )

[3] => stdClass Object
    (
        [class_id] => 4
        [class_name] => MOS
        [class_description] => test again
        [class_time] => 07:00:00
        [class_day] => Thursday
        [class_status] => active
        [class_colour] => grey
    )

)[/CODE]

[code=php]$output = '<table class="calendar">';
		$output .= '<thead>
						<tr>
							<th colspan="8">Classes</th>
						</tr>
						<tr>
							<th class="day"></th>
							<th class="day">Sunday</th>
							<th class="day">Monday</th>
							<th class="day">Tuesday</th>
							<th class="day">Wednesday</th>
							<th class="day">Thursday</th>
							<th class="day">Friday</th>
							<th class="day">Saturday</th>
						</tr>
					</thead>';

					print_r($timetable_classes);

					foreach($timetable_times as $k => $h)
					{
						//start the row
					  	$output .= '<tr><td>'.format_time($h['time']).'</td>';

						//now loop through your array and check hour and day, and display
					    foreach($timetable_classes as $a)
					    {						    	
					    	if($a->class_time === $h['time'])
					    	{
						        if($a->class_day === "Sunday"){
						        	$output .= '<td>'.$a->class_name.'</td>';
						        }else {
						        	$output .= '<td></td>';
						        }

						        if($a->class_day === "Monday"){
						        	$output .= '<td>'.$a->class_name.'</td>';
						        }else {
						        	$output .= '<td></td>';
						        }

						        if($a->class_day === "Tuesday"){
						        	$output .= '<td>'.$a->class_name.'</td>';
						        }else {
						        	$output .= '<td></td>';
						        }

						        if($a->class_day === "Wednesday"){
						        	$output .= '<td>'.$a->class_name.'</td>';
						        }else {
						        	$output .= '<td></td>';
						        }

						        if($a->class_day === "Thursday"){
						        	$output .= '<td>'.$a->class_name.'</td>';
						        }else {
						        	$output .= '<td></td>';
						        }

						        if($a->class_day === "Friday"){
						        	$output .= '<td>'.$a->class_name.'</td>';
						        }else {
						        	$output .= '<td></td>';
						        }

						        if($a->class_day === "Saturday"){
						        	$output .= '<td>'.$a->class_name.'</td>';
						        }else {
						        	$output .= '<td></td>';
						        } 

						        // if there are not event on create blank cell
						        if(empty($a->class_day)){							        	
						        	$output .= '<td></td>';
						        }  
					      	}
					    }
					   $output .= '</tr>';
					 }

		$output .= '</table>';

		return $output;[/code]

[dalecosp]

james182;11031019 wrote:

I am trying to get this array to present it as a timetable. i need to get the data to display right, i can get the data to display but if you have more than one event on the same day it breaks

Your loop only checks one object from the array before closing the table cell.

and if no event is on it should show an empty cell, they don't show up.

You're checking for an empty property on objects that all have this property. It sounds like you actually want to present a calendar. If you want to present all days whether they have a class scheduled or not, you need to loop through the dates instead of looping through the events.

HTH,

[james182]

Ok so i have been playing around and almost have but just need some help to get it done. I get the table to work but, can't get the events to show correctly.

I have provided my array and code.

$arr = array(
					             //"days" => array("Sunday","Monday", "Tuesday", "Wednesday", "Thursday", "Friday","Saturday"),
					             "06:00:00" => array(
									             	"Sunday" => array(
									             					array(
										             					'event_title' => "item_1",
										             					'event_desc' => "item_1",
										             					'event_link' => "item_1",
										             					),
									             					),  

									             	"Monday" => array(
									             					array(
										             					'event_title' => "item_1",
										             					'event_desc' => "item_1",
										             					'event_link' => "item_1",
										             					),									             					
									             					array(
										             					'event_title' => "item_1",
										             					'event_desc' => "item_1",
										             					'event_link' => "item_1",
										             					),
									             					), 
									             	"Tuesday" => "", 
									             	"Wednesday" => "", 
									             	"Thursday" => "", 
									             	"Friday" => "", 
									             	"Saturday" => ""
					             					),
					             "07:00:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""),
					             "08:00:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""),
					             "09:30:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""),
					             "17:00:00" => array("Sunday" => "", "Monday" => "", "Tuesday" => "", "Wednesday" => "", "Thursday" => "", "Friday" => "", "Saturday" => ""),
					             );

				   //print_r($arr);

				   foreach($arr as $time => $value)
				   {
				      //print_r($value);
				      $output .= '<tr>';
				      $output .= '<td class="closed"><span class="day">'. format_time($time) .'</span></td>';

				      /* and the days */					      
				      foreach($value as $day => $event)
				      {
				        //print_r($event);
				        $output .= '<td>';
				        foreach($event as $v){ // Warning: Invalid argument supplied for foreach()
				        	$output .= '<span>'. $v['event_title'] .'</span>';
				        }
				        $output .= '</td>';

				      }
				      $output .= '</tr>';

				   }