Monthly Archives: January 2007

Setting up a grocery list


grocery list

Here’s the deal. I don’t really work close to home, the drive can take anywhere from 45 minutes to an hour and a half depending. So if I need to run any errands, I like to do them before I get home. Often times grocery shopping is one of these errands, but the problem is that I am not in the habit of carrying the grocery list around, mostly because it stays in the kitchen so things can be added as they run out. I have been racking my brain, trying to think of an easy way for my wife and myself to add to a central list that can be accessed almost anywhere.

What I came up with is a Grocery List website for us. It’s basically a SQL database with a PHP front end, very simple to set up, very simple to use. There is a box to type in the quantity, a drop down to select common items and an empty box to type any items not in the drop down.

To run this setup you need a web hosting service that lets you create your own SQL databases. The setup I am using is basically a hacked up version of Todo List borrowed from ulyssesonline.com

I personally barely know anything about PHP or SQL for that matter, and I am struggling to find a way to add a ‘Clear Entire List’ function. So if you are interesting in adding something like this to your own website, I can share my edited php files, but you might want to go to ulyssesonline.com and give him a shout too.

If you are interested in using this script, my altered files are available for download here