NodeJs-MySQL-Project

MySQL-Node.js Web Application

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.

Features

• 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.

Getting Started

These instructions will help you set up and run the project on your local machine.

Prerequisites

• 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.

Installation

1. Clone the repository:

   ```bash git clone https://github.com/your-username/your-repo-name.git

2. Navigate to the project directory:

   ```bash cd your-repo-name

3. Install dependencies:

   ```bash npm install

4. Configure MYSQL credentails in “script.js”

Usage

1. Start the application:

   ```bash npm start

2. Acess the application in your web browser at http://localhost:3000.
3. Use the provided form to input and manage user data.

Contributing

• Contributions are welcome! Feel free to open issues or pull requests.

License

• This project is licensed under the MIT License.

Acknowledgements

• Built with Node.js and Express.js.
• Utilizes MySQL for database management.
• Uses EJS for view rendering.