addreview.js

const express = require('express');
const router = express.Router();
const bodyParser = require('body-parser');
const db = require('./db.js');

router.use(bodyParser.urlencoded({ extended: false }));
router.use(bodyParser.json());

router.post('/', (req, res) => {
    const { reviewee_id, reviewer_id, rating, content } = req.body;
    
    const sql = 'INSERT INTO reviews (reviewee_id, reviewer_id, rating, content) VALUES (?, ?, ?, ?)';
    const values = [reviewee_id, reviewer_id, rating, content];
    
    db.query(sql, values, (error, results) => {
        if (error) {
            console.error('Error executing MySQL query: ', error);
            res.status(500).send('Internal server error');
        } else {
            console.log('Review added successfully.');
            res.status(200).send('Review added successfully.');
        }
    });
});

module.exports = router;