How to create a new helper in Yii2 framework: Create a new file “Utils.php” in “app-basic\helpers” or in other folder, location is up to you, but keep things organized! <?php namespace yii\helpers; use Yii; class Utils { public static function
PHP short tags: if/else
Alternative syntax for control structures. PHP offers an alternative syntax for some of its control structures; namely, if, while, for, foreach, and switch. In each case, the basic form of the alternate syntax is to change the opening brace to
Raspberry PI install RPi.GPIO
To install on raspbian: apt-get -y install python-rpi.gpio raspberry-gpio-python package provides a class to control the GPIO on a Raspberry Pi. To get started with RPi.GPIO, it would be worthwhile reading the examples here. Note that this module is unsuitable for real-time
Linux: Netstat Command Examples
Netstat command displays various network related information such as network connections, routing tables, interface statistics, masquerade connections, multicast memberships etc. List All Ports (both listening and non listening ports) #netstat -a root@localhost:~# netstat -a | more Active Internet connections (servers
mysqld Option/Variable Reference
This table that lists every MySQL Server option or variable, what version it was introduced or deprecated in, whether it’s dynamic or not, whether variables have session/global/both scope, and links to the version-specific documentation for that variable. Name Intr Depr
MySQL Trigger – after insert trigger
I want to populate automaticaly another table when new data is inserted: For table “source_table” define a after insert trigger DELIMITER $$ CREATE TRIGGER `source_table_AINS` AFTER INSERT ON `source_table` FOR EACH ROW — Edit trigger body code below this line.
MySQL Utilities – Brief overview of command-line utilities
MySQL Utilities This is a brief overview of the MySQL command-line utilities. See their respective manual pages for further details and examples: mysqlauditadmin Monitor the audit log. Copy, rotate, and configure the audit log mysqlauditgrep Search the audit log. Output results to
MySQL replication: PURGE BINARY LOGS and RESET MASTER
On MySQL master, “RESET MASTER” command, deletes all binary log files listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. This statement is intended to be used only
Raspberry Pi : XBMC 12.1
XBMC 12.1 makes full use of iPhone 5, improves Raspberry Pi player and more! About a month and a half after the release of XBMC 12.0, we are happy to announce XBMC 12.1 with substantial fixes for 12.0 across all
GNUPG – gpg encrypt files
GNU Privacy Guard (GnuPG or GPG) is a GPL Licensed alternative to the PGP suite of cryptographic software. PGP encryption uses a serial combination of hashing, data compression, symmetric-key cryptography and finally public-key cryptography; each step uses one of several supported algorithms. Each public key is bound to