counts for days of week

[geraldjr30]

hi,

i am very new to php. started learning 3 days ago. i have figured out how to list MS Access table output in table format in PHP. but i need to know how i can have some output like following, based on a table with detail data. Days of the week Monday through sunday are across the top. i want the counts for each day listed for each shift.


shift1
shift2
shift3


can someone give me example. like a small example that i can get running with? i want to know how i can list the counts across the page for each day of the week, for each shift.


thanks in advance,
geebee

[Dormilich]

that depends on your data and how you access them. I can't tell anything without it, so maybe a representative snippet will help understanding.

further, what do you want to count?

regards

[geraldjr30]

i am just getting the counts of records in the table that have a value corresponding to the day of the week in the [DY] column.

i have the following:

<?php
$test = array('sunday count','monday count','tuesday count','wednesday count','thursday count','friday count', 'saturday count');
$day=date('w'); //Numeric representation of the day of the week  0 (for Sunday) through 6 (for Saturday)
$key=each($test);
while ($key['key']!=$day)
    $key=each($test);
prev($test);
prev($test);
for ($i=0;$i<7;$i++)
{
    $count = (next($test)) ? current($test) : reset($test);
    echo $count.'<br />';
}
?>

this simply lists the days of the week. and the first day is automatically set to today. but what i want is for the days of the week to be listed across the top. and for the shifts 1 2 and 3 to be listed down the left side, and for recordcounts to be listed under each weekday name and for each shift.

thanks in advance,
geebee

[Dormilich]

@geraldjr30
since the week days won't change that easily, code them as table head in html. then you can loop over each "shift" building a row.

sample: (does not necessarily fits your system but illustrating)

$row_html = '<tr><td>shift%d</td><td>%s</td> ... </tr>'; // 8 cells
// for now assuming $shifts holds the count value for each day in the shift
// $shifts[0]['sunday'] / $shifts[0]['monday'] / ...
// $shifts[1]['sunday'] / $shifts[1]['monday'] / ...
$count = 0;
foreach ($shifts as $shift)
{
  // replaces the "%d" and "%s"
  printf($row_html, ++$count, $shift['sunday'], $shift['monday'], ...); // fill with values
}

regards