/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

1 vote127 views2 answers
Nodejs get all folders in directory
Javascript Node.js
1 vote99 views1 answer
Node redis json set key
Javascript Node.js
0 vote106 views1 answer
How create array with names of files in folder nodejs
Javascript Node.js
13 votes108 views4 answers
Setinterval nodejs
Javascript Node.js
11 votes118 views3 answers
How to use body-parser in node js
Javascript Node.js
0 vote101 views3 answers
Nodejs share session
Javascript Node.js
0 vote103 views1 answer
How to check record successfully delete in mongodb node js
Javascript Node.js
1 vote118 views2 answers
Node js mongoose text index
Javascript Node.js
-1 vote117 views1 answer
Node js post multipart/form-data
Javascript Node.js
0 vote105 views1 answer
How to manage logging using winston for production and development in node js "github"
Javascript Node.js