/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

2 votes281 views2 answers
Send multipart form data axios with node js
Javascript Node.js
6 votes276 views2 answers
Node code to read json file
Javascript Node.js
0 vote271 views1 answer
Dynamodb pagination nodejs
Javascript Node.js
11 votes277 views4 answers
Node express setup
Javascript Node.js
0 vote261 views1 answer
Node js require all function from another file
Javascript Node.js
1 vote279 views3 answers
Downgrade nodejs with nvm
Javascript Node.js
2 votes287 views3 answers
How to delete a folder using node js
Javascript Node.js
0 vote263 views1 answer
“new Set” is returning an empty set in nodejs
Javascript Node.js
0 vote277 views1 answer
Cross-origin request blocked the same origin policy disallows reading the remote resource fix in node js node js
Javascript Node.js
2 votes269 views1 answer
Promise method in node js
Javascript Node.js