/Javascript/Node.js/How to connect mysql using node js stack

How to connect mysql using node js stack

var mysql = require('./node_modules/mysql');
    var connection = mysql.createConnection({
            host: '127.0.0.1',
            user: 'root',
            password: '',
            database: 'nodeapp'
        });
    connection.connect(function (err) {
        if (err)
            throw err;
    });
    module.exports = connection;

Source: stackoverflow.com

How to connect mysql using node js stack

var express = require('./lib/express');
    var app = express();
    var bodyParser = require('body-parser')
    var db = require('/db');
     app.get('/', function (req, res) {
        res.sendFile('/NodeProj/views/' + 'index.html');
    });
    /** bodyParser.urlencoded(options)
     * Parses the text as URL encoded data (which is how browsers tend to send form data from regular forms set to POST)
     * and exposes the resulting object (containing the keys and values) on req.body
     */
    app.use(bodyParser.urlencoded({
        extended: true
    }));

    /**bodyParser.json(options)
     * Parses the text as JSON and exposes the resulting object on req.body.
     */
    app.use(bodyParser.json());

    app.post('/process_form', function (req, res) {
        var response = {
            "firstname": req.body.fst_name,
            "email": req.body.fst_email,
            "password": req.body.fst_password
        };
        var query = connection.query('INSERT INTO register SET?',response,function(err,result){
            if(err) throw err;
            if(result) console.log(result);
        });
        res.end(JSON.stringify(response));
    });

    app.listen(8081);

Source: stackoverflow.com

How to connect mysql using node js stack

const mysql = require('mysql');
const express = require('express');
const app = express();
const PORT = // define the PORT for your host

var connection = mysql.createConnection({
    host: 'localhost',
    user: '<MY_USER_NAME>',
    password: '<MY_PASSWORD>',
    database: '<DB_NAME>'
});

connection.connect(function(err) {
  if (err) console.error(err);
  console.log("Connected!");
});

app.get('/db-test', (req, res, next) => {

  var id = // fill in a user_id that you know exists
  var sql = `SELECT * FROM users WHERE id NOT IN ('${id}') `;

  console.log(sql); // confirm you are sending the sql request you believe you should be sending

  connection.query(sql, function (err, results, fields) {
      if (err) console.error(err);
      console.log(`results: ${results}\nfields: ${fields}`);
  });

});

app.listen(PORT);

Source: stackoverflow.com

Similar codes

4 votes357 views2 answers
Node js module export class
Javascript Node.js
83 votes465 views6 answers
Express nodejs
Javascript Node.js
9 votes499 views2 answers
How to read all files in a folder in node js
Javascript Node.js
4 votes394 views1 answer
How to check file extension in node js
Javascript Node.js
-1 vote330 views1 answer
Nodejs read file to array
Javascript Node.js
0 vote301 views1 answer
Initiate node js project
Javascript Node.js
6 votes364 views2 answers
Node Sass could not find a binding for your current environment: Linux 64-bit with Node.js 10.x
Javascript Node.js
1 vote338 views2 answers
Node alternative to btoa
Javascript Node.js
23 votes346 views6 answers
Create node js server
Javascript Node.js
40 votes409 views2 answers
How to get current year in nodejs
Javascript Node.js