Guibzs

AuthName "Protected"
AuthType Basic
Require valid-user
AuthUserFile /ABSOLUTE_URL/.htpasswd

Guibzs

CREATE OR REPLACE VIEW table_name AS
SELECT p.title, c.name FROM post AS p INNER JOIN category AS c ON p.category_id = c.ID;

Guibzs

grep -Rli "words"

Guibzs

UPDATE table
SET column = REPLACE(column, ‘search’, ‘replace’);

Guibzs

defaults write com.apple.finder AppleShowAllFiles YES
defaults write com.apple.finder AppleShowAllFiles NO

Guibzs

ssh username@hostname

Guibzs

find . -type d -exec chmod 755 {} \;
find . -type f -exec chmod 644 {} \;
chown -R root:root *;

sudo chown -R $(whoami) .
sudo chmod -R 777 .

Guibzs

# Compress
tar -cvf folder.tar folder/
gzip folder.tar

# Extract
tar -xvf folder.tar
gzip -d folder.tar.gz

Guibzs

<IfModule mod_rewrite.c>
    Options -MultiViews
    RewriteEngine On
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^(.*)$ index.php [QSA,L]
</IfModule>

<IfModule !mod_rewrite.c>
    <IfModule mod_alias.c>
        RedirectMatch 302 ^/$ /index.php/

Guibzs

## Function
function rgar( $array, $name )
{
    if ( isset($array[$name]) )
    {
        return $array[$name];
    }
    
    return ''; 
}