---
title: 'PHP and MySQL Event Lister Script'
url: 'https://www.worldoweb.co.uk/2008/php-and-mysql-event-lister'
markdown: 'https://www.worldoweb.co.uk/2008/php-and-mysql-event-lister.md'
date: '2008-11-28'
description: 'I have been searching for an Event Lister for a while now. I just wanted something simple and free. All I could find were gig organisers for bands or commercial scripts. That was up until I came across a Basic PHP Events Lister from Mevin.com. Image'
taxonomy:
  category:
    - 'Web Development'
  tag:
    - MySQL
    - PHP
    - Script
---

# PHP and MySQL Event Lister Script

 Published on November 28, 2008 by Tracy Ridge in  [Web Development](https://www.worldoweb.co.uk/category/category:Web%20Development) 

I have been searching for an Event Lister for a while now. I just wanted something simple and free. All I could find were gig organisers for bands or commercial scripts. That was up until I came across a Basic PHP Events Lister from Mevin.com.

![Events](https://www.worldoweb.co.uk/images/6/8/d/5/b/68d5ba6d3f2e43e47743370d645c822ad1d8a954-events-1.jpg)Image provided by [Shutterstock](https://www.shutterstock.com/pic-167519597.html "Shutterstock")

## Setup

Setup was straightforward and only took 5 minutes to do. Documentation is included which helps. The secure admin area is easy to navigate and is simple to create, edit and delete new events. The script covers a variety of data inputs including name, date, time, location, email, phone, link and description with mandatory fields and Javascript validation.

## Reloaded

As part of a learning curve I decided to change a few things with the script to customise it further for my friends website.

- First and foremost I changed the layout a little to include an end date and an end time.
- I then changed the format of the dates to enter into a text-field rather than use the drop down boxes.
- This had its problems as I had to change the database to input to a date and time field as it was previously input as separate variables joined together.
- I then somehow had to convert the dates and times to input and display in the correct English format.
- When this was working I changed all of the pages to XHTML and styled them using CSS.
- I then put in a Javascript date and time picker as an optional extra in the add.php.

## Screenshots

![PHP Script Login](https://www.worldoweb.co.uk/user/data/wp-content/uploads/login3.jpg)![PHP Script - Add event](https://www.worldoweb.co.uk/user/data/wp-content/uploads/addevent.jpg)![PHP Script - Active Events](https://www.worldoweb.co.uk/user/data/wp-content/uploads/activeevents1.jpg)

### Share

 [X](https://x.com/intent/tweet?text=PHP%20and%20MySQL%20Event%20Lister%20Script&url=https%3A%2F%2Fwww.worldoweb.co.uk%2F2008%2Fphp-and-mysql-event-lister&via=worldoweb "Share on X") [Facebook](https://www.facebook.com/sharer.php?u=https%3A%2F%2Fwww.worldoweb.co.uk%2F2008%2Fphp-and-mysql-event-lister "Share on Facebook") [Reddit](https://www.reddit.com/submit?url=https%3A%2F%2Fwww.worldoweb.co.uk%2F2008%2Fphp-and-mysql-event-lister&title=PHP%20and%20MySQL%20Event%20Lister%20Script "Share on Reddit") [LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fwww.worldoweb.co.uk%2F2008%2Fphp-and-mysql-event-lister "Share on LinkedIn") [Bluesky](https://bsky.app/intent/compose?text=PHP%20and%20MySQL%20Event%20Lister%20Script%20https%3A%2F%2Fwww.worldoweb.co.uk%2F2008%2Fphp-and-mysql-event-lister "Share on Bluesky") [Email](mailto:?subject=PHP%20and%20MySQL%20Event%20Lister%20Script&body=https%3A%2F%2Fwww.worldoweb.co.uk%2F2008%2Fphp-and-mysql-event-lister "Share via email") 

#### Tags

 [ MySQL](https://www.worldoweb.co.uk/tag/tag:MySQL) [ PHP](https://www.worldoweb.co.uk/tag/tag:PHP) [ Script](https://www.worldoweb.co.uk/tag/tag:Script) 

##### Next

 [ ← Speed Up Vista! Part 1 ](https://www.worldoweb.co.uk/2008/speed-up-vista-part-1) 

OR

##### Previous

 [ Form Processing on Test → ](https://www.worldoweb.co.uk/2008/form-processing)

---

## Navigation

- Previous: [Speed Up Vista! Part 1](https://www.worldoweb.co.uk/2008/speed-up-vista-part-1.md)
- Next: [Form Processing on Test](https://www.worldoweb.co.uk/2008/form-processing.md)