router.get("/users/:id", (req, res) => {
    const userId = req.params.id;
    const newLocal = "SELECT * FROM Users WHERE id = ?";
    getConnection().query(newLocal, [userId] ,(err, rows, fields) => {
        if (err) {
            console.log(err);
            res.sendStatus(500);
        } else {
            const user = rows.map((row) => {
                return {name: row.name, id: row.id}
            });
                res.render("users/showUser.ejs", {user: user});
        }
    });
});

router.get("/users/:id", (req, res) => {
    const userId = req.params.id;
    const newLocal = "SELECT * FROM Users WHERE id = ?";
    const users = selectUserById(newLocal, userId, res);

    console.log(users);

    // if users==[]
       //user not found
    //else
       //res.render("users/showUser.ejs", {user: user});
});

function selectUserById(newLocal, userId, res) {
    var user;
    getConnection().query(newLocal, [userId], (err, rows, fields) => {
        if (err) {
            console.log(err);
            res.sendStatus(500);
            user = rows.map((row) => {
                return {};
            });
        }
        else {
            user = rows.map((row) => {
                return { name: row.name, id: row.id };
            });
        }
        return user;
    });
}