Enable Https by self-signing certification.

Run make-ssl-cert command
> sudo make-ssl-cert generate-default-snakeoil
will created 2 files in following directory.
    - /etc/ssl/certs/ssl-cert-snakeoil.pem
    - /etc/ssl/private/ssl-cert-snakeoil.key

Open /etc/apache2/site-avilable and find and modify with below line (with above certs paths).
        SSLCertificateFile    /etc/ssl/certs/ssl-cert-snakeoil.pem
        SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key

> sudo a2ensite default-ssl

> sudo a2enmode ssl

> sudo systemctl restart apache2

Open https://localhost

Comments

SQL_CALC_FOUND_ROWS command fetch row count without limit

select SQL_CALC_FOUND_ROWS from <tablename> where flag = 1 limit 10 and then select found_rows();

Splitting Comma-Separated Values In MySQL

CREATE TABLE numbers (n INT); INSERT INTO numbers VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), select id, substring_index( substring_index(email_recipients, ',', n), ',', -1 ) as email from dashboards join numbers on char_length(email_recipients) - char_length(replace(email_recipients, ',', '')) >= n - 1 Reference Site : https://www.sisense.com/blog/splitting-comma-separated-values-in-mysql/

Sublime Syntax - Convert .tmLanguague file to .sublime-syntax file

You need to save it in the Packages folder hierarchy for ST to pick it up - you can try Tools -> Developer - New Syntax, paste in the tmLanguage and save it in the folder ST recommends (Packages/User) as <packagefile>.tmLanguage , then Tools -> Developer -> New Syntax From <packagefile> .tmLanguage.

Shanky Phoenix

Search This Blog