- Получить js
- выборка на стороне клиента (ajax콜 대신.)
var id = JSON.stringify({'taewoong': 'testdata'});
fetch('/testdata', {
method : 'POST',
body : id,
headers: {
'Accept': 'application/json',
'Content-Type': 'application/json'
}
})
.then(function(response){
console.log(1);
if(!response.ok){
console.log('fail');
}
else {
console.log('success');
console.log(1,response);
}
})
- выборка на стороне сервера.
app.post('/testdata', function(req, res){ // 로그인할때 유저정보 받아옴.
console.log('post fetch call');
var a = req.body; // { taewoong: 'testdata' }
var c = 'codestates';
var d = 9994499449;
res.send('aaaa');
// mysql과 연결, 연결 에러 체크.
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : ''
});
connection.connect(function(err){
if(err){
console.log('mysql connect error',err);
}
});
connection.query('use test;',function(err){
if(err){
console.log(err);
}
});
connection.query('insert into cats (name, owner, birth) values (' + connection.escape(b)+ ','+ connection.escape(c) +',222222);', function(err){
if(err){
console.log(err);
}
})
connection.query('select * from cats;',function(err,result,fields){
if(err){
console.log(err);
}
console.log('result',result);
})
// connection.end();
})