Reference no: EM1344669

Q1) Write a PHP script to obtain URL and its description from user and stores information into database by using MySQL. Create and run a SQL script with a database named URL and a table named Urltable (Hint: You'll need to create both the database and the table in MySQL using PHP Admin or SQL Navigator). The first field of the table should contain the actual URL, and the second, which is named Description, should contain a description of the URL. Use www.utdallas.edu as the first URL, and input "The University of Texas at Dallas" as its description. The second URL should be www.php.net, and the description should be "The official PHP site!" The third URL should be www.w3schools.com/php and the description should be "PHP Tutorial". After each new URL is submitted, display the contents of the database table in an html table. Please include the following three files of your solution (.html, .php, and .sql).