Prerequisites:
Before you begin, make sure you have met the following requirements:
You have installed Node.js (v12 or higher) You have installed MySQL and have it running You have basic knowledge of terminal/command prompt usage You have a code editor like VS Code
Installation:
The project uses some Node.js packages. Install them using npm: => npm install
Database Setup :
Create the database and tables:
- Inside the project, there is a file named database.txt containing all the SQL commands needed to create the database schema and tables.
- Open database.txt, copy all the SQL code.
- Paste the SQL code from database.txt to create the database and tables.
Configuration:
- Open the server.js file in your project folder.
- Replace 'yourpassword' with your actual MySQL password.
- Replace 'yourdatabasename' with the name of the database you created in the previous step.
- Save the file.
Running the Application:
-
Open a terminal in your project directory.
-
Start the Node.js server: node server.js
-
You should see a message like: Server is running on http://localhost:5000 Connected to MySQL database!
Contributing: Contributions, issues, and feature requests are welcome! Feel free to fork the repository and submit pull requests.
Pictures :
