/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

3 votes135 views3 answers
Nodejs increase heap size
Javascript Node.js
0 vote133 views1 answer
Nodejs sha512 decrypt
Javascript Node.js
-1 vote131 views2 answers
Nodejs write raw buffer to file
Javascript Node.js
0 vote122 views1 answer
Remove port number from url node js
Javascript Node.js
2 votes130 views2 answers
Node : The term 'node' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
Javascript Node.js
0 vote137 views1 answer
How to run a js file in node
Javascript Node.js
1 vote161 views1 answer
Aws list all files in s3 bucket node js aws
Javascript Node.js
0 vote134 views1 answer
Node js require all function from another file
Javascript Node.js
7 votes125 views1 answer
Node require module
Javascript Node.js
-1 vote133 views1 answer
Render html in node js
Javascript Node.js