Skip to content

Instantly share code, notes, and snippets.

Norcoen /
Created Jan 5, 2016 — forked from r-sal/
PHPExcel Notes and code snippets


Creating a new PHPExcel Object.

    $this->PHPExcel = new PHPExcel();

Working with sheets

Creating a new sheet:

Norcoen /
Created Feb 10, 2016 — forked from thomasfr/
iptable rules to allow outgoing DNS lookups, outgoing icmp (ping) requests, outgoing connections to configured package servers, outgoing connections to all ips on port 22, all incoming connections to port 22, 80 and 443 and everything on localhost
# Server IP
SERVER_IP="$(ip addr show eth0 | grep 'inet ' | cut -f2 | awk '{ print $2}')"
# Your DNS servers you use: cat /etc/resolv.conf
# Allow connections to this package servers
View recursive_array_walk_recursive.php
class A
private $ab = 5;
public $ac = 6;
* WARNING: This seems not yet solved
Norcoen /
Created Mar 1, 2016 — forked from christopher-hopper/
Resize a Hard Disk for a Virtual Machine provisioned using Vagrant from a Linux base box to run using VirutalBox.

Resize a Hard Disk for a Virtual Machine

Our Virtual Machines are provisioned using Vagrant from a Linux base box to run using VirutalBox. If the Hard Disk space runs out and you cannot remove files to free-up space, you can resize the Hard Disk using some VirtualBox and Linux commands.

Some assumptions

The following steps assume you've got a set-up like mine, where:

Norcoen /
Created May 2, 2016 — forked from weakish/
The Six Most Common Species Of #Code #java #fun
Norcoen /
Created Jun 20, 2016 — forked from KartikTalwar/
Rsync over SSH - (40MB/s over 1GB NICs)

The fastest remote directory rsync over ssh archival I can muster (40MB/s over 1gb NICs)

This creates an archive that does the following:

rsync (Everyone seems to like -z, but it is much slower for me)

  • a: archive mode - rescursive, preserves owner, preserves permissions, preserves modification times, preserves group, copies symlinks as symlinks, preserves device files.
  • H: preserves hard-links
  • A: preserves ACLs
Norcoen / flatArray.php
Created Nov 27, 2015
php function that Recursively converts nested array into a flat one with preserved keys connected with connector.
View flatArray.php
* Recursively converts nested array into a flat one with keys preserving.
* @param array $result Resulting array
* @param array $array Source array
* @param string $prefix Key's prefix
* @param string $connector Levels connector
function flatArray(array &$result, array $array, $prefix = null, $connector = '.') {
foreach ($array as $key => $value) {
View php-full-depth-case-insensitive-file-exists.php
* Single level, Case Insensitive File Exists.
* Only searches one level deep. Based on
* @param string $file The file path to search for.
* @return string The path if found, FALSE otherwise.
Norcoen /
Created Sep 18, 2018 — forked from mohakshah/
Builing ZFS on Raspberry Pi 3 running Rasbpian


This is a tutorial for building and installing the latest release version (0.7.3 as of writing) of "ZFS on Linux" on a Raspberry Pi 3 running Raspbian Stretch. Specifically, we'll be building the dkms version of ZoL, which saves you the hassle of re-compiling the kernel modules after every kernel update. Even though ZoL added support for building dkms packages for debian in version 0.7.3, the build process on a Raspberry Pi 3 is not quite straight-forward. Hopefully, these instructions will make it easier.


  1. Install the build dependencies.
$ sudo apt-get update
$ sudo apt-get install build-essential autoconf libtool gawk alien fakeroot
$ sudo apt-get install dkms zlib1g-dev uuid-dev libattr1-dev libblkid-dev libselinux-dev libudev-dev libssl-dev parted lsscsi wget ksh
Norcoen / PartialExistsViewHelper.php
Created Oct 14, 2018 — forked from arnekolja/PartialExistsViewHelper.php
TYPO3 Fluid ViewHelper to check if a partial name exists ("My/Partial")
View PartialExistsViewHelper.php
namespace Krbu\Utility\ViewHelpers;
use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;
* Copyright note: Some parts are copied from the Fluid package.
* Usage example:
* <f:if condition="{krbu:PartialExists(partial: 'Category/{}/DetailCol1')}">