how to display fetched json data from database in node js??.without json format

Question

here is my code.

var http=require("http");
var fs = require("fs");
var express = require("express");
var app = express();
var path = require("path");
var mysql = require('mysql');
var ejs = require("ejs")
var bodyParser = require('body-parser');
app.set('view engine' , 'ejs');
app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());
var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "testn"
});

con.connect(function(err) {
    if (err) throw err;
    con.query("SELECT * FROM form", function (err, result, fields) {
      if (err) throw err;
      console.log(JSON.stringify(result));
      app.get('/', function(req, res) {
        res.render('index',{data:JSON.stringify(result)});
      
      });

    });
  });

app.listen(3010);
console.log("Running at Port 3010");

and here is my html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
    <header>
        <div class="container">
            <p><%=data%><p>
             
        </div>
    </header>
</body>
</html>

and here is my output

[{"name":"Prakash","email":"prakashvpsm@gmail.com","description":"uykiukjk"},{"name":"Mathan","email":"v.prakash.av@gmail.com","description":"uykiukjk"},{"name":"prakashvpsm","email":"prakash@123.com","description":"uykiukjk"},{"name":"Prakash","email":"qdw@fff.com","description":"wddfwdpfk"},{"name":"Prakash","email":"prakashvpsm@gmail.com","description":"uykiukjk"}]

but i dont want in json format .i want without only the data. The data is fetched from local server

Querying MySQL will never return HTML directly as you'd want it. It will give you a data structure. Then it's up to you to display this data structure as you like. Instead of displaying `<%=data%>` in one block in your template, iterate it and display it in a nice table, row after row. https://stackoverflow.com/questions/22952044/loop-through-json-in-ejs — Jeremy Thille, Mar 22 '19 at 12:23
@prakashvp what do you mean in html format? how a response from mysql can be html? you surely will have to render it into html, how do you want to render it then ? as a table? update your question with your carrect needs. — AZ_, Mar 22 '19 at 12:26
Possible duplicate of [Loop through JSON in EJS](https://stackoverflow.com/questions/22952044/loop-through-json-in-ejs) — infamoustrey, Mar 22 '19 at 13:00

score 2 · Answer 1 · answered Mar 22 '19 at 13:37

I am guessing the solution below is what you were looking for.

const express = require("express");
const app = express();
const mysql = require('mysql');
const bodyParser = require('body-parser');

app.set('view engine', 'ejs');
app.use(bodyParser.urlencoded({
    extended: false
}));
app.use(bodyParser.json());

const con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "testn"
});

con.connect(function (err) {
    if (err) throw err;
});

app.get('/', function (req, res) {
    const result = con.query("SELECT * FROM form", function (err, result, fields) {
        if (err) throw err;
        return results;
    });
    res.render('index', {
        data: results
    });
});


app.listen(3010);
console.log("Running at Port 3010");

ejs template

<!DOCTYPE html>
<html lang="en">

<body>
    <div >
        <table>
            <% for(const row of data) { %>
            <tr>
                <td>
                    <%= row.name %>
                </td>
                <td>
                    <%= row.email %>
                </td>
                <td>
                    <%= row.description %>
                </td>
            </tr>
            <% } %>
        </table>
    </div>
</body>

</html>

how to display fetched json data from database in node js??.without json format

1 Answers1