I am currently taking a Web Programming course and need help with this practice question, the backend needs to be completely PHP, and connected to a MySQL Server.

The application will need to store the polls, the users, and the votes that have been submitted by the users on a poll. We have included one possible storage format below as an example, but you may freely choose any other format.

Your submission also needs to contain some already prepared polls that the users can vote on. Each user can cast only one vote per poll but can change it before the deadline expires. If your site does not include authentication, a user can cast an unlimited number of votes.

On the listing page (a.k.a. the main/index page) a creative title and a short description about the application should be visible as static text.

The main page is also accessible to unauthenticated users who are free to browse the polls displayed here.

The most recently created poll should always appear at the top of the page. Following it must be the other polls ordered descending by the date of creation. The polls should be listed in two sections on the page:

Polls whose deadline has not yet expired are displayed in the top section.

Polls that have already been closed are displayed in the bottom section. Their results are displayed as well.

The following elements should appear for each poll:

the ID / number of the poll;

the time of creation;

the voting deadline;

a button to vote.

A button belongs to each poll where votes can be submitted to that poll on the voting page. If your site contains session management and authentication but the user is not logged in yet, redirect the user to the login page instead