In this tutorial, you will learn how to insert data from HTML form into mongoDB database using node js express js with mongoose.
How to Insert Data into MongoDB Using Mongoose in Node.js Express
Steps to insert data in MongoDB using Mongoose:
Step 1 – Create Node Express js App
Run the following command on cmd to create the node js app:
mkdir my-app cd my-app npm init -y
Step 2 – Install express flash ejs body-parser mongoose Modules
Run the following command on the cmd to express flash ejs body-parser mysql dependencies :
npm install -g express-generator
npx express --view=ejs
npm install
npm install express-flash --save
npm install express-session --save
npm install body-parser --save
npm install express-validator cors --save
npm install mongoose
Step 3 – Connect App to MongoDB
Create a database.js
file into your app root directory, and add the following code in it to connect database with application:
var mongoose = require('mongoose'); mongoose.connect('mongodb://localhost:27017/test', {useNewUrlParser: true}); var conn = mongoose.connection; conn.on('connected', function() { console.log('database is connected successfully'); }); conn.on('disconnected',function(){ console.log('database is disconnected successfully'); }) conn.on('error', console.error.bind(console, 'connection error:')); module.exports = conn;
Step 4 – Create Model
Create Models directory, and in this directory create userModel.js
file:
const mongoose = require("../database"); // create an schema var userSchema = new mongoose.Schema({ name: String, email:String }); var userModel=mongoose.model('users',userSchema); module.exports = mongoose.model("Users", userModel);
Step 5 – Create Routes
Create routes; so visit routes directory and open users.js route file; Then add the following routes into it:
var express = require('express'); var router = express.Router(); var mongoose = require('mongoose'); var userModel = require('./models/userModel'); /* GET home page. */ router.get('/', function(req, res, next) { res.render('index', { title: 'add user' }); }); router.post('/add-user', function(req, res, next) { req.assert('name', 'Name is required').notEmpty() //Validate name req.assert('email', 'A valid email is required').isEmail() //Validate email var errors = req.validationErrors() if( !errors ) { //No errors were found. Passed Validation! var userDetails = new userModel({ name: req.body.name, email: req.body.email, }); userDetails .save((err, doc) => { if (!err) req.flash('success', 'User added successfully!'); res.redirect('/'); else console.log('Error during record insertion : ' + err); }); } else { //Display errors to user var error_msg = '' errors.forEach(function(error) { error_msg += error.msg + '<br>' }) req.flash('error', error_msg) res.render('/', { title: 'Add New User', name: req.body.name, email: req.body.email }) } }); module.exports = router;
Step 6 – Create HTML Markup Form
Go to views directory, and create index.ejs file, and create HTML form for inserting data into a database:
<!DOCTYPE html> <html lang="en"> <head> <title>Node.js Express Save Data from Html Form to Mongodb Database - Tutsmake.com</title> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"> </head> <body> <div class="container mt-4"> <div class="card"> <div class="card-body"> <% if (messages.success) { %> <p class="alert alert-success m2-4 mb-2"><%- messages.success %></p> <% } %> <h2>Node.js Express Save Data from Html Form to Mongodb Database - Tutsmake.com</h2> <form action="add-user" method="POST"> <div class="form-group"> <label for="firstName">Name</label> <input type="text" class="form-control col-lg-9" id="name" aria-describedby="emailHelp" placeholder="Enter first name" name="name"> </div> <div class="form-group"> <label for="exampleInputEmail1">Email address</label> <input type="email" class="form-control col-lg-9" id="exampleInputEmail1" aria-describedby="emailHelp" name="email" placeholder="Enter email"> </div> <button type="submit" class="btn btn-primary">Submit</button> </form> </div> </div> </body> </html>
Step 7 – Import Modules in App.js
Import express flash session body-parser mongoose dependencies in app.js; as shown below:
var createError = require('http-errors'); var express = require('express'); var path = require('path'); var cookieParser = require('cookie-parser'); var logger = require('morgan'); var bodyParser = require('body-parser'); var flash = require('express-flash'); var session = require('express-session'); var usersRouter = require('./routes/users'); var app = express(); // view engine setup app.set('views', path.join(__dirname, 'views')); app.set('view engine', 'ejs'); app.use(logger('dev')); app.use(express.json()); app.use(express.urlencoded({ extended: false })); app.use(cookieParser()); app.use(express.static(path.join(__dirname, 'public'))); app.use(session({ secret: '123456catr', resave: false, saveUninitialized: true, cookie: { maxAge: 60000 } })) app.use(flash()); app.use('/', usersRouter); // catch 404 and forward to error handler app.use(function(req, res, next) { next(createError(404)); }); // error handler app.use(function(err, req, res, next) { // set locals, only providing error in development res.locals.message = err.message; res.locals.error = req.app.get('env') === 'development' ? err : {}; // render the error page res.status(err.status || 500); res.render('error'); }); module.exports = app;
Step 8 – Test Application
You can use the following command to start node js app server:
//run the below command
npm start
Open your browser and type the following URL into it:
http://127.0.0.1:3000/
Conclusion
That’s it, you have learned how to insert/save/store data from HTML form into mongoDB database using node js express app.