Author Archives:
Using OAuth2 for Google APIs with PHP
I’ve written about Google and OAuth before, but that was OAuth v1.0, and they are introducing OAuth2 for their newer APIs; in this example I was identifying myself in order to use the Google Plus API (which turns out not to do anything you’d expect it to do, but that’s a whole separate blog post!). Continue reading
Using JIRA’s REST API to Create a Dashboard
- crazy about APIs
- living with some accessibility issues
Put these two things together and what do you get? Actually don’t answer that! Today what you get is an example of integrating with JIRA’s REST API, because their recent “upgrade” locked me out of the issue listings pages completely and I really do need to be able to see a list of bugs! Their bug editing screen is quite usable, so it’s just the list that I need here, but you could easily call their other API methods as you need to. Continue reading
SQL JOINing a Table to Itself
Consider that tried-and-tested example: employees and managers. Here’s the staff
table from the database (today’s imaginary data isn’t particularly imaginative, sorry):
mysql> select * from staff; +----+------------+-----------+------------+ | id | first_name | last_name | manager_id | +----+------------+-----------+------------+ | 1 | Hattie | Hopkins | 4 | | 2 | Henry | Hopkins | 4 | | 3 | Harry | Hopkins | 5 | | 4 | Helen | Hopkins | NULL | | 5 | Heidi | Hopkins | 4 | | 6 | Hazel | Hopkins | 1 | +----+------------+-----------+------------+ 6 rows in set (0.00 sec)
5 Things To Do With A Training Budget of Zero
Ideas of March: Write and Read
Speaking at Leeds PHP

Watch Over Long Running Processes with Supervisord
Generating Callgraph with XHGUI
failed to shell execute cmd=" "" -Tpng"
Thoughts on Running an Open Source Project
Continue reading