Get MySQL data in node.js (express) and print using EJS

Question

I'm trying to get the data of my MySQL table and print them in HTML using EJS, but this doesn't work. It tells me print not defined. What should I do?

router.get('/data', function(req, res){
    res.render('print', {req : req, res : res});
    connection.query('SELECT * FROM users', function(err, result) {

        if(err){
            throw err;
        } else {
            for(x in result){
                res.locals.print =  result[x];
                console.log(result[x]);
            }
        }
    });
});

<!doctype html>
<html>
    <body>
        <div>
            <%= print %>
        </div>
    </body>
</html>

BrTkCa · Accepted Answer · 2015-09-17 15:45:03Z

7

In the render, you can return a JSON variable with the consulted data and show in the view. res.render can be the last instruction in this way. Some like this:

var obj = {};
router.get('/data', function(req, res){

    connection.query('SELECT * FROM users', function(err, result) {

        if(err){
            throw err;
        } else {
            obj = {print: result};
            res.render('print', obj);                
        }
    });

});

<body>
    <table id="table" >  
        <thead>  
            <tr>  
                <th>Username</th>  
                <th>Password</th>  
            </tr>  
        </thead>  
         <tbody>  
         <% print.forEach(function (user) { %>
            <tr>  
                <td><%= user.username %></td>  
                <td><%= user.password %></td>
            </tr>                                   
         <% }) %>
         </tbody>
    </table>   
</body>

</html>

edited Sep 17, 2015 at 15:45

answered Sep 17, 2015 at 12:35

BrTkCa

4,7894 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Murad Elboudy Over a year ago

I can't name a variable return, so I just named it obj and changed the other "return" 's necessary but left most of the code as is, but it still tells me "print is not defined". Do I maybe need to loop the result argument in the connection query? Weird thing I already did but maybe I did it in the wrong way or something.

BrTkCa Over a year ago

I updated the answer. After the res.render('print', obj); add console.log(obj); for show the value of the consulting. After post here the result...

BrTkCa Over a year ago

Ahh, you don't need the loop the result, this way works.

Murad Elboudy Over a year ago

Ok, so I think we're getting somewhere. I added the console.log() and it prints out: { print: [ {username: 'Tony', password: 'Lee'}, {username: 'Mark', password: 'Douglas'}, {username: 'Marshall', password: 'Hamilton'} ], _locals() }

BrTkCa Over a year ago

I updated the answer, see <%= print[0].username %>.

|

Collectives™ on Stack Overflow

Get MySQL data in node.js (express) and print using EJS

1 Answer 1

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related