Please help with the following practice problem. Example of the program here > http://itcdland.csumb.edu/~milara/cst336/final/superheroes/program1.php Practice problem

YOU DO NOT NEED TO DO THE AJAX PORTION, BUT IT WOULD BE NICE You will need the following resources: a) Images. Download this file, uncompress it, and upload it to your "final" folder. (Attached to question) b) Sql statements. Open this file in a browser, copy the SQL statements and paste them into your "final" database using the phpMyAdmin interface. The SQL statements will create a new table: superhero. (Attached to question)

In this program, you will display a random superhero from a database. The user should be able to select the "real name" of the superhero (e.g., "Bruce Wayne" for "Batman"). Your program must provide feedback whether the answer was correct or incorrect. Your program must also display how many times users have answered the real name for a specific superhero correctly and incorrectly (using AJAX) Program 1 Sample Notes: a) You will use the "superhero" table. b) You will need to modify this table or create another table to keep track of the times users has answered the real name for each superhero correctly and incorrectly (you decide the table structure) Once you finish, come back here and copy the rubric below. Paste the rubric into the text of your submission on iLearn. Place an x next to each completed task. Although there are 90 possible points, you only need to earn 75 in order to receive 100% on the exam. Rubric Task Description

A random image of a superhero is displayed when refreshing the page

The "real names" of the superheroes in the dropdown menu come from the database (in alphabetical order)

An error message is displayed if the user clicks on the "Check Answer" button without selecting anything.

The right color-coded feedback (correct or incorrect) is displayed upon clicking on the "Check Answer" button

The number of times the real name for the specific superhero has been answered correctly and incorrectly is stored in the database, via AJAX (you'll need to create a new table, you decide the structure)

sql code

-- phpMyAdmin SQL Dump -- version 4.7.8 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: May 16, 2018 at 07:41 PM -- Server version: 5.5.57-0ubuntu0.14.04.1 -- PHP Version: 5.5.9-1ubuntu4.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */;

-- -- Database: `superhero` --

-- --------------------------------------------------------

-- -- Table structure for table `superhero` --

CREATE TABLE `superhero` ( `id` int(11) NOT NULL, `name` varchar(25) NOT NULL, `firstName` varchar(25) NOT NULL, `lastName` varchar(25) NOT NULL, `pob` varchar(25) NOT NULL COMMENT 'Place of Birth', `image` varchar(25) NOT NULL COMMENT 'Image Name' ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `superhero` --

INSERT INTO `superhero` (`id`, `name`, `firstName`, `lastName`, `pob`, `image`) VALUES (1, 'Spiderman', 'Peter', 'Parker', 'New York', 'spiderman'), (2, 'Superman', 'Clark', 'Kent', 'Krypton', 'superman'), (3, 'Batman', 'Bruce', 'Wayne', 'Gotham City', 'batman'), (4, 'Wonderwoman', 'Diana', 'Prince', 'Themyscira', 'wonder_woman'), (5, 'Iron Man', 'Tony', 'Stark', 'Bulgaria', 'iron_man'), (6, 'Captain America', 'Steve', 'Rogers', 'New York', 'captain_america'), (7, 'The Hulk', 'Bruce', 'Banner', 'Ohio', 'hulk');

-- -- Indexes for dumped tables --

-- -- Indexes for table `superhero` -- ALTER TABLE `superhero` ADD PRIMARY KEY (`id`); COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Images to use