Javascript Language Translation
On a project I am working on, I need to enable language translation. Thinking about it, turned into something quite complicated. But then I found the Google Language API which…
MySQL Incorrect String value “x/80”
MySQL Incorrect String value replication error. We use ANT for releasing versions of our PHP applications. Its very smart and takes a lot of the problems related to releases out…
Help in using Ubuntu Terminal Console
Help in using Ubuntu Terminal Console Remote connection To ssh to another Lunix terminal, use this command: ssh username@host -p port The default SSH port is 21, but you could…
Ubuntu Console commands for SVN
Console commands in Ubuntu for use with subversion Checkout a branch: svn checkout url@revision path To update your local source: svn up And to commit a single file: svn ci…
REGEX – Remove Letters from string
Removing letters from a string using Regular Expressions. Very simple. but brain bending – All I wanted to do was remove a prefix from a string. The prefix was always…
TabIndex in HTML
TabIndex is an attribute to HTML elements that tells the browser which control takes focus next when TAB is pressed. <input id="one" tabindex="3" /> <input id="two" tabindex="1" /> <input id="three"…
Dependency Injections
Dependency Injections When creating PHP classes, particulary when utilising Unit tests, its a good idea to use dependancy injections. This enables us to use a robust reliable class which is…
MySQL REPLACE
I’d not come across REPLACE as a MySQL function before. I’d always used a combination of concatination of LEFTs and RIGHTs and the occasional MID. Unbelievable that I’d not found…
MySQL Group Concat
What is MySQL’s GROUP_CONCAT function for? How often have you wanted a comma separated list of values in a table of results. Say you had a list of trainers in…
MySQL Replication Guide
I have had to install a few instances of MySQL replication, and its never as simple as you expect it to be. However, I have written a simple HOWTO to…