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
680 Hits
0 Comments