Improve the CSS a bit, make it look visibly cleaner.

We don't want users who aren't logged in to see people's names and emails. BUT prof said that it would be good to show not logged in users what listings are available to encourage them to register. Solution: allow users with no session to see available listings on the event page, but on the drop down show a prompt to log in first instead of the regular contact information

Related to login functionality. Should create a new user, and log them in.

One of the project requirements is to utilize a select statement that joins tables. Join the event and listings tables to get the number of listings for each event and show on the home page.

Stretch goal:
Would be super cool if when you select a game on the sell page for your listing, a little message says "The average current listing price for this game is xxx"

Pretty self explanatory. The registration page should have another screen that asks for a verification code that is sent to the ufl email submitted by the user.

Listing page should create a new entry in the listing table

Create the frontend for the listing page. Should have all the form elements and some basic JS to collect all that data. Ensure it scales cleanly

Enable login functionality. This should create a session on the site, with the user_id being available in various pages. This should also change the 'log in' button to 'profile' on the nav bar.

From the assignment submission:

The project must make use of W3C valid HTML with appropriate graphics/pictures. The project will be submitted to a markup validation service to check. For instance, one might use http://validator.w3.org/

Use that validator to make sure we are good, and make any fixes necessary

Design the login and signup pages similarly to the wireframe. This UI doesn't have to be exact, feel free to change the layout/feel, split these into two separate entities, etc. Just needs to have a clear login space and a clear signup space.

Navbar needs some updating:

• Some of the links go to .html files which are now .php files
• 'profile' section should say log in/sign up when no session is active, then switch to 'profile' when user is logged in
• Of course, this should also link to the correct sites.

Create the frontend for the event page. This should have the map view, the list view, and should scale as shown in the wireframe.

Home page should autopopulate events from events table

Create the FAQ page with relevant Q's and A's

Create the frontend for the profile page. Should show the relevant profile info on top and have the list view of active listings at the bottom. The list view should scroll horizontally on large display and vertically on small. Should have functions to easily add listing items. This code should be very similar to the event view on the landing page, can possibly borrow/collaborate there

Self explanatory. Could either go on the nav bar or in the profile page.

Create the navbar that will be used in every page in the site, and create blank placeholders for each of these pages. Navbar should include all items from the wireframe, and should scale with screen size as shown in the wireframe login page.

From the assignment page:

All groups are required to provide basic software documentation for their website. This includes 1) a basic user manual on how to use the website, and 2) an entity‐relationship diagram (ERD) that illustrates the database structure. This information is vital to the final project, so please take it seriously.

Create the user manual and update the ERD (a working version is in resources on discord). Make sure the user manual is clear, well formatted, and includes instructions for all major features, with screenshots.

There's an edit button on the user's listings in the profile page. Implement functionality

Event page should have listings autopopulate from db. Event, view, and section selected should be using GET method

We need to create a mySQL database for our project. This will have to live in one of our UF machines - will need to create the database and create a user with read and write access to it. The user will need to have a wildcard host see here. The database should include tables:

Events:

• event_id
• event_name
• event_image
• event_date

Users:

• user_id
• user_email
• user_password

Listings:

• listing_id
• user_id
• listing_price
• listing_section
• listing_row
• listing_seat
• listing_negotiable

Should also create a dummy php file to demonstrate connecting to db

Create the landing page frontend. Main thing here is to have that list view where it scrolls horizontally on desktop and vertically on mobile. Should add some scripts and functions to easily add event items programmatically

Profile page should show user data, and populate listings from DB. Should also allow editing listing entries