PHP Concert/Events Page

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
Obed
Forum Newbie
Posts: 1
Joined: Sat Nov 13, 2004 6:09 pm

PHP Concert/Events Page

Post by Obed »

Hi, I am trying to do a database driven concert page for my music website.

With the folowing fields:

- Date
- Event
- Time
- Venue
- Info

I want to be able to access this form online and update my concert page.

How can I do this?

Some examples are below:

http://www.delirious.co.uk/tournews.html
http://www.delirious.co.uk/tournews.html

Weirdan | Don't spam the board. One thread is enough for one question. Other threads removed.
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post by kettle_drum »

-Create the database table:

Code: Select all

CREATE TABLE events (
   date int(10) NOT NULL,
   event varchar(255),
   ..........
);
-Then create a form to add details and submit it to a page that has something like:

Code: Select all

mysql_query("INSERT INTO events (date, event, time) VALUES ('{$_POST['date']}', '{$_POST['event']}')");
-Then have a page that grabs the data from the database
Post Reply