Node.js Database Connection and Select Query
How to connect MySQL database in Node.js
In this lesson we will learn, how to connect MySQL database in the Node.js and will fetch records from database using select query using express framework.
For creating a nodejs application, you can see my previous lesson How to handle GET and POST requests in Node js
Before use mysql in Node.js must be ensured MySQL Database should be installed in your machine. You can see Installing MySQL documentation.
Install mysql node modules in node.js
Install mysql node modules in your application.
Create a Custom Module for Database Connection
Create a db.js file in the root folder for database connection and use this connection in your entire project.
Connect your database using your MySQL database credential host, database user, database password and database name.
MySQL SELECT query
Create a file routes/products.js and import
var db = require('../db'); into this for database connection.
Use MySQL select query for fetching all the records.
Fetch Single Record
For fetch single record using
Create a file views/products.hbs
Edit app.js file and import
var productsRouter = require('./routes/products'); and set products route
Complete code of app.js
If you want to use bootstrap in your application, then copy Bootstrap CDN link in the views/layout.hbs
MySQL Database Tables
In this lesson we have learned integration mysql database in the Node.js and use a MySQL select query for fetching the records. And also integrate bootstrap.