Writing a PHP Coda Plugin

Sound like a right pain in the arse? It’s surprisingly simple actually….

The steps to creating a simple locally run php Coda plugin:

You must have php installed and running locally.
Start the plugin file with theses lines:

#!/usr/bin/php -q

(no space between < and ?php) Where /use/bin/php is the path to you local php install Continue reading

Sending To Multiple Twitter Accounts From One Device using SMS (text message)

Update: You can now signup and help in testing. http://bucket.harrybailey.com

I have been working on something recently to make my Twitter life a lot easier.

I don’t have an iPhone and I’m not planning one getting on in the near future, so I send sms messages to Twitter to update my status. Simple enough when you have one Twitter account. You just add your device ( phone ) to Twitter, tell it when to send you sms messages, and what to send you and off you go.

Sadly you can only apply a device to one Twitter account and can only send updated to one account from your device via sms.

Until now!

Continue reading

MySQL Multiple Primary Key Columns In A Table

Some database management tools refuse to admit you can add multiple primary key columns to one table, so you might have to do it with direct sql syntax ( deep intake of breath ).

Multiple primary keys make ‘ON DUPLICATE KEY UPDATE column = column + 100’ type queries a shed load more flexible.

Anyway, on with the code:

ALTER TABLE tablename ADD PRIMARY KEY (column_one, column_two)

And there you have it. Robert’s your fathers brother.

Internet Banking and Webhooks

Why is it that banks are always 5 years behind when it comes to the internet?

For those not in ‘the know’, a ‘webhook’ is where you define a url ( or address ) you would like to be notified when certain things happen on a website you use.

As an example, you tell PayPal to notify your payment confirm url when your business account receives a payment. They then send the payment details to that url so an automated script can do something with them. Usually tell you to send the item they bought.

Continue reading