Error [ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
at ServerResponse.setHeader (node:_http_outgoing:652:11)
at ServerResponse.header (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesexpresslibresponse.js:795:10)
at ServerResponse.contentType (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesexpresslibresponse.js:625:15)
at ServerResponse.send (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesexpresslibresponse.js:150:14)
at done (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesexpresslibresponse.js:1053:10)
at tryHandleCache (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesejslibejs.js:280:5)
at exports.renderFile [as engine] (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesejslibejs.js:491:10)
at View.render (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesexpresslibview.js:135:8)
at tryRender (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesexpresslibapplication.js:657:10)
at Function.render (C:UserskamblOneDriveDesktopApnaCollegemYSQLnode_modulesexpresslibapplication.js:609:3)
I am currently learning so haven’t been able to resolve this error
This is my code:
const { faker } = require('@faker-js/faker');
const mysql=require("mysql2");
const express= require( "express" );
const app=express();
const path=require("path");
app.set( 'view engine', 'ejs' );
app.set("views",path.join(__dirname,"/views"));
const connection=mysql.createConnection({
host:"localhost",
user:"root",
database:"delta_app",
password:"Arbitron12#7006"
});
let getRandomUser=()=>{
return [
faker.string.uuid(),
faker.internet.userName(),
faker.internet.email(),
faker.internet.password()
];
};
//Home route
app.get("/",(req,res)=>{
let q=`SELECT count(*) FROM temp`
try{
connection.query(q,(err,result)=>{
if(err) throw err;
let count=result[0]["count(*)"]
res.render("Home.ejs",{count})
});
} catch (err){
console.log(err);
res.send("Some error in DB")
}
});
//Show route
app.get("/user",(req,res)=>{
let q= `select * from temp`;
try{
connection.query(q,(err,users)=>{
if(err)throw err;
res.render("showusers.ejs",{ users });
});
} catch (err){
console.log(err);
res.send("Some error in DB");
}
res.send("success");
});
app.listen("8080",() => {
console.log("Server is listening to the port 8080");
});
