CREATE TABLE day_hit ();
__________________________________


<?php

use Drupal\Core\Routing\RouteMatchInterface;

use Drupal\block_content\Entity\BlockContent;
use Drupal\block\Entity\Block;






/**
 * Implements hook_install().
 *
 *
 *
 *
/**
 * Implements hook_page_attachments().
 */




function visitor_hit_counter_page_attachments(array &$attachments) {
  $base_path=base_path();
  $current_path=\Drupal::service('path.current')->getPath();
  $route_match=\Drupal::service('current_route_match');
  //echo $current_path ;die;
  if (strpos($current_path, '/admin')===0||$route_match->getRouteName()==='<none>')  {
    return;
  }
  if ($current_path!=='/node') {
    return;
  }
  if ($current_path=='/node') {
    $connection=\Drupal::database();
  $current_day =  date('d_m_Y');

/*******************************************************************************************/
     

 $schema = $connection->schema();

if (!$schema->fieldExists('day_hit', $current_day)) {

  $schema->addField('day_hit', $current_day, [
    'type' => 'int',
    'not null' => TRUE,
    'default' => 0,
  ]);
}
  $connection->insert('day_hit')
  ->fields([$current_day => 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();
    }
  }
}