Project Overview
Bitter is a dynamic and engaging social media website that allows users to connect, share updates, and interact with each other. Developed using the Bootstrap framework, and MySQL, this project showcases my skills in building a database-driven web application. The project began as a simple static HTML site and gradually evolved into a fully functional social media platform. Key accomplishments in each sprint include:
Sprint #1:
- Created a user registration form with PHP validation and data insertion into the MySQL database.
- Implemented user authentication and session management for secure login. Implemented access control to redirect users based on their login status.
Sprint #2:
- Developed a recommendation panel suggesting users for the logged-in user to follow.
- Created SQL queries to fetch random users, excluding the logged-in user and those already followed.
- Implemented the functionality to follow other users.
Sprint #3:
- Enhanced user profiles by enabling profile picture upload and editing.
- Implemented logic to display user profile pictures, including a default image for users without a profile picture.
- Implemented tweet creation and display on the index page, including user information and like/retweet icons.
Sprint #4:
- Added the functionality to retweet other users' tweets.
- Implemented the ability to reply to tweets, visually connecting replies with the original tweets.
Sprint #5:
- Developed the userpage.php to display detailed information about a specific user, including tweets and retweets associated with them.
- Implemented the search feature, allowing users to find other users and tweets based on specific criteria.
Throughout the project, I have utilized frameworks such as Bootstrap, Spring Boot, and Thymeleaf to enhance the website's functionality and design. Additionally, I have demonstrated my proficiency in MySQL for efficient database management. This project serves as a portfolio-worthy example showcasing my skills in developing a database-driven social media website using PHP and MySQL.
