javascript - Node.js: Write to database when page loads -


i have link on home page. whenever user clicks on on link , loads page, want collect user-agent details , save in database.

i know can done php this:

<?php     mysql_connect('server', 'username', 'password');     mysql_select_db('databasename');     $cquery = "insert tracktable (source, browser, datetime) values (''" . mysql_real_escape_string(stripslashes($_get['q'])) . "', '" . mysql_real_escape_string(stripslashes($_server['http_user_agent'])) . "', '" . mysql_real_escape_string(stripslashes($_server['remote_addr'])) . "', now())";     mysql_query($cquery);     ?> 

is possible node?
or have collect information , post request node js server. write database.

it simple if using express.

just use req.headers['user-agent'] access user agent information.

it easier if install useragent npm

https://github.com/biggora/express-useragent

here example github link

var http = require('http')   , useragent = require('express-useragent');  var srv = http.createserver(function (req, res) {   var source = req.headers['user-agent'],   ua = useragent.parse(source);   res.writehead(200, {'content-type': 'text/plain'});   res.end(json.stringify(ua));  //ua json object has user agent information can used store in db }); 

srv.listen(3000);


Comments

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

google shop client API returns 400 bad request error while adding an item -