Application to work out ship locations, and schedules from a movement database. (PHP & MySQL)
Application in PHP to connect to MySQL database.
The database will contain the following data: (sample data will be provided)
1) Ship ID (int)
2) Port ID (int)
3) Time In of Port (unix date)
4) Time out of Port (unix date)
When the ship is not in port it will be "at sea" and there will be no data.
The application should work out:
1) Where every ship is now
2) A ship schedule for this month
3) A port schedule for this month
2) Where two ships meet in the same port
This should be outputted as a html table , no other output is required the site is been designed separately...
The successful coder will get first refusal on some future bigger projects for this site if project is up to standard and delivered on time.