Node.js Display mysql query with ejs

Question

I can't seem to figure out how the exact syntax to display data I have from a a database. I have 1 row in my user database which has a Password, Email, Username field but I can't seem to display it. I just get a blank screen

I've added the function and ejs file that I'm trying to fugure out. it displays perfectly in the console

//controller.js

module.exports = function(app){
app.get('/users', function(req,res){
    let sql = "Select * from users";
    let query = db.query(sql, (err,result) => {
        if(err){
            console.log(err);
        }
        console.log(result);
        res.render('users', {user: result});

    }); 
});

}

ejs file

<html>
  <head>
    <title>Users List</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script></script>
    <link href = "/assets/style.css" rel="stylesheet" type ="text/css" />
</head>
<body>
    <div id ="todo-table">
        <li><%= player.Email %></li>
    </div>
  </body>
</html>

Mark S. · Accepted Answer · 2019-02-13 16:53:35Z

1

The mysql driver returns results in an array, even if there is only a single row returned. So you might need to return result[0] to get the single row.

answered Feb 13, 2019 at 16:53

Mark S.

4,0274 gold badges25 silver badges25 bronze badges

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

1 Comment

Jason villa Over a year ago

God bless you. Correct!

Collectives™ on Stack Overflow

Node.js Display mysql query with ejs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related