PDA

View Full Version : online database management


jekay
3-15-06, 09:57 PM
can someone recommend an appropriate technology to accompsh the following:

I'd like to use my band's webspace to create a private (pw or just hidden) space where we can keep a running list of places we've sent our promo cd to. I'd like something that's easily editable so, for example, if I send a cd to radio station X, I can add a line item to the page that tells the other band members that a cd was sent with fields for the address, send date, etc. and if radio station x were to respond with effusive praise, there'd be a field where I could add that to the line item.

and i'd like all this to have a simple web interface, so each of us can access and edit it.

make any sense?

i'm sure there most be some sort of plugin to do this, but the list of options is a little overwhelming.

i'm very comfortable coding html, but not much else.

thanks.

BerksWebGuy
3-15-06, 10:14 PM
PHP would be a good choice. To look for some free scripts (since you aren't comfortable coding)...take a look at www.HotScripts.com .

You could accomplish this with a simple form and mysql table...or even a text file depending on how many records you plan on having.

satis
3-16-06, 10:44 AM
if that's all that you want to do (just add lines of text that are displayed), I'd recommend php with a flat text file. No need to get a database involved...I think it would just add complexity without any real added bonus. If you decide to go a database route later, you could always take the flat file you've been using and stuff it into the db anyway.

Security through obscurity (hidden area) is always a bad idea. To keep things simple, I'd recommend htaccess. There're some tutorials floating around on here somewhere on that.