webdevava/mysql-ern-crud

CRUD Application with MySQL, React, Node.js, and Express

This is a simple CRUD (Create, Read, Update, Delete) application that manages student names and email IDs. The application is built using MySQL for the database, React for the frontend, and Node.js with Express for the backend. XAMPP is used to provide a local development environment.

Prerequisites

Before you begin, make sure you have the following installed on your machine:

• XAMPP
• Node.js
• npm
• React
• MySQL

Installation

1. Clone the Repository:

   git clone https://github.com/Webdevava/MySQL-ERN-CRUD.git

2. Install Backend Dependencies:

   cd backend
   npm install

3. Create MySQL Database:

   • Open XAMPP and start the MySQL server.
   • Create a new database named crud.
   • Import the database.sql file into the crud database to set up the required table.

4. Configure Database Connection:

   • Update the database connection configuration in backend/index.js.

5. Install Frontend Dependencies:

   cd ../frontend
   npm install

6. Start the Application:

   • Start the Node.js server:

     cd ../backend
     node index.js

   • Start the React app:

     cd ../frontend
     npm run dev

   The Frontend should now be accessible at http://localhost:5173. The Backend should now be accessible at http://localhost:8000.

Usage

• Visit http://localhost:3000 in your browser to interact with the CRUD application.
• You can perform CRUD operations on student names and email IDs.

Folder Structure

• backend: Contains the Node.js server files.
• frontend: Contains the React frontend files.

Technologies Used

• Frontend:

  • React

• Backend:

  • Node.js
  • Express
  • MySQL(XAMPP)

Contributing

Feel free to contribute to this project.

Authors

• Webdevava