node js crud operations example using express with mysql

node js crud operations example using express with mysql

In this article, we will show how to create node js crud operations example using express with MySQL. here we will create a simple application using express. so we can easily manage the HTTP request (such as GET, POST, PUT, DELETE, etc.).

so you can follow the below steps for create node js crud operation example using express with MySQL.

Overview

Step 1: Create the Application Directory.

Step 2: Create an application using npm init

Step 3: Install helpful Packages

Step 4: Create database and table using express-myconnection

Step 5: Setting Database Configuration

Step 6: Create an app.js file

Step 7: Create student.js file

Step 8: Create a view file using ejs

Node js CRUD Example With MySql

Step 1: Create an Application Directory

First, we will open the command prompt and create the application directory in our directory. for this, you can follow the below command.

Step 2: Create an application using npm init

The “npm init” command through we can create a new package.json file in our application directory. when we build a new app at that time we use this command. Node.js will need to have a package.json file because includes the application related packages and application data.

Here below command helps to initialization our application.

Step 3: Install helpful Packages

Expess.js is a free and open-source framework and it’s a web application framework for Node.js. we can manage routes, create restful API, handle the request and response, and also create MVC structure using the express.js. Npm stands for the node package manager. npm, help to install node packages and manage the types of dependencies.
Here below command help to install express package.

Below command used for form validation.

This body-parser module parses JSON request and that allows you to access req.body from within your routes.

When we are submitting the form that time does not support some request like as PUT and DELETE. so we can easily pass data using this module.

The express-flash module used for the show message after inserted record or deleted record.

The cookie-parser and install express-session module used for temporary store data.

EJS standard for an Embedded Javascript Templating and it is a simple templating language.

below following command using install the MySQL module

The express-myconnection module used for MySQL connection.

Step 4: Create database and table using express-myconnection

we can use the below command to create a database, otherwise, we can directly create a database on PHPMyAdmin.

Step 5: Setting Database Configuration

After complete the installation of packages. we will database configuration. now we will create config.js in the application directory and paste the below code in this file.

Step 6: Create an app.js file

Now, we will take a new file and paste follow below code in this file and save as app.js.

Step 7: Create student.js file

Now, we will take a new file and paste follow below code in this file and save as student.js in the controller’s directory.

Step 8: Create a view file using js

Finally, we will create header.ejs, footer.ejs, index.ejs, add.ejs and edit.ejs files in view directory.

header.ejs

footer.ejs

index.ejs

add.ejs

edit.ejs

Related Posts
Please follow and like us: