Correct HTTP to HTTPS redirect

Hi! I have weird problem - when I have HTTP to HTTPS redirect in my .htaccess

RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]

- my php and MySql code runs twice. I'm logging words, that users search on my site. If it is a first occurance - I INSERT it to the table with counter = 1. If word already exist in the table, then conter +1. When redirect is on, new words get counter=2 from the first search. If I turn off redirect - everything is ok - counter=1.

So, what is the best way to redirect to HTTPS?

I'm using the latest CWP7, PHP 7.2.3, MariaDB 10.2.13. Plain PHP - no frameworks or CMS

hi I use :

RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

Code: [Select]

RewriteCond %{HTTPS} off
RewriteRule .* https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]