[SOLVED] How to Implement MySQL data into an EJS file to make a Profile Page

Issue

I am in the middle of a personal project to practice web development better to understand the ins and outs of web development, but I have run into a brick wall. In this personal project, I am creating a profile page. I have successfully linked the MySQL database to my server js file because I can import data to the table, but I am stuck trying to export the data to an ejs file.

I did the following to export the code, but I cannot even call the data because I cannot have SQL locate any entries from login.

app.get('profile', function (req, res) {
console.log("Inside Get Profile");
connection.query('SELECT * FROM ACCOUNTS WHERE PrimaryEmail = ? ', [req.body.email], function(error, results, fields) {
    if (error){
        console.log("Error");
        console.log(error);
    } else if (results.length > 0) {
        console.log("Data From Get Profile")
        console.log(results);
        res.render('profile', { data: results });
    }})});

So I did the following in an attempt to resolve my issue, which could work, but I am in the matter of pulling the data into the ejs file.

function userProfile(req, res, next){
console.log("Inside userProfile Function");
connection.query('SELECT * FROM ACCOUNTS WHERE PrimaryEmail = ? ', [req.body.email], function(error, results, fields) {
    if (error){
        console.log("Error");
        console.log(error);
        next();
    } else if (results.length > 0) {
        console.log("Data From userProfile Function");
        console.log(results);
        res.render('profile', { data: results });
        next();
    }})};

I would call the function at login after.

app.post('/login', userProfile, passport.authenticate('local', {failureRedirect:'/login-faliure', successRedirect:'/dashboard'}));

Any advice on how to get MySQL data to display certain information for the profile page would suffice!

Thank you for your time!

Solution

I found out that I had two app.get(‘profile’) method and now the page loads with no error after removing the un-needed one. The next thing I had to do was add the code below after “results.length > 0” and my data would start to show.

user={id:results[0].ID, email:results[0].PrimaryEmail, hash:results[0].EncryptHash, password:results[0].EncryptPassword};
    console.log(user);
    res.render('profile', { data: user})

Answered By – JonD

Answer Checked By – Cary Denson (BugsFixing Admin)

Leave a Reply

Your email address will not be published.