I've been having issues with node-mysql where I haven't been able to get a connection with it. Here is my code:
var mysql = require('mysql');
var pool = mysql.createPool({
connectionLimit: 10,
user: 'node',
password: 'pass',
host: 'localhost',
port: 3306,
database: 'store'
});
exports.getUser = function(user, pass){
var sql = 'SELECT * FROM store.users WHERE user = \'' + user + '\' AND password = \'' + pass + '\'';
pool.query(sql, function(err, rows, fields) {
if(err){
return err;
}else{
return rows.length;
}
});
};
Just sort of can't seem to throw an error or anything. The password in the database is plaintext for testing, so if I call it:
var pool = require('./database');
var message = pool.getUser('test','test');