You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
33 lines
753 B
33 lines
753 B
const express = require('express');
|
|
const mysql = require('mysql');
|
|
const app = express()
|
|
|
|
const connection = mysql.createConnection({
|
|
host: 'localhost',
|
|
user: process.env.DBUSER,
|
|
password: process.env.DBPASSWORD,
|
|
database: 'new_trello'
|
|
});
|
|
connection.connect();
|
|
|
|
app.use(express.urlencoded({extended:false}));
|
|
|
|
const showItems = (req, res)=>{
|
|
connection.query(`SELECT * FROM items`, (errors, results, fields)=>{
|
|
res.render('show.ejs',{
|
|
items:results
|
|
})
|
|
})
|
|
}
|
|
|
|
app.get('/', showItems);
|
|
app.post('/', (req, res)=>{
|
|
connection.query(`INSERT INTO items (title, description) VALUES ('${req.body.title}', '${req.body.description}')`, (errors, results, fields)=>{
|
|
res.redirect('/');
|
|
})
|
|
})
|
|
|
|
app.listen(3003, ()=>{
|
|
console.log('listening');
|
|
})
|