For all those that may be wondering I have arrived in Auckland, New Zealand and have been here for about two weeks setting up and settling in to the area. I am really enjoying being here and everyone is so friendly and accommodating.
We like the area we are living in and I have been […]
Category Archives: Computing
I have arrived and I am looking for PHP roles
November 17, 2008 – 5:49 am
Windows Cron Jobs using Scheduled Tasks
June 17, 2008 – 5:49 am
Every now and then you end up having to develop on a Windows box. Here are some handy hints for getting your cron jobs up and running.
The user interface for the Scheduled Tasks in Windows can be found at Start > Programs > Accessories > System Tools > Scheduled Tasks.
For performing cron jobs on […]
XAMPP VirtualHosts
June 14, 2008 – 12:08 pm
Here are some hints for those of you that use a XAMPP install for testing your developments on your local machine.
I am using a Windows machine running XP Pro and this is how I setup my VirtualHosts. The conf file you need to amend is located at c:\xampp\apache\conf\extra\httpd-vhosts.conf Open it up in your […]
Installing Agavi on XAMPP Windows
May 18, 2008 – 11:44 am
Having recently heard of the Agavi project from a web framework showdown at a PHP conference in the UK I have decided to trial it. My setup is a WinXP computer with a default install of the latest XAMPP which has thrown up some issues with installing and building Agavi. Please see my […]
Common PHP Mistakes
May 18, 2008 – 6:08 am
A few common PHP mistakes:
Using require_once when a simple require would achieve the same result. Using require uses less system resources and therefore executes more quickly. You should engineer your code so you don’t need to use require_once. The same of course applies to include statements.
Failing to declare variables before attempting to use them.
Don’t use […]
Mobile Browsing
April 14, 2008 – 12:44 pm
I have recently been using the web from my mobile quite a bit. My email is hosted by Google for my domain name so I use their freely available mobile java app (with the blue icon) to view my mail. The best web browser on the mobile is of course Opera Mini. I make no […]
SQL Server 2005 Dump to SQL statements
April 7, 2008 – 8:36 am
Say you have a development environment setup using SQL Server 2005 Express Edition and your customer has a SQL Server 2000 database accessible only via ODBC and you can only run a DB import via a script. How would you do it? Easy you might think just run msdbdump.exe on the command line, […]
MySQL to MS SQL (SQL Server)
March 27, 2008 – 9:58 am
Recently I produced a website for hosting on a Linux box running with PHP5 and MySQL5. Well it now needs to move over to a Windows 2003 server with MS SQL as the DB and IIS as opposed to Apache.
Install MyODBC
Install SQL Server 2005 Express
Using MS SQL Server Management create a new database. (right […]
ISO 3166 Country List
August 21, 2007 – 4:26 pm
Here is a small script that I put together to grab the XML list from the ISO website and convert it into an SQL statement. The idea is that the script can be used to just obtain a list for web projects or it can be setup to run periodically to make sure that […]
Geographic Calculations in PHP
December 10, 2006 – 12:27 am
Recently I have been involved with a project that maps yachts during an ocean race, which got me thinking about basic calculations and conversions that would be useful to fellow developers. I envisage this being useful in projects leveraging Google or Yahoo maps. For the moment the class performs the following functions:
Calculate the […]
