Website visits

0

Hello friends I have this information of my visitors to make a Dashboard pretty cool, I am wanting to calculate the time of permanence of the clients in the site, every access that the person gives it writes in the database with this we have the datetime, date and the team also separated. I think of doing an sql query that assumes that if there is an access in a later period of 1h from one record to another account as another visit if you have records of the same ip in a less than 1h interval is the same visit to the website. Can you do this via mysql?

    
asked by anonymous 12.04.2018 / 14:47

0 answers