Nt1330 Unit 7 Exercise 1

Words: 439
Pages: 2

Figure 6-6: The information box appearing when a indicator is clicked
The path is drawn by starting on sorting the times ascending and giving each entry in the filtered database and giving each entry an iteration number. Starting from the first iteration a marker green marker is added indicating the start of the path. An indicator is added on the map to all of the following entries up to and including the last point showing if the speed was exceeded or not as shown in figure 6-5. A straight line is drawn between every 2 iteration points. After reaching the last entry a red marker is added indicating the ending of the path. Figure 6-7: Markers on the start and end points and coloured indicators for each data sent iteration
This is obtained as when the GSM module sends the latitude, longitude and speed to the server side these information is updated into 2 tables one of them containing the most recent value and the other having all the values of all the trains in the past until the most recent update. When the file is ran an XML file is generated via PHP with all the values in the database table with the history of all trains, the XML is filtered to only show the entries of the train found in the drop down
…show more content…
As shown in figure 6-9 the request URL contains all the request information needed. The URL starts by the static IP address (197.45.254.32) then the file being called name (get_info.php) it then starts adding the requested information in the URL starting by the ID of the train (6336 in this case) then the starting time of the filtering (from=2018-06-06T10:09:00) and the time to end of the filtering range (to=2018-06-06T15:54:00). These ranges are sent to the server and the server runs a PHP file that parses the received ranges to filter through the database table and takes the output to transform it to an XML file so it can be represented on the