CODEWITHSUNDEEP
mysqlnode.jsnode-mysql
yadayada
yadayada

Reputation: 3

How to query with node-mysql and write out the results?

I am trying to connect to a db on my hosting and write out the result, I am not getting any error, just blank space. line like console.log('test'); put at any place always work but I am not getting any query results, what am I doing wrong?

var mysql      = require('mysql');
var connection = mysql.createConnection({
    host     : 'wm51.wedos.net',
    user     : 'xxxxxx',
    password : 'xxxxxx',
    database: 'd57283_vs'
});

connection.connect();
var queryString = 'SELECT * FROM versus LIMIT 5';

connection.query(queryString, function(err, rows, fields) {
    if (err) throw err;
    for (var i in rows) {
        console.log(rows[i].title); 

    }
});

connection.end();

(The table is called versus, has columns title, url...in adminer it's all accessible and the query works...)

Upvotes: 0

Views: 163

Answers (3)

Meccles
Meccles

Reputation: 11

I believe the connection.end() statement still needs to be after the for loop. Or else your ending the connection before the loop even starts.

Upvotes: 0

clay
clay

Reputation: 6017

Be careful with that connection.end(); call at the bottom. NodeJS is asynchronous, remember?

Try putting that at the end of the inner function after the for-loop, otherwise it will get called as soon as the query is called, possibly killing the connection you're trying to use!

Upvotes: 1

Nelson.li
Nelson.li

Reputation: 581

perhaps mysql-server is not to be connected, when you query,or mysql-server is to be closed when you query. 

var mysql      = require('mysql');
var connection = mysql.createConnection({
    host     : 'wm51.wedos.net',
    user     : 'xxxxxx',
    password : 'xxxxxx',
    database: 'd57283_vs'
});

connection.connect();
process.nextTick(function() {
    var queryString = 'SELECT * FROM versus LIMIT 5';

    connection.query(queryString, function(err, rows, fields) {
        connection.end();
        if (err) throw err;
        for (var i in rows) {
            console.log(rows[i].title); 

        }
});

});

Upvotes: 0

Related Questions