The views column is updated even the key is set to the localStorage?

Question

Hi guys i'm trying to make a viewers counter which stores the value of the total viewers visited to the site. For which I'm maintaining a table called counter where i store the value of the viewers. But also I don't want to update the value of the viewers with multiple page refreshes so i drop a key into the localstorage and and during page refresh checks for that key if the key is already set, I just retrieve the value from the database while in case if the key is not present the database value will get incremented by 1.

 if(localStorage.getItem("counter")===null)
     {
        <%
            Connection con = ConnectionManager.getConnection();
            PreparedStatement ps = con.prepareStatement("Select views from counter");
            ResultSet rs = ps.executeQuery();
            long viewers=0;
            if(rs.next())
            {
                viewers = rs.getLong("views");
            }
              viewers = viewers+1;
              ps = con.prepareStatement("update counter set views = ?");
              ps.setLong(1,viewers);
              int update = ps.executeUpdate();

       %>
           var v =document.getElementById("v");
           v.innerHTML = <%= viewers %>;
           localStorage.setItem("counter",<%= viewers %>) ;
     }
     else{

           <%  
              con = ConnectionManager.getConnection();
              ps = con.prepareStatement("Select views from counter");
              rs = ps.executeQuery();
              long counts=0;
              if(rs.next())
               {
                   counts = rs.getLong("views");
               }

           %>

          var v =document.getElementById("v");
          v.innerHTML=<%= counts %>;         
     }

But I can't figure out why the value of the database is also get incremented even if the key is set in the localStorage. Also please suggest me if u have any better idea to do this.

Thanks!

You are mixing server side logic with client-side logic, on server render `localStorage` is always false — Medet Tleukabiluly, Aug 07 '16 at 06:19
I agree with the guy above. You have no idea of what you're doing. — , Aug 07 '16 at 06:20
@MedetTleukabiluly can you tell me how can i implement this idea then.... — palak sharma, Aug 07 '16 at 06:22
Use `jQuery.ajax`, send data to REST endpoint of server, retrieve back and render on page — Medet Tleukabiluly, Aug 07 '16 at 06:27
ok so pls me tell then how can i prevent the ajax hit from the refresh as with every page refresh the $.ajax hit the server and retrieve the data. Should I use cookie there — palak sharma, Aug 07 '16 at 06:32

The views column is updated even the key is set to the localStorage?

0 Answers0