getPath(); $route_match=\Drupal::service('current_route_match'); //echo $current_path ;die; if (strpos($current_path, '/admin')===0||$route_match->getRouteName()==='') { return; } if ($current_path!=='/node') { return; } if ($current_path=='/node') { $connection=\Drupal::database(); $current_day=date("d-m-Y"); $result_perday=$connection->select('visitor_count_perday', 'vcd') ->fields('vcd', ['day', 'day_count']) ->condition('day', $current_day) ->execute() ->fetchAssoc(); if ($result_perday) { $connection->update('visitor_count_perday') ->fields([ 'day_count'=>$result_perday['day_count']+1, ]) ->condition('day', $current_day)//Condition added here ->execute(); } else { $connection->insert('visitor_count_perday') ->fields([ 'day'=>$current_day, 'day_count'=>1, ]) ->execute(); } $query=$connection->select('visitor_hit_counter', 'v') ->fields('v', ['id', 'count']) ->condition('path', $current_path) ->execute() ->fetchAssoc(); if ($query) { $connection->update('visitor_hit_counter') ->fields(['count'=>$query['count']+1]) ->condition('id', $query['id']) ->execute(); } else { $connection->insert('visitor_hit_counter') ->fields(['path'=>$current_path, 'count'=>1]) ->execute(); } } }