PHP or ASP or???

jmpatrick

Here's my website: http://www.motorcityrock.com.

Basically, it's a music-related site that contains a library of artists, venues, and associated photos and memorabilia. The site is fairly new, but I already have nearly 1000 HTML Pages and the number is growing every day. Since everything on the site is cross-linked to other relevent pages, it's becoming a pain to keep it updated.

I'd like to redesign the site with a database backbone and it was suggested that I look into PHP.

If you look at this link: http://www.motorcityrock.com/bands/carbide/carbide.html you'll see what a basic artist listing looks like. My database would start with Band Members. Every name from every band would go in a database. From this database I would group band members into Bands. Photos would be related to the approriate Bands. You'll also see performance listings (dates). These would be related to appropriate Venues.

See where I'm going here?

My question is: Is PHP the best way to do this? I've already got a PHP-driven site search and message forum, so I've got a_little_bit of any idea how it works.

Thanks!

maxpup979

Of course you should use PHP (this is a PHP forum--what kind of answer did you expect?...)--what you are proposing is not terribly difficult-A couple of tables in a DB, and a couple of templated pages to display the info as needed--As in most apps, the hardest part (I think) will be setting up the data structure to account for all of the corner cases. For example--Lets say you have guitarist A, who was a member of a band for 3 years, then moved to a different band--are you planning on taking personell changes based on time/date into account?
Regardless--what you are proposing is well within the capabilities of PHP

And besides--we tend to be a helpful bunch over here....🙂

jmpatrick

Thanks!

No, I'm only interested who played with what band.

PHP it will be...

What do I need to build my database? Is there a database building application (free?) that will let me enter data with a form of some sort (that I design)? I assume that photos and audio/video should be entered into the database as links...

OhLordy

Apache(webserver)
MySQL (database)
PHP Manual
Zend
HTH
Rob