Simple PHP /MySQL application

These are the requirements.

**Supplier of an Event**

A form is submitted by suppliers of events. The form has the following fields:

a. Name of event

b. Image (certain dimensions)

c. Brief Blurb (Maximum 120 Characters)

[url removed, login to view] of event

[url removed, login to view] of tickets for the above date of the event

[url removed, login to view] button

The submit button allows the administrator to reject/change/approve the event and the image (if one is loaded). Also, the administrator can manually go in and change the Events page if required.

Any events that have already occured (ie todays date > show date) should be archived in a separate page called PAST EVENTS

Any event where the no of tickets available is zero, should be archived in a separate page called PAST EVENTS

PAST EVENTS page should be manually modifiable, if required.

**FOR THE People who want to attend events:

**

Member logs into the Events page (username/password protected - security is already in place):

They click a button or fill in a booking form (what ever is easier to develop) and select the event, the date of the show.

When they submit their booking request, the counter of number of tickets available for that show goes down by the number of tickets requested by the member. Maximum available tickets per person is 2.

A message is displayed to the user saying that their booking was or was not successful

If the booking was successful, a record is sent to an excel spreadsheet with details of the name of the member, then name of the event they booked, the number of tickets, the member's email address and date of event.

## Deliverables

2 PHP FORMs

1 database table for events

1 excel spreadsheet

update of 2 html files

2 procedures

## Platform

PHP

Linux

MySql

Engineering Linux MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #2926217

About the project