Sunday, 23 April 2017

query to retrieve most visited websites from browser history db

I have database of browser history. The history table has title,url and visits. The visits field tells how many times the url has been visited. Data in url field is as follows:

  • www.google.com/webhp?source=android-home&gws_rd=cr&ei=AJ6xWKbULcOTmQGAua7QAg
  • www.google.com/search?source=android-home&site=webhp&oq=gggggff&aqs=mobile-gws-lite..&q=gggggff
  • www.google.com/webhp?source=android-home&gws_rd=cr&ei=-Z6xWJSjGIzrmAH10onYDA

Now i am trying to count visits at www.google.com. My ultimate goal is to get most visited websites from databse. I am working in node.js so it will be better if you provide me code in javascript



via Syed Noorullah

No comments:

Post a Comment