jquery - Get data from AJAX request in NodeJS and store in DB -
i have problem getting data client side in nodejs.
on client side i've prepared json data can see in codepen
on server side i'm trying these data client:
var express = require('express'); var mysql = require('mysql'); var app = express(); app.use('/', express.static('../client/app')); app.use('/bower_components', express.static('../client/bower_components/')); var server = require('http').createserver(app); var bodyparser = require('body-parser'); app.jsonparser = bodyparser.json(); app.urlencodedparser = bodyparser.urlencoded({ extended: true }); //mysql connection setup var connection = mysql.createconnection({ host : "localhost", port: "3306", user : "root", password : "", database : "db", multiplestatements: true }); app.get("/cities", function(req, res) { console.log(res.body); //i'm getting nothing var data= { city: req.body.city, country: req.body.country }; var query = connection.query('insert table set ?', data, function(err, res) { if (err) { console.log(err); } else { console.log('success'); } }); console.log(res); }); server.listen(3000, function () { 'use strict'; });
what i'm doing wrong? there way debug nodejs in st? thanks.
please try req.params.city
fetch input data. works in project. however, req.body
use getting data sent through post method.
app.get - use req.params app.post - use req.body
Comments
Post a Comment