Show frequently view product history ?

Question

How to while click the link button Show frequently view product history?

For Example 1: Samsung,Nokia,Lava like that i want show which product mostly view Customers in that product.

Example our c-sharp corner also how many developer view the particular questions view count is there i want same concepts coding.

Please Send me With Example.

Senthilkumar · Answer

Hi In the page load of preview product page you need to store the hits. S.No UserID ProductID IPAddress ViewedDate 1 25 45 120.12.1.0 3-3-2012 2 23 46 120.122.3.4 4-3-2012 When the user refresh again and again then you can avoid the duplicates by checking the details. SELECT TOP 5 ProductID COUNT(ProductID) FROM ProductsView GROUP BY ProductID Then you will get the maximum viewed top 5 products. Other than this you can use the google script to see the page views.

Senthilkumar · Answer

Hi ViewedDate DATETIME DEFAULT GETDATE() If you give like this then it will automatically update the date and time when you do insert and update.

magesh manavalan · Answer

if you have please send me google script to see the page views.

magesh manavalan · Answer

thanks. how to insert date automatically my tables. should not give date in front end.