539681 Mysql upload & Php page with search function geopostcodes

Greetings, I purchased the geo postal codes for the Philippines from [login to view URL] it includes the following : File Encoding File name Text delimited UTF-8 [login to view URL] Microsoft Excel UTF-8 [login to view URL] Unformatted ASCII Text ASCII [login to view URL] XML structure UTF-8 [login to view URL] MySQL database UTF-8 [login to view URL] SQL Server 5 UTF-16 [login to view URL] General information PDF [login to view URL] License PDF [login to view URL] [login to view URL] 5.55 Mb / 53.22 Mb This means that the database is already in the MYSQL file no more encoding. What i need is to upload the MYSQL database in my server, and create one page for searches just like EX: [login to view URL] if you look on the right there is a search function. WHAT I NEED YOU TO DO: 1. Upload the MYSQL to my server 2. Create a page with Search functions with an advance search functions a.)Search Option for ZIPCODE | MUNICIPALITIES | CITY | REGION when someone types his zipcode and click search it will show up Regions | Provinces | Municipalities | Cities b.) location options When results shows there is a Location Options where it opens up a map exactly like EX: [login to view URL] Zipcode | Municipal | City | Latitude | Longitude | MAP Button 3. Search two (2) ZIPCODE to get Distance by Kilometer Route / Navigation Suggestions BELOW IS THE INSTRUCTION HOW TO DO THIS! #12. How to calculate the distance between two cities ? The formula used to calculate the distance between two geographical points is called orthodromy, it is defined as follows : Distance(A,B) = 6371 * ACos( Cos(LatA) * Cos(LatB) * Cos(LngB - LngA) + Sin(LatA) * Sin(LatB) ) The resulting number is the distance in kilometers between point A and point B. If you wish to return a result in miles (or any other unit), you must substitute the value 6371, which stands for the approximate radius of the Earth in km, by its equivalent in miles (or any other unit), that is 3959 miles. Latitude and longitude values must be input in radians : radians = degrees * PI/180. Excel template is available here. 4. Find the closest locations when someone input a search How to find the closest locations to a set point ? Having a database of localities with their latitudes (Lat) and longitudes (Lng), enables you to locate the closest cities to a set point (or within a radius of X) with the following query: SELECT Name, 6371 * ACos( Cos(RADIANS(Lat)) * Cos(RADIANS(UserLat)) * Cos(RADIANS(UserLng) - RADIANS(Lng)) + Sin(RADIANS(Lat)) * Sin(RADIANS(UserLat)) ) AS Distance FROM Cities ORDER BY Distance The UserLat and UserLng values should be replaced by the coordinates of the starting point. To limit the search to a given radius, you can add a WHERE clause to the distance; you can also specify a LIMIT clause to display only the n cities closest to your starting point. 5. Find my Zipcode This project should be easy because all the database is already provided