You will find a SQL file, open your MySQL/phpMyAdmin, go to sql command, paste the contents of the file in the command window and then run. You will get a ready to use database that has data inside tables to be used for the HW.

You have to do the following:

Design a HTML form to enter a country and the php code loads information about the country and a list of its cities.

Design a simple form that has one textbox and a submit button. The user enters a population number in the textbox and the system loads from the database information about the cities with population number greater or equal to the population number entered by the user. The loaded data from the database is: city name, district, country, region, and country language. All loaded data has to be presented for the user in a suitable table. You have to use AJAX for this HW.

World.sql:

https://www.mediafire.com/download/0tu460o6hdnjf44