Content Advice - Band Website

Enabling Easy Content Changes

[PumpkinHead]

(Hope this is in the right section)

Hi,

I have created a website for a band and this is my first 'real' web project. I am aiming to pass control of the site to my friend once the site is up and running. I already have the functionality in place to allow him to add gig dates for example as this is just running from a MySQL database.

To ensure that I don't have to deal with the day-to-day running of this site once it's live, I am aiming to add functionality for him to add gig reviews.

Now this may be a silly question but where do I start?! I know HTML and basic PHP. Should this kind of info be placed in the MySQL database or should I be generating the PHP pages with the gig review and somehow linking to this?

Thanks :)

[mgm_03]

check out SPAW a php based editor for people not familiar with editing HTML

also editize.com

on the other hand, if you have a database setup for retrieving gig dates, just add another table for gig reviews... although having been to many musician sites, a database seems overkill for reviews unless we're talking dozens.

make sure people can stream music samples from the site!

if you don't know how, search/read about .m3u

[knowledgepower]

hey ph,

I run a fan site for a band. I started out using SSI's so that I wouldn't have to reproduce headers/nav bars/footers/etc. in every page.

Rather than store content in the sql db, another option is to have your pal write it and save in normal .htm files. Have your main page "include" the content in the appropriate sections.

On my site, I have a summary page, and a full content page. On recent news, I include the summaries which point to an independent shell page that includes the full content.

You can do includes in PHP using include() and virtual(). I'm actually moving to this to allow more flexibility on my site.

hope this helps.

kp

[HughMungus]

I'd do it in one of two ways.

1. Setup a blog for them. Make the blog an include in the main site (with blogger, for example, you can name your file something.inc). This can be done rather seamlessly (with the added benefit that blogs are easy for non-technicals to use and that they can be setup to automatically add the date, comments, etc.).

2. Just setup a web page on their site that's password protected that allows them to input and edit text. The text gets put into a database and each bit can be edited based on its unique ID number.