How do I count no of views for every page in a website

I don't use ASP.NET at all, but, in principal, it should be the same.

You create a function that's executed (in the header, if possible) that updates a record in the database. If ASP.NET is capable, have it ask the page for its own name and it can use that to insert/update records with the count.

Using this concept, you only need to make the table and wait - the entries will be put in for you and counted.

You check for the existence of the page-name entry in your table. If it finds it, increment count via an UPDATE. If it doesn't find it, INSERT a new record with count = 1;

The only labor would be inserting the function call into each of the pages you wish to monitor. Your editor may allow you to do all the pages at once if you ask it correctly (don't do this wrong!!!).

No - let the code you write do the work for you! PHP lets me get the name of the page I'm requesting when it's requested for use on the server side even before the page is sent to the client. You don't have to customize the call for each page - the page, itself, does that for you.

1 - Test for the existence of the page in your table (by name, I suppose).*
2 - If the page exists then increment the counter
3 - If the page does not exist then add the page to your list and set the counter to '1'.

Note that this will take care of itself whenever you add a new page - automatically - with no effort on your part other than the function call at the top of each page. You do not have to add a single entry.


* SQL has an existence test. Alternative, you can request the record count for a given page (by name). If the count is 0, add the page, otherwise, increment its counter.