Posted
on November 22, 2017, 12:35 pm,
by admin,
under
apache,
tips.
RewriteCond %{HTTP_HOST} !^www\.
RewriteCond %{HTTPS}s on(s)|offs()
RewriteRule ^ http%1://www.%{HTTP_HOST}%{REQUEST_URI} [NE,L,R] |
Posted
on September 22, 2017, 12:56 pm,
by admin,
under
mysql.
SELECT COUNT(*) FROM information_schema.TABLES WHERE table_schema = 'databasename'; |
Posted
on September 19, 2017, 2:57 pm,
by admin,
under
mysql.
Former practice:
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci; |
Current practice:
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; |
Posted
on September 11, 2017, 11:51 am,
by admin,
under
mail.
Open /etc/postfix/main.cf file:
bash# vi /etc/postfix/main.cf |
Append / modify line as follows to bind to localhost (127.0.0.1) only:
inet_interfaces = 127.0.0.1 |
Type the following to restart Postfix:
bash# /etc/init.d/postfix restart |
Posted
on August 23, 2017, 10:35 am,
by admin,
under
php.
<?php
function memoryChecker($variable) {
echo 'in function: '.memory_get_usage()."\n";
}
echo 'before function: '.memory_get_usage()."\n";
$var = "hello world\n";
memoryChecker($var); |
Posted
on August 18, 2017, 10:27 am,
by admin,
under
php.
PhpStorm->Code->Reformat Code
or
Ctrl+Shift+Alt+L and click Reformat file
Posted
on August 14, 2017, 11:44 am,
by admin,
under
git.
Checkout from other branch
git checkout develop /path/to/file.php |
Checkout from HEAD
git checkout HEAD -- /path/to/file.php |
Posted
on August 2, 2017, 8:41 am,
by admin,
under
php.
Before PHP 7:
if (isset($inputData)) {
$param = $inputData;
} else {
$param = 'default';
} |
In PHP 7:
$param = $inputData ?? 'default'; |
or
$param = $inputData ?? $someData ?? 'default'; |
Posted
on July 27, 2017, 12:46 pm,
by admin,
under
css.
ol {
counter-reset: list;
}
ol > li {
list-style: none;
}
ol > li:before {
content: counter(list) ") ";
counter-increment: list;
} |
Output:
1) Number1
2) Number2
3) Number3
Posted
on July 18, 2017, 8:44 am,
by admin,
under
git.
git reset --hard origin/develop |