require_once( "myw-lib.php" );
$msg = '';
if ( $_POST["Submit"] ) {
// validate input
$msg .= validate( $_POST["ID"], "ID", 1, "integer", 0 );
if ( ! $msg ) { // check there is such a team
$db = connect();
$result = get_team_by_id( $db, $_POST["ID"] );
if ( $result === false ) $msg = "Sorry, could not retrieve your information ". mysql_error(); // remove mysql_error when live
elseif ( mysql_num_rows( $result ) == 0 ) $msg = "Sorry, this ID is not in the database";
else $team = mysql_fetch_assoc( $result );
}
if ( ! $msg ) { // passed validation
$result = get_shadow( $db, $team["ID"] );
print "
Your Team's Shadow Measurements:
";
if ( mysql_num_rows( $result ) == 0 ) {
print "
No measurements yet
";
}
else {
print "
";
print "Date | Local Time | Latitude | Longitude | Elevation | Gnomon Height | Shadow Length |
";
while ( $shadow = mysql_fetch_assoc( $result ) ) {
$datetime = strtotime( $shadow[Datetime] );
$date = date( "M j, 2007", $datetime );
$time = date( "g:i a", $datetime );
print "$date | $time | $shadow[Latitude] | $shadow[Longitude] | $shadow[Elevation] | $shadow[Gnomon] | $shadow[Shadow] |
";
}
print "
";
}
print "
Your Partners' Shadow Measurements:
";
$result_partners = get_partners( $db, $team["ID"] );
if ( mysql_num_rows( $result_partners ) == 0 ) print "
No partners found
";
else {
print "
";
print "Team | Date | Local Time | Latitude | Longitude | Elevation | Gnomon Height | Shadow Length |
";
while( $partners = mysql_fetch_row( $result_partners ) ) {
for ( $i=1; $i<7; $i++ ) {
if ( $partners[ $i ] ==0 or $partners[ $i ] == $team["ID"] ) continue;
$result_team = get_team_by_id( $db, $partners[ $i ] );
if ( $result_team === false or mysql_num_rows( $result_team ) == 0 ) $msg = "Sorry, could not retrieve partner information ". mysql_error(); // remove mysql_error when live
else {
$pteam = mysql_fetch_assoc( $result_team );
$result_shadow = get_shadow( $db, $partners[ $i ] );
$rows = mysql_num_rows( $result_shadow );
$rows1 = ($rows == 0 ? 1 : $rows );
print "$pteam[Name] | ";
if ( $rows == 0 ) {
print "No measurements yet | ";
}
else {
while ( $shadow = mysql_fetch_assoc( $result_shadow ) ) {
$datetime = strtotime( $shadow[Datetime] );
$date = date( "M j, 2007", $datetime );
$time = date( "g:i a", $datetime );
print "$date | $time | $shadow[Latitude] | $shadow[Longitude] | $shadow[Elevation] | $shadow[Gnomon] | $shadow[Shadow] |
";
}
}
}
}
}
print "
";
}
}
}
if ( $msg or ! $_POST["Submit"] ) {
?>
} ?>