0
Hello friends I have this information of my visitors to make a very cool Dashboard, I am wanting to calculate the time of permanence of customers on the site, to each access that the person gives it records in the database with that we have the datetime, date and the team also separate. I think of making an sql query that assumes that if there is an access at a later time of 1h from one record to another account as another visit if you have the same ip records at a shorter time interval of 1h is the same visit to the website. You can do this via mysql ?
You could create some function that triggers an update by picking the time you entered and adding +5 minutes of 5 in 5 minutes...
– Josimara
great idea, make a query to see if there is customer registration and follows the desired pattern, I will change this rule. Thanks
– Fernando
Problem solved Thank you very much friend
– Fernando