app.js

const express = require('express');
const mysql = require('mysql');
const app = express();
app.use(express.static('public'));
app.use(express.urlencoded({extended: false}));

const connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'kimbowa',
    database: 'shopping_list'
  });

//homepage route
app.get('/', (req, res) => {
    res.render('top.ejs');
  });
  
  //route to  listing items page
  app.get('/index', (req, res) => {
    connection.query(
      'SELECT * FROM items',
      (error, results) => {
          console.log(results);
        res.render('index.ejs', {items: results});
      }
    );
  });
  //route to adding new teanant
  app.get('/addTenant', (req, res)=> {
    connection.query(
      'SELECT * FROM '
      
    )
  })
  
  //route to  create new item page
  app.get('/new', (req, res) => {
    res.render('new.ejs');
  });
  
  app.post('/create', (req, res) => {
      //create item in db
    connection.query(
      'INSERT INTO items (name) VALUES (?)',
      [req.body.itemName],
      (error, results) => {
        res.redirect('/index');
      }
    );
  });
  
  app.post('/delete/:id', (req, res) => {
      //delete item
    connection.query(
      'DELETE FROM items WHERE id = ?',
      [req.params.id],
      (error, results) => {
        res.redirect('/index');
      }
    );
  });
  
  app.get('/edit/:id', (req, res) => {
      //select item, take it to edit page
    connection.query(
      'SELECT * FROM items WHERE id = ?',
      [req.params.id],
      (error, results) => {
        res.render('edit.ejs', {item: results[0]});
      }
    );
  });
  
  app.post('/update/:id', (req, res) => {
    // update the selected item
    connection.query(
        'UPDATE items SET name=? WHERE id =?',
        [req.body.itemName, req.params.id],

        (error, results) => {
        res.redirect('/index');
        }
        ); 
  });
  
app.listen(3000);