Need To Build A Gig List!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Rubin Remus
Forum Newbie
Posts: 7
Joined: Tue Jul 07, 2009 7:39 am

Need To Build A Gig List!

Post by Rubin Remus »

Hello everyone,

I'm hoping this is the right place to post this, I apologise if it isn't.

I'm trying to build a giglist for my band's website, because at the moment I have to keep editing the html and so forth. I'd like to learn to build one from scratch, because it might help in future and I'd like to understand it fully.

If there's anyone that can help me, I'd be forever grateful. I've checked the tutorial area, but had no joy.

Thanks in advance!

RR.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Need To Build A Gig List!

Post by onion2k »

I take it a "gig list" is a very basic calendar ... a list of dates and where you'll be playing on that date? The first thing to do is to define your data structure - make a list of what you'll need to know for each gig. Once you have that you can design a little database for it.
Rubin Remus
Forum Newbie
Posts: 7
Joined: Tue Jul 07, 2009 7:39 am

Re: Need To Build A Gig List!

Post by Rubin Remus »

Thanks for the quick reply!

Yes, it is a calendar (never thought of it like that).

When you say the structure, do you mean insert the fields into PMA?

E.g,

Date
Location
Price
Other Notes

Sorry if I sound vague, but I'm new to this side of things.

Thanks.
Rubin Remus
Forum Newbie
Posts: 7
Joined: Tue Jul 07, 2009 7:39 am

Re: Need To Build A Gig List!

Post by Rubin Remus »

It might be worth saying that I'm going to need to build a back-end for it, as well, so other members of the band can list gigs.

Thanks.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Need To Build A Gig List!

Post by onion2k »

Yes, I mean the columns for the database tables you'll create in PMA. That's the most important aspect of the website application - if you get the data structure right at the beginning the rest of the code will be easy because it'll just be a matter of writing pages to display the data (front end) and update the data (admin area). In a website or web application everything hinges on the data structure.

At the very minimum I would have thought a gig would need fields for:

Date
Location Name
Location Website URL
Location Address
Ticket Price
Ticket Sales Website URL (if people can buy tickets online)
Start Time
End Time
Support Act Name
Description
Owner ID (ID of the website user who created the gig record)
Created Date

Although, that said, I've only ever been to gigs as a member of the audience.
Post Reply