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
Post a Comment