This is a Node.js web application that demonstrates the integration of MySQL and Node.js to create a simple web-based user data management system. It allows users to input and store information such as name, email, age, and date of birth. The project showcases essential CRUD (Create, Read, Update, Delete) operations with data validation and error handling.
-
User Data Input: Users can enter their information via a user-friendly form.
-
Data Validation: The application validates user inputs, ensuring data integrity.
-
Database Storage: User data is stored in a MySQL database, maintaining a structured record.
-
Data Retrieval: The stored data is displayed in a tabular format for easy access.
-
Error Handling: Robust error handling ensures a smooth user experience and data integrity.
These instructions will help you set up and run the project on your local machine.
- Node.js installed on your system.
- MySQL server and a database named 'internship_project' set up.
- Dependencies listed in 'package.json' installed using
npm install
.
-
Clone the repository:
git clone https://github.com/your-username/your-repo-name.git
-
Navigate to the project directory:
cd your-repo-name
-
Install dependencies:
npm install
-
Configure MYSQL credentails in "script.js"
-
Start the application:
npm start
-
Acess the application in your web browser at http://localhost:3000.
-
Use the provided form to input and manage user data.
- Contributions are welcome! Feel free to open issues or pull requests.
- This project is licensed under the MIT License.
- Built with Node.js and Express.js.
- Utilizes MySQL for database management.
- Uses EJS for view rendering.