const express = require('express')
const mysql = require('mysql2');
const app = express()
const port = 3000
// 데이터베이스와 연결
const connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '123456q!',
database: 'mytest'
});
app.use(express.urlencoded({ extended: true }));
app.listen(port, () => {
console.log(`Example app listening on port ${port}`)
})
app.post('/',function(req,res){
// console.log(req.body.name)
let name = req.body.name;
let age = req.body.age;
let sound = req.body.sound;
// post 로 넘어온 변수를 mysql에 입력
connection.query(
'insert into animal set name=?, age=?, sound=?',
[name, age, sound],
function(err) {
if (err)
throw err;
console.log('입력')
}
)
})
조회 : 56
