--- a/myway/myway_timeliness_overview.php +++ b/myway/myway_timeliness_overview.php @@ -1,92 +1,107 @@
Mean | Standard Deviation | Sample Size | Overall | -prepare($query); -$query->execute(); -if (!$query) { - databaseError($conn->errorInfo()); - return Array(); -} -foreach ($query->fetchAll() as $row) { - echo "
---|---|---|---|
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Overall | + prepare($query); + $query->execute(); + if (!$query) { + databaseError($conn->errorInfo()); + return Array(); + } + foreach ($query->fetchAll() as $row) { + echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Hour of Day | -prepare($query); -$query->execute(); -if (!$query) { - databaseError($conn->errorInfo()); - return Array(); -} -foreach ($query->fetchAll() as $row) { - echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Hour of Day | + prepare($query); + $query->execute(); + if (!$query) { + databaseError($conn->errorInfo()); + return Array(); + } + foreach ($query->fetchAll() as $row) { + echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Day of Week | -prepare($query); -$query->execute(); -if (!$query) { - databaseError($conn->errorInfo()); - return Array(); -} -foreach ($query->fetchAll() as $row) { - echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Month | -prepare($query); -$query->execute(); -if (!$query) { - databaseError($conn->errorInfo()); - return Array(); -} -foreach ($query->fetchAll() as $row) { - echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Day of Week | + prepare($query); + $query->execute(); + if (!$query) { + databaseError($conn->errorInfo()); + return Array(); + } + foreach ($query->fetchAll() as $row) { + echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Month | + prepare($query); + $query->execute(); + if (!$query) { + databaseError($conn->errorInfo()); + return Array(); + } + foreach ($query->fetchAll() as $row) { + echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Stop | -Stop + 1 order by myway_stop"; -$query = $conn->prepare($query); -$query->execute(); -if (!$query) { - databaseError($conn->errorInfo()); - return Array(); -} -foreach ($query->fetchAll() as $row) { - echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Route | - 1 order by route_full_name"; -$query = $conn->prepare($query); -$query->execute(); -if (!$query) { - databaseError($conn->errorInfo()); - return Array(); -} -foreach ($query->fetchAll() as $row) { - echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} |
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} | Route | + 1 order by route_full_name"; + $query = $conn->prepare($query); + $query->execute(); + if (!$query) { + databaseError($conn->errorInfo()); + return Array(); + } + foreach ($query->fetchAll() as $row) { + echo "
{$row[0]} | " . floor($row[1]) . " | " . floor($row[2]) . " | {$row[3]} |