About the Project
This project is designed to demonstrate the creation of a dynamic website with a robust MySQL database backend. The site supports user management, event creation, and content sharing, providing a seamless and interactive experience.
Target Audience & Purpose
Who: Target users are event organizers and content creators looking for a simple yet powerful tool to manage their workflows.
What: A web-based solution for user profile management, event registrations, and content sharing.
When: Designed for ongoing use, scalable for both small teams and larger organizations.
Where: Accessible globally via the hosted URL: https://jamiecoker.com.
Why: To provide a centralized platform for managing users, events, and content efficiently.
Project Files
- index.html: The homepage displaying the database and layout diagrams.
- readMe.html: Comprehensive documentation about the project.
- createDatabase.php: Script for setting up the MySQL database.
Instructions for Setup
- Upload all files to your web server, ensuring the file structure matches the provided organization.
- Run createDatabase.php to create the database and populate it with sample data.
- Navigate to index.html to view the diagrams and site functionality.
Database Overview
The project database includes the following tables:
- Users: Stores user credentials and account details.
- Profiles: Contains additional user profile information.
- Events: Manages event creation and tracking.
- Content: Handles user-generated content and updates.
- Comments: Stores user comments on content.
- Registrations: Tracks user registrations for events.
Diagrams
Visualizations of the database structure and layout design are linked below: