router.post('/products/:id', imgUpload.upload.single('productImg'), async (req, res) => {
    const id = req.body.id;
    let productImg = req.body.productImg;

    if (req.file) {
        productImg = req.file.filename;
        const filePathToDelete = './public/imgs/products/' + req.body.productImg;
        if (fs.existsSync(filePathToDelete)) {
            fs.unlink(filePathToDelete, err => {
                if (err) {
                    console.error(err);
                }
            });
        }
    }

    const name = req.body.productName;
    const price = req.body.productPrice;
    const desc = req.body.productDescription;
    const isHome = req.body.isHome == "on" ? 1 : 0;
    const isActive = req.body.isActive == "on" ? 1 : 0;
    try {
        await db.execute("UPDATE `nodedb`.`products` SET `name`=?,`price`=?,`img`=?,`desc`=?,`isHome`=?,`isActive`=? WHERE (`id`=?);",
            [name, price, productImg, desc, isHome, isActive, id]);
        res.redirect('/admin/products?action=edit');
    } catch (err) {
        console.log(err);
        res.status(500).send('İşlem sırasında bir hata oluştu.');
    }
});