House Bill organiser
Published on
I will write an LJ about America soon, I promise. First though, just a little PHP script I wrote that people might find useful.
Basically, in a house full of CompScis, tonnes of geeky stuff is bound to happen. First off, I’ve set up a house server which will soon be a media centre PC, among other things. Now, on this server I set up a script (better than a spreadsheet!) to organise how much people owe each other with bills and stuff. I had a Google to try and find if anything similar already exists, but I couldn’t find anything, so I made my own (it killed an afternoon).
It’s not designed to be reusable, but it’s at least a start if you want to do something similar (and let’s face it, if you do, you’re probably geeky enough to be able to tweak the script anyway).
Database schema (for SQLite):
create table payments (`value` int not null, `who` varchar(255) not null, `receiver` varchar(255) not null, `date` datetime); create table bills (`value` int not null, `payer` varchar(255) not null, `description` varchar(255) not null, `date` datetime);
In other news, despite thinking I was doing quite well out of the credit crunch, guess where I kept all of my savings.
