Question: Please answer the following using PHP AerAirways uses the following two database tables to record the flights it offers and the airports it uses: flightNum

Please answer the following using PHP

Please answer the following using PHP AerAirways uses the following two database

AerAirways uses the following two database tables to record the flights it offers and the airports it uses: flightNum ea 101 ea 102 ea 103 ea 104 ea 105 ea 106 Flight goingFrom goingTo DUB STN DUB EDI DUB GLA DUB CDG STN CDG STN BER airport DUB STN EDI CDG BER Airport country Ireland England Scotland France Germany Suppose destinations.html contains this form:

The user enters the code of the airport from which s/he likes to travel. Write destinations.php which receives the user's input, queries the database, and outputs a well- formed HTML unordered list of countries to which there is at least one direct flight from the user's chosen airport, including nested lists of flight numbers to that country. For example, using the database shown above, if the user enters DUB, the user's browser will display something like the following: o England ea101 France o ea 104 Scotland ea 102 ea 103 o o A stylesheet is not required. Validation of user data is not required

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!