Repository with all my projects involving SQL and Databases
- PHP
- MySQL
- HTML
- CSS
- Javascript
- XAMPP
This repository contains the code of a comprehensive blogging platform built with PHP, MySQL, HTML, CSS, and JavaScript. The project leverages the XAMPP local development environment for a seamless development experience. The blogging platform has been designed to provide a streamlined, user-friendly experience with features like user authentication, dynamic content creation, and interactive comment sections.
- User Authentication: This project includes a complete user authentication system that allows users to register, login, and logout. Registration is secure, with passwords hashed before being stored in the database.
- Blog Post Management: Users can create, delete, and update their blog posts. This offers a dynamic and interactive blogging experience.
- Commenting: Users can engage with each other’s posts by adding comments. This encourages user interaction and community building.
- To-Do: Future improvements include adding user profile management, a 'like' system for blog posts and comments, and enhancing the user interface for a more engaging user experience and host in a website.
- Achieved a working user authentication system, which is a fundamental aspect of any web application.
- Developed dynamic content creation features, improving user interaction and engagement capabilities.
- Gained proficiency in backend development using PHP and MySQL and frontend development using HTML, CSS, and Bootstrap.
- Mastered the use of XAMPP as a local development environment.
- Clone the repository to your local machine.
- Set up XAMPP on your local machine. You can follow the instructions here.
- Start Apache and MySQL in your XAMPP control panel.
- Open your browser and navigate to
http://localhost/Databases-Projects/Blog Section.
- Clone the repository to your local machine.
- Install XAMPP from here.
- Start Apache and MySQL in your XAMPP control panel.
- Navigate to
http://localhost/phpmyadminin your browser and create a new database. - Open the project in your preferred IDE and make your changes.
- To work on the blog implementation, navigate to
Databases-Projects/Blog Section. - To work on the authentication system, navigate to
Databases-Projects/Authentication System Section.
- To work on the blog implementation, navigate to
This blogging platform project serves as a solid foundation for any web development project. It offers a good starting point for developers looking to expand their skills in full-stack web development. The project's aim is to provide a practical, hands-on experience with the fundamental aspects of web development, including user authentication, dynamic content creation, database management, and more. Your contributions and suggestions for improvement are always welcome.
A basic user authentication system, implemented with a MySQL database and sessions. This system includes three main parts: registration, login, and logout. In the registration part, new users can create an account by providing their email, username, and password. The password is hashed for security before storing in the database. In the login part, existing users can enter their email and password to access the system. If the entered details match with the database records, a new session is started, and the user is redirected to the index page. If a user is logged in and tries to access the login or register page, they are also redirected to the index page. Finally, the logout part destroys the active session and redirects the user back to the index page, effectively logging them out.
This is a comprehensive blog application developed using PHP, HTML, CSS, and Bootstrap. The application utilizes XAMPP as the local development environment and MySQL for data storage. With features like user authentication and dynamic content creation, the app offers a streamlined blogging experience.