Script to download data from a secure web directory
As part of an import or backup routine you may wish to automate the downloading of a file from a protected web directory. You might have generated a PHP file to download a particular data…
PHP CRUD in a few lines of code
When building back office and administration systems we often we need to provide end users and administrators with access to database tables and the ability to Create, Read, Update and Delete records. Creating a user…
Share your PC’s mouse and keyboard with your laptop
When working on a desktop PC, it’s often useful to run your laptop alongside either just for the benefits of a second monitor, or because you need to use files on the laptop. If this is something…
FreePBX Backups
Where are local backups stored? /var/spool/asterisk/backups
Linux CLI text editor
NANO is a text editor for use in linux terminals (on a server machine, or over SSH connection). Unlike some of the other options, NANO doesn’t require that you know a host of key combinations…
How to: Archive your Google data
Whilst many are still uncomfortable with storing their data in ‘the cloud’, more and more of us are embracing the change and using services such as Google Drive, dropbox etc to our advantage. One of…
Identify data duplication across more than one column (MySQL)
Should you wish to identify data where there is duplicate data in more than one column you can use the query below: This query is useful if duplicates in one column only do not need…
Bring up an interface in CISCO IOS
To bring up an interface in CISCO’s IOS operating system Open a terminal connection to the router/switch, login and enter privilege exec mode… Enter terminal configuration mode: config t Select the interface: int Bring the…
Connecting your PHP application to MSSQL using FreeTDS
The following guide serves to assist with connecting (or re-connecting) your PHP web application running on a LAMP server with an MSSQL database. The following has been tested on Ubuntu 14.04.3 LTS with MSSQL 2008…
How to: Check RAM totals from Ubuntu terminal
Particularly when working with remote servers and virtual machines it can be useful to check your RAM levels and availability. This can be easily achieved by running the following commands from a terminal: $watch -n…