Skip to content

This project is a Node.js web application that connects to a MySQL database to manage user data. It includes a user-friendly interface for inputting and storing information, such as name, email, age, and date of birth. The application validates user inputs, ensuring data integrity, and displays the stored data in a tabular format.

Notifications You must be signed in to change notification settings

Abhishekjha52/NodeJs-MySQL-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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:

    git clone https://github.com/your-username/your-repo-name.git
  2. Navigate to the project directory:

    cd your-repo-name
  3. Install dependencies:

    npm install
  4. Configure MYSQL credentails in "script.js"

Usage

  1. Start the application:

    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.

About

This project is a Node.js web application that connects to a MySQL database to manage user data. It includes a user-friendly interface for inputting and storing information, such as name, email, age, and date of birth. The application validates user inputs, ensuring data integrity, and displays the stored data in a tabular format.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published