You have the following schema: https://imgur.com/a/fdWEW

You have to do the following:

Design an HTML form to enter a language (Arabic, English, and Spanish etc.) in a text field. Then, when the user clicks a search button, the php code

Lists all the countries whose official language is identical to the entered one.

Lists all the countries in case the entered language is used by less than 10% of the population.

[Note: when user enters a part of the language word, the system suggests a list of languages for the user to help him/her type the language correctly]

Build an HTML button that, when clicked, the database is accessed and all the details (including the cities) of the top 10 countries in terms of their surface areas are returned and displayed.

NOTE: AJAX must be used in every requirement above the php page will load once and all requests/response after loading the page made would require no reload of the page(itll use AJAX).