--- a/labs/myway_timeliness_overview.php +++ b/labs/myway_timeliness_overview.php @@ -1,1 +1,97 @@ + +
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]} | 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]} | 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]} |