A website is a powerful tool for churches to advertise who they are, where they are and what they do. It’s also a great medium for Church administration. The Gateway Church uses WordPress to drive our website and I’ve written a powerful administration plugin to help manage Church life. It contains an address book with […]
Continue reading...
The trouble with tutorials on Facebook Application development is that they go out of date so quickly. This one was written 14th Dec 2010. The Facebook developers wiki is pants too! So here’s what I learnt the last few days. I’m assuming you have registered your application to be on http://apps.facebook.com/developers and have the vital […]
Continue reading...
I’m running a conference booking system at www.togetherconference.com and we need to send out lots of emails to delegates and potential delegates. Our host uk2.net only allows 100 emails per hour from the website, so I needed to find a way of queueing them and sending in batches… First a mysql db table… CREATE TABLE […]
Continue reading...
Duplicating data in a database table is a waste of space, so if table1 has some column information repeated frequently then transfer that to a second table and use an id to store in table1 – that’s called normalisation As an example, I have a conference booking system where delegates where all booking in from […]
Continue reading...
I recently wanted to find the length of the longest string from a column in a mysql table. SELECT MAX(LENGTH(c1)) FROM t1 will give a different result to SELECT LENGTH(MAX(c1)) FROM t1 The first one gives the correct result! Just wanted to save you some hours!
Continue reading...
I wanted a simple and fast PHP browser detector for a script recently. Most scripts are either very out of date or huge and look for every single browser possible. Here’s a simple one that will return the major ones. function browser_detect(){ //simple major browser detection //returns an array 0=>browser name and version,1=>browser name, 2=>Version […]
Continue reading...