Professional web developer, graphic designer & network tech.
Music listener, player & lover.


For enquiries please contact me here


If you would like to feature on the website as a blogger, please get in touch.

REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.Before;|aShakespeare, William,|d1564-1616.Regex;REGEXP_REPLACE(|aShakespeare, William,|d1564-1616.,'\|.',' ','g')After;Shakespeare, William, 1564-1616.
Rate this blog entry:
Continue reading
46 Hits
0 Comments

Ubuntu Remotely Connect to MySQL Database

In order to remotely access a MySQL database in Ubuntu it's necessary to edit the following file; /etc/mysql/my.cnf Find the following line; bind-address = 127.0.0.1 Comment it out, and change it to the following; #bind-address = 127.0.0.1 bind-address = 0.0.0.0 You then need to restart the MySQL service using the...
Rate this blog entry:
Continue reading
55 Hits
0 Comments

PHP 7.1 with Win 10, XAMPP & SQLSRV Driver

​If you're trying to use XAMPP on Windows and connect to a SQL server using PHP, hopefully the following will help.Firstly download XAMPP for Windows (32 bit). Follower the installer, default options.Then download the Microsoft Drivers 4.3 for PHP for SQL Server.  Extract the contents of this download to your PHP extensions directory...
Rate this blog entry:
Continue reading
191 Hits
0 Comments

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date.Install OpenSSH server on the OS.It's also a good idea to make a copy of the default SSH configuration, so that if you ever mess up your SSH settings you can revert to the original.That's all you need in order to get SSH working. You should now be able to use a program like Putty in order to connect to the remote OS...
Rate this blog entry:
Continue reading
211 Hits
0 Comments

Server Side Events with MySQL and PHP

​I wanted to build an application that would display a 'real time' feed of data on my web page.I had access to a MySQL database that contained a 'transactions' table, this table received numerous events every second. I needed to display the transactions in real time (or close enough). Not only did I need to display the live data, but I also wa...
Rate this blog entry:
Continue reading
236 Hits
0 Comments

Phoca Download Empty Categories

Phoca Download is am amazing free document repository for Joomla. However I found one feature lacking, when a category was empty (contained no files), there was no obvious message to the visitor - there was simply the category name and a blank page.I always thought there should be a message 'Oops - nothing here!', or similar.To save you some time, ...
Rate this blog entry:
Continue reading
679 Hits
0 Comments

Chrome “disable developer mode extensions” pop up

This is how to get rid of that popup appearing every time you create your own local extension in Chrome.Create a .bat file and name it `DevWarningPatch.bat`. Save this to the desktop.Add the contents below to the bat file.Make sure to close Chrome and end all chrome.exe processes. Rightclick the batch file and run it as administrator: it will find ...
Rate this blog entry:
Continue reading
13486 Hits
0 Comments

Laravel and XAMPP

Instructions on how to get up and running with Laravel on an XAMPP environment.Assuming XAMPP has already been installed, the steps involved are;​download composer from here and install it https://getcomposer.org/download/create a folder in htdocs named 'laravel'open a command prompt and cd to this newly created directory cd c:\xampp\htdo...
Rate this blog entry:
Continue reading
1495 Hits
0 Comments

Omeka Install & Setup LAMP

Having worked with Omeka the past few days I'll explain how to set it up on a LAMP stack. Firstly, what is Omeka? Well, taken from their website;Omeka.net is web-publishing platform that allows anyone with an account to create or collaborate on a website to display collections and build digital exhibitions. No technical skills or special server req...
Rate this blog entry:
Continue reading
1314 Hits
0 Comments

A Very Chrome Kiosk

I recently had to create a web application that would be used on a public touch screen kiosk. The kiosk had be be secure, and require certain custom functionality - explained below.The web app would be built using html/php and running on a LAMP stack, nothing too advanced. The most important thing regarding the kiosk way that it offered a...
Rate this blog entry:
Continue reading
1175 Hits
0 Comments

Java Keytool Keystore Commands

Here's a list of some useful Java keytool keystore commands;Java Keytool Commands for Creating and ImportingThese commands allow you to generate a new Java Keytool keystore file, create a CSR, and import certificates. Any root or intermediate certificates will need to be imported before importing the primary certificate for your domain.Generate a J...
Rate this blog entry:
Continue reading
983 Hits
0 Comments

SSL Certs & Apache Tomcat

​Some tips on dealing with SSL Certificates and Apache Tomcat. If you have to renew your SSL cert or install a new one hopefully these instructions will help.I'll be using Apache Tomcat 7, so the steps may differ with other servers.Firstly you have to generate a CSR on the server (basically a single file), and then send this to whoever you are plan...
Rate this blog entry:
Continue reading
685 Hits
0 Comments

FTP Users & Windows Server 2012

In order to add FTP users to Windows Server 2012 r2 follow these steps. This example users XAMPP Control Panel v3.2.1 however the process is the same for other versions.Firstly open the XAMPP control panel as an administratorInstall the Filezilla Module as a service by clicking the 'Service' box to the left of the 'Module' nameThis will ask you to ...
Rate this blog entry:
Continue reading
691 Hits
0 Comments

Netflix Stuck at 25%

Does your Netflix shows stop at 25% too? Seems to be a common issue that is effecting many people however Netflix are unable to provide a solution. Restarting the app, box, internet connection, cache, settings etc seems to have no effect. Perhaps it's related to the make/model of tv? Nope. Leads changed? Yep. Able to Chromecast? Yep. The frust...
Rate this blog entry:
Continue reading
1948 Hits
0 Comments

XAMPP or WAMP

Considering some web development work with PHP, MySQL and Apache and not sure which to go for? I've gathered some useful information that hopefully should help in the decision making.WAMPP is available only for Windows. XAMPP is available for multiple OS's.Obviously if you want to use WAMP you need to use Windows, otherwise the choice is prett...
Rate this blog entry:
Continue reading
905 Hits
0 Comments

Joomla! 3.4.5 Released

​Joomla! 3.4.5 is now available. This is a security release for the 3.x series of Joomla which addresses a critical security vulnerability. Joomla strongly recommends that you update your sites immediately. This release only contains the security fixes; no other changes have been made compared to the Joomla 3.4.4 release. Version 3.4...
Rate this blog entry:
Continue reading
567 Hits
0 Comments

Google Opinion Rewards

​A pretty east way to earn some free Google credit.Google Opinion Rewards is a survey app from Google that pays you for filling out short surveys. All you need to do is download and install the app, then fill out some basic info about yourself. Once you are setup, surveys randomly show up here or there focusing on a variety of topics. Some are...
Rate this blog entry:
Continue reading
581 Hits
0 Comments

Web Server /var/www Permissions

Changing the permissions of web /var/www folder in Ubuntu.

 

Rate this blog entry:
Continue reading
686 Hits
0 Comments

Server Performance With perfmon

How to monitor server performance with perform.

Rate this blog entry:
Continue reading
514 Hits
0 Comments

Error Handling via PHP

Instructions on setting up error logging via PHP.

 

Rate this blog entry:
Continue reading
575 Hits
0 Comments