Question: Hello, I need a project in php language and using MySQL , with documentation for it , and text explaining how to set up and

Hello, I need a project in php language and using MySQL, with documentation for it, and text explaining how to set up and run the project, without using javascript.
Project Requirements
1. Project Overview:
Develop a web application where users can register, log in, and create
and manage events.
Use object-oriented PHP to structure your code.
Implement secure password storage using hashing.
Use MySQL to store user and event information.
2. Functional Requirements:
User Registration:
Create a registration form that collects the following
information:
-Username (must be unique)
- Password (must be securely hashed)
- Email address (must be unique)
-Validate the input data for proper format and constraints.
- Store the user data in a MySQL database.
- User Login:
- Create a login form that requires a username and password.
- Validate the credentials against the stored data in the MySQL
database.
- Start a user session upon successful login.
- Event Management:
- Allow logged-in users to create events with the following details:
- Event name
- Description
- Date and time
- Location
- Store event data in the database.
- Provide an interface to view, edit, and delete events.
- Password Security:
- Use PHP's password_hash() function to hash passwords before
storing them.
- Use PHP's password_verify() function to verify passwords
during login.
- Session Management:
- Implement session handling to keep users logged in across
different pages.
- Include a logout mechanism to end the session.
3. Technical Requirements:
PHP:
Use classes and objects to structure the registration, login, event
management, and session management functionalities.
Create a class for database interactions using PDO (PHP Data
Objects) to handle MySQL queries.
MySQL:
Design a database with tables to store user information and
events (e.g., users and events tables).
Ensure proper relationships between tables (e.g., user_id in
events table to link events to users).
Front-End:
Create simple and user-friendly HTML forms for registration,
login, and event management.
Use basic CSS for styling (optional).
Security:
Implement input validation to prevent SQL injection and XSS
attacks.
Use HTTPS to secure data transmission (if possible).));
4. Code Structure:
Classes and Methods:
Database: Class to handle database connection and queries.
Methods: connect(), query(), execute(), etc.
User: Class to handle user-related operations.
Methods: register(), login(), logout(), isLoggedIn(),
etc.
Event: Class to handle event-related operations.
Methods: create(), read(), update(), delete(), etc.
Session: Class to manage sessions.
Methods: start(), destroy(), get(), set(), etc.
File Organization:
index.php: Home page.
register.php: Registration form and handling.
login.php: Login form and handling.
logout.php: Logout handling.
events.php: Interface to create, view, edit, and delete events.
config.php: Configuration file for database connection.
classes/: Directory for class files (e.g., Database.php,
User.php, Event.php, Session.php).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!