I'm facing an issue where I can successfully capture the username on the home page using ejs after a login, but when transitioning to other pages from the home page, the username is no longer visible. It seems like I am missing some logic on how to handle the username display across all pages.
Thank you in advance for your help!
app.post('/Home', function(req,res){
console.log(req.body);
const check = "select count(*) as cnt from users_info where Name ='"+req.body.userid +"' && Password = '"+req.body.password +"' ";
mysqlConnection.query(check,function(err,result){
console.log(result);
var Records= result[0].cnt;
console.log(Records);
if (Records== 1)
{
response.render('Login', {username:req.body.userid});
}
else
console.log('User name or Password is invalid');
// res.render('Login.ejs', {error: 'User name or Password is invalid'});
});
});
app.post("/Login/search", (req,response) =>{
console.log(req.body.search)
const check = "select * from users_info where Name NOT LIKE '${req.body.search}%' ";
mysqlConnection.query(check,function(err,result){
const arr = result ;
console.log(app)
console.log(arr.length)
let countRecords = arr.length;
if (countRecords>0){
const names = arr.map(({ Name }) => Name).join('\n');
console.log(names.length)
console.log(names)
res.render('Login-success', {users:names});
// res.send(names);
} else {
console.log('Request failed...')
}
});
});
header.ejs
<body>
welcome <%= username%>
How can I utilize this header file on Home.ejs, search.ejs, and other pages?