index.js

const express = require('express');
const mysql = require('mysql');
const app = express();
const bodyParser = require('body-parser');


app.set('view engine', 'ejs')
app.use(express.static('public'));
app.use(bodyParser.urlencoded({extended:false}))

const db = mysql.createConnection({
    localhost: 'localhost',
    user: 'root',
    password: '',
    database:'node-me',
})

db.connect(function(err) {
    if (err) {
        throw err;
    } 
      
  //Select only "name" and "address" from "customers":
});

app.get('/',(req,res)=> {
    
    db.query("SELECT id,unit_name,monthly_rent FROM rooms", function (err, result, fields) {
        if (err) {
          throw err;  
        } 
        else {
            console.log(result.length);
        }

       // res.send(result);
        res.render('pages/index', { results:result });
    });
    
})

app.get('/edit/:id', (req, res,next) => {
    const id = req.params.id;
    const sql = 'SELECT id,unit_name,monthly_rent FROM rooms WHERE id = ?';
    db.query(sql,[id],(err,result,fields)=> {
        if (err) throw err;
        console.log(' going to update',result[0].id);
        
        res.render('pages/edit',{data:result})
});

})


app.get('/single-view/:id', (req, res,next) => {
    const id = req.params.id;
    const sql = 'SELECT id,unit_name,monthly_rent FROM rooms WHERE id = ?';
    db.query(sql,[id],(err,result,fields)=> {
        if (err) {
            throw err;
        }
        else {
            console.log(result);
            
            res.render('pages/single-view',{data:result})
        }
        
    });
})

app.post('/edit-single/:id', (req, res, next) => {
    
    //res.send(req.body);

    const id = req.params.id;
    const sql = 'UPDATE rooms SET unit_name=?,monthly_rent=? WHERE id=?';
    db.query(sql,[req.body.unit_name,req.body.monthly_rent,id],(err,result,fields)=> {
        if (err) throw err;
        console.log('updated t',id);
        
        res.redirect('/')
        //res.render('pages/edit',{data:result})
});
    
    


})


app.get('/delete/:id', (req, res,next) => {
    const id = req.params.id;
    const sql = 'DELETE FROM rooms WHERE id = ?';
    db.query(sql,[id],(err,result)=> {
        if (err) throw err;
        console.log(result.affectedRows + ' room deleted');
        
        res.redirect('/');
    });
})

app.get('/new',(req,res)=> {
    res.render('pages/new');
})

app.post('/new', (req, res) => {
    const unit_name = req.body.unit_name;
    const monthly_rent = req.body.monthly_rent;
    const sql = `INSERT INTO rooms (unit_name,monthly_rent) VALUES ("${unit_name}","${monthly_rent}")`;
    db.query(sql, (err,result) => {
        if (err) {
            throw err;
            console.log()
        } else {
            console.log('added ',result.affectedRows);
            res.redirect('/');
        }
    });
})



app.listen('3000', () => {
        console.log('locoalhost:3000');
    });