How to query from flutter to node js

Question

Hello i have small problem here but i don't know how to solve it I have a data from flutter "townid" what i want is to query using node.js from flutter's post request

//code from flutter app
  Future getB(townId) async{
 var data;
    print(townId);
    final response = await http.post("http://xxx.xxx.xx.xx:3000/selectB",body:{
      "townid": townId.toString()
    });
    data = jsonDecode(response.body);
    return data;
}

//my node js that receive my flutter request 

const express = require('express');
const bodyParser = require("body-parser");
const mysql = require('mysql');
const router = express.Router();
const db = require('./db');
const app = express();
app.use(bodyParser);

router.post('/selectB', function (req, res) {
      var townid = req.query;  // i dont know if this is the correct way to do this

      db.connect(function(err) {
      //Select all customers and return the result object:
      db.query("SELECT `town_id` as `tid` , `brgy_name` as `brg_name` FROM barangays WHERE `town_id` = $townid ", function (err, result, fields) { // i don't know if this is the correct way to do this
        if (err) throw err;
        res.send(result);
      });
    });
})

Sukhi · Accepted Answer · 2020-04-24 03:00:31Z

0

From the node side, you'll have to fetch the townid as :

var townid = req.body.townid

answered Apr 24, 2020 at 3:00

Sukhi

14.4k7 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Pakz Over a year ago

and in the query part? '$townid' or '${townid}'

Sukhi Over a year ago

1. I don't know node. js in deapth but ${townid} would work. See this for more details. 2. Debug and check what is the content of 'req.body'. It'll throw some light.

Shekar Mudaliyar · Accepted Answer · 2020-04-24 06:29:29Z

0

//node
var townid = req.body['townid']

try this maybe this might work

answered Apr 24, 2020 at 6:29

Shekar Mudaliyar

4964 silver badges4 bronze badges

2 Comments

Pakz Over a year ago

Thank you for answering but its TypeError: Cannot read property 'townid' of undefined

Nico Haase Over a year ago

Please add some explanation to your answer such that others can learn from it

Nomuoja Oghenemaro · Accepted Answer · 2020-06-30 09:58:05Z

0

since the body of post request from your flutter app is body:{"townid": townId.toString()}); you can parse the boy using body-parser and this is what it looks like

 const townid = req.body.townid

answered Jun 30, 2020 at 9:58

Nomuoja Oghenemaro

493 bronze badges

Collectives™ on Stack Overflow

How to query from flutter to node js

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related