Most Popular Tutorials
Most Popular Tutorials :-

Simply Easy Learning at Your Fingertips. Click Tutorials Menu to view More Tutorial List





How to Insert Form Data Into the MySql Table Using Node.js?

create users.ejs

create users.ejs page in views directory of your project folder.

File Name : users.ejs

<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>

<div class="user-detail">
<h2>Create User Data</h2>
<form action="/users/create" method="POST">
<label>Full Name</label>
<input type="text" placeholder="Enter Full Name" name="fullName" required>
<label>Email Address</label>
<input type="email" placeholder="Enter Email Address" name="emailAddress" required>
<label>City</label>
<input type="city" placeholder="Enter Full City" name="city" required>
<label>Country</label>
<input type="text" placeholder="Enter Full Country" name="country" required>
<button type="submit">Submit</button>
</div>
</div>
</body>
</html>

Database Table

create users table in mysql database.

File Name : users

CREATE TABLE `users` (
`id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
`fullName` varchar(255) DEFAULT NULL,
`emailAddress` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`country` varchar(50) DEFAULT NULL
);

Connect Node.js Application to MySQL Database

File Name :


database.js

create database.js file in your project directory.

File Name : database.js

var mysql = require('mysql');
var conn = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '',
database: 'nodeapp'
});
conn.connect(function(err) {
if (err) throw err;
console.log('Database is connected successfully !');
});
module.exports = conn;

Create Routes

create routes for inserting data –

Include database connection file database.js
Create a route /form with the GET method to display an HTML form
Create another route /create with the POST method to insert data into the MySQL database

File Name : users.js

var express = require('express');
var router = express.Router();
var db=require('../database');
router.get('/form', function(req, res, next) {
res.render('users');
});
router.post('/create', function(req, res, next) {

// store all the user input data
const userDetails=req.body;

// insert user data into users table
var sql = 'INSERT INTO users SET ?';
db.query(sql, userDetails,function (err, data) {
if (err) throw err;
console.log("User dat is inserted successfully ");
});
res.redirect('/users/form');
// redirect to user form page after inserting the data
});
module.exports = router;

Load Route Into the Root File

include user.js route file in app.js the root file

File Name : app.js

var usersRouter = require('./routes/users');
app.use('/users', usersRouter);

Run Node.js Application to Insert Data in mysql database.

File Name : app.js

Start your Node.js server using npm start the command
npm start

Open your Browser

File Name :

http://localhost:3000/users/form

File Name :

When you submit the form. The form will be redirected to the following URL to insert form data using the POST method
http://localhost:3000/users/create





Previous Next


Trending Tutorials


PHP

PHP

100+ Tutorials
oops

PHP OOPs

80+ Tutorial
Codeigniter

Codeigniter

100+ Tutorial
Laravel

Laravel

100+ Tutorials
Node.js

NODE.JS

100+ Tutorials
Javascript

Javascript

100+ Tutorials


Review & Rating

0.0 / 5

0 Review

5
(0)

4
(0)

3
(0)

2
(0)

1
(0)

Write Review Here


Most Popular Tutorials

 Important Link