Reference no: EM13935343

Please provide the code for the data storage file for the attached poll.

Helpful suggestions are below:

Create the database/Setup database tables

Identify a Primary Key

Store the questions results each time a response is submitted.

Use INSERT statements to populate the table

Issue SELECT SQL statement(s) that request all the possible answers for the poll.

Use a WHILE loop to extract info from the MySQL result set

Use the MySQL function COUNT() to count the number of records in the table

Display the number of votes the chosen answer received.

<form action="$Results" method="post">
<p><span class="style2">What is Your Favorite Color?</span> <select name="Color">
<option>Red</option>
<option>Green</option>
<option>Blue</option>
<option>Other</option>
<option value=" " selected> </option>
</select>
<br>
<span class="style2">What is your Favorite Season?</span>
<select name="Sign">
<option>Winter</option>
<option>Spring</option>
<option>Summer</option>
<option>Autumn</option>
<option value=" " selected> </option>
</select>
<br>
<br>
<span class="style2">Are you:<br>
Male
<input type="checkbox" name="Gender" value="Male">
Female
<input type="checkbox" name="Gender" value="Female">
</span>
<p><span class="style2">Please answer yes or no to the following:</span>
<br><br>
<span class="style3">Are you married? </span><br>
<label>
<input type="radio" name="Status" value="yes">
<span class="style4">YES
</span></label>
<br>
<label>
<input type="radio" name="Status" value="no">
<span class="style4">NO
</span> </label>
</p>
<input type="Submit" value="Submit" name="Submit">
</p>
</form>
</body>
</html>