kaleb47 / concert-poster Goto Github PK

Task Description

• Create concert_view.php to enable customers to view their orders by entering their email.

Acceptance Criteria

• The program fetches and displays the correct order information based on the entered email.

Task Description

• Address any bugs identified during testing and refine features as needed.

Acceptance Criteria

• The application is free of critical bugs and meets all project requirements.

Task Description

• Develop the concert_order.php program to process new ticket orders and save them in the database.

Acceptance Criteria

• The program correctly calculates ticket costs, taxes, and fees, and successfully saves order data to the database.

Task Description

• Ensure that the frontend and backend work seamlessly together.

Acceptance Criteria

• The entire application flow from ordering to viewing orders works without errors.

Task Description

• Implement client-side validation in the order form to ensure all required fields are filled before submission.

Acceptance Criteria

• The form validates user input and provides appropriate feedback before allowing submission.

Description

We need to create an embedded HTML file that allows users to view data from our database. Additionally, this page should be accessible via a link on our main page.

Requirements

1. Embedded HTML Page:

   • The page should connect to our database (using the provided credentials) and display data from the 'Customers' table.
   • The data should include fields such as LastName, FirstName, Email, AdultTicket, ChildTicket, Date, Location, Subtotal, Tax, Fee, TotalCost, and CustomerID.
   • The page should handle cases where no data is found, displaying an appropriate message.

2. Link on Main Page:

   • Add a link on the main page that directs users to this new HTML page for viewing customer data.
   • The link should be labeled appropriately (e.g., "View Customers").

Potential Issues/Considerations

• Ensure database credentials are secured and not exposed in the HTML file.
• Check for SQL injection vulnerabilities and ensure the code is secure against such attacks.
• Make sure the page is styled consistently with the rest of the website.
• Verify the functionality across different web browsers.

Code Snippet for Reference

(Include your current PHP/HTML code snippet here)

Additional Notes

• Please update the ticket with any questions or clarifications needed.
• Include screenshots of the implemented feature for review.

Task Description

• Create a customer table in MySQL with the specified columns (LastName, FirstName, Email, AdultTicket, ChildTicket, Date, Location, Subtotal, Tax, Fee, TotalCost).

Acceptance Criteria

• The table correctly stores all necessary information with the correct data types.

Task Description

• Develop the HTML and CSS for the landing page, ticket order page (concert_form.html), and the order view page (concert_view.html).

Acceptance Criteria

• Pages are visually appealing, responsive, and have all required fields and links as per project requirements.