🏢Hello College Web Application

👋Welcome to Hello College, a user-friendly full-stack web application designed to solve users' problems and create a community for different domains. Our website also provides important materials and resources for students.

---

🧑‍💼Tech Stack Used:

• Backend:Express JS, Node JS, AJAX
• Database:My SQL
• Frontend:JavaScript, jQuery, Bootstrap, HTML, CSS

🪧Installation Steps:

1. Clone the Project
2. npm init
3. npm install
4. In the server.js file and SqlFunction.js, update the database connection configuration with your MySQL credentials.
5. Open MySQL Workbench and run the following command to create the community table:

       CREATE TABLE community (
       id INT PRIMARY KEY AUTO_INCREMENT,
       issue VARCHAR(1000) NOT NULL,
       time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
       date DATETIME DEFAULT CURRENT_TIMESTAMP,
       upvote INT DEFAULT 0,
       downvote INT DEFAULT 0
   );
     

6. Run the command node server.js in the code editor(VS Code)
7. Now Open your Browser and go to http://127.0.0.1:3000

✅Libraries and Dependencies

• mysql
• express
• nodemailer
• body-parser
• cookie-parser
• path

▶Overview Video

For a detailed overview of the application , please watch the video.

Features

• User-friendly interface.
• Community creation for different domains.
• Access to important materials and
• Added OTP verification through G-Mail account for the user authentication.
• Upvote and downvote system for community issues

🤝Contact

For any queries or suggestions

• Email: aashishs.ug23.cs@nitp.ac.in
• LinkedIn: LinkedIn Profile
• GitHub: GitHub Profile

---

👨‍🦱Thank you for visiting this project "Hello College".