isogram

#301 Redirects for .htaccess

#Redirect a single page:
Redirect 301 /pagename.php http://www.domain.com/pagename.html

#Redirect an entire site:
Redirect 301 / http://www.domain.com/

#Redirect an entire site to a sub folder
Redirect 301 / http://www.domain.com/subfolder/

isogram

user nginx;
worker_processes 1;

error_log /var/log/nginx/error.log;
pid /var/run/nginx.pid;

events {
    worker_connections 1024;
    use epoll;
}

isogram

# Minute   Hour   Day of Month       Month          Day of Week        Command    
# (0-59)  (0-23)     (1-31)    (1-12 or Jan-Dec)  (0-6 or Sun-Sat)                
    5       8          *             *                Sat              /usr/bin/find

isogram

SELECT
	t1.user_id,
	t1.user_uuid,
	t1.first_name,
	t1.last_name,
	t1.user_name,
	IF (t2.follow_status, 1, 0) AS is_following,
	IF (t3.follow_status, 1, 0) AS is_followers
FROM
	t_user t1

isogram

1. Catch hashtag exclude starting and ending with underscore
   (?:\s|^)(?:#(?!(?:\d+|\w+?_|_\w+?)(?:\s|$)))(\w+)(?=\s|$)
2. Catch hashtag include starting and ending with underscore
   (?:\s|^)(?:#(?!\d+(?:\s|$)))(\w+)(?=\s|$)
3. Catch repeating words (only catch 1 if duplicate) (?!.*\b\1\b)

You can test regex at https://regex101.com/

isogram

Image Processing with ImageMagick

• Resize and crop with mogrify
  mogrify /path/to/folder/ -format jpg -resize "64x64^" -gravity center -crop 64x64+0+0 +repage *.jpg
mogrify /path/tp/folder/ -format jpg -thumbnail 64x64^ -gravity center -extent 64x64 *.*

isogram

step 1 : take a backup

mysqldump --lock-all-tables -u root -p --all-databases > dump.sql

step 2 : remove old mysql

sudo apt-get remove mysql-server
sudo apt-get autoremove

isogram

/**
 * $.parseParams - parse query string paramaters into an object.
 */
(function($) {
var re = /([^&=]+)=?([^&]*)/g;
var decodeRE = /\+/g;  // Regex for replacing addition symbol with a space
var decode = function (str) {return decodeURIComponent( str.replace(decodeRE, " ") );};
$.parseParams = function(query) {
    var params = {}, e;
    while ( e = re.exec(query) ) { 

isogram

Fix AppServiceProvider Laravel 5.1 not firing

1. php artisan clear-compiled
2. Delete file service.json in bootstrap/cache
3. Change $defer property to false
4. Check AppServiceProvider, is it working now?
5. Change back $defer to true again

isogram

select
STR_TO_DATE(concat(tgl, ' Monday'),'%x%v %W') date_start,
STR_TO_DATE(concat(tgl, ' Sunday'),'%x%v %W') date_end
from
(
select
date_format(updated_at, "%Y%v") as tgl,
count(1) as counter
from table
group by tgl