node.js + mysql Query from url

Subburaj

I am new to this node.js. I am using mysql in my node.js. From the url i am constructing sql query. With 1 parameter its working fine.

The URL:

http://ipaddress:3002/users/Kappalur

By using the following code i extracted the Kappalur and its working fine:

app.get('/users/:level', function (req, res) {

connection.query("select * from levels where level4= '"+req.params.level+"'", function(err, rows, fields) {
res.writeHead(200, { 'Content-Type': 'application/json'});
            res.end(JSON.stringify(rows,null,"\n"));

Now my requirement is i want to make "level4" to be dynamic..

Consider now the url be:

 http://ipaddress:3002/users/level4/Kappalur

Now how can i change the above code to get the 2 parameters from url. Help me to solve this..Thanks in advance.

zavg

As I understood you are using express framework for node.js.

To retrieve multiple URL parameters use just the same pattern as that you have used in your post's code snippet:

app.get('/users/:level/:name', function (req, res) {
    var level = req.params.level;
    var name = req.params.name;

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Node.js - return value from MySQL query

From Dev

Prevent node.js process from dying on MySQL query error

From Dev

node.js query mysql database from view possible?

From Dev

How to return a JSON object from a mySQL query in node.js

From Dev

Node.js MySQL query execution flow

From Dev

Node JS - mysql - querying inside of a callback of a query

From Dev

Nested query in node js using mysql

From Dev

Node JS MySQL query function not returning result

From Dev

node js mysql query where id = ARRAY?

From Dev

node js: check mysql connection before a query

From Dev

Node.js parsing error with mysql query

From Dev

Remove slashes in node js mysql query

From Dev

Node.js: MySQL query with multiple variables

From Dev

mysql query works in phpmyadmin but not in node.js

From Dev

Node.JS MySQL waiting for query results

From Dev

node.js Count MySQL Query with LIMIT

From Dev

Node.js MySQL Query Error

From Dev

Getting child node count from mysql query

From Dev

Query ElasticSearch From Node.js

From Dev

Using variables in a node.js mysql-node query

From Dev

Query not working using node.js node-mysql

From Dev

Node.js, parse filename from URL

From Dev

node.js download image from url

From Dev

Socket.io, Node.js: How can a javascript variable be passed to mysql query from in a javascript.js?

From Dev

Return query result state from PostgreSQL query in node.js

From Dev

MySql Insert error from node Js

From Dev

Node JS live result from MySQL

From Dev

unable to get url as query string parameter in node express js

From Dev

node.js url search/query portion is empty