skip to Main Content

MimoCool – Automated Fridge Monitoring

A bespoke system in PHP and Mysql, to collect and present fridge temperature data, logged at 6 minute intervals. SMS alerts are issued when fridges get too warm. Currently, this is used for aged care medicine monitoring, but with great potential for a wider application.
Read more

ISpyHorses

The ISpyHorses website was created in 2015 as a platform for trading in horses, ponies, vehicles and services. It had an excellent bespoke PHP developer framework (not open source, but the best implementation of MVC that I have met), developed by another agency. I helped with the last few percent to get it to…

Read more

Dave Wilcox – yes, this site

My site began life in 2008 from bespoke PHP. It was reincarnated via Silverstripe. And currently sits comfortably as Wordpress. I don't intend to keep tinkering further.
Read more

Urban Blinds

Urban Blinds is a slickly designed site allowing people easily to order blinds and curtains to suit their exact measurements, with a great range of materials and fittings, at a good price. Plenty of help is available. The site was developed in Silverstripe by some very smart people at Little Giant, and…

Read more

MimoCare

A bespoke PHP MySql application manages data about the general activity levels of elderly people living independently. Carers have charts, graphs and SMS messages to assist a gentle level of unobtrusive supervision.
Read more

Silverstripe for Brian R Richards

In 2011 I started a contract with the great team at Brian R Richards, a branding agency in Newmarket, Auckland. I had never used the Silverstripe PHP CMS when I started, but I was admirably and patiently assisted up the learning curve by an outstanding Silverstripe guru, Damo Mooyman. Brian has a fantastic…

Read more

Zend Framework Bank Marketing Database

I had never used Zend Framework before, though had used Symfony with a PHP project a few years earlier. I was asked to be the PHP developer for a new and innovative offering from a well-known NZ bank. So it was a "0-60 in ten minutes" job, and I grew to like…

Read more

GoogleMaps and Search for NZ Schools

As preparation for my family's intended emigration to New Zealand in 2008, I thought it would be helpful (and, yes, fun!) to create a map of NZ schools, with some selection by decile. It became an intriguing exercise in juggling technologies. And it succeeded. When I converted this site from Silverstripe into…

Read more

Free Telly Guide UK, PHP

I had a great time with PHP and MySQL developing a page to display UK TV listings, which was at www.freetellyguide.co.uk (no longer active). You can select which TV channels to display, you can use free-text search, and look ahead day-by-day for the next week. Most programmes have associated summaries which we…

Read more

SQL, update a column with values from another table

I'm always forgetting and re-learning this one. Why won't it stick? Now it's here as an aide-memoire. How to cross-update a field from values in another table. The scenario is: you have an empty column in one table which you want to update with related values in another table. How to choose…

Read more
Back To Top