So that they can redesign an internet site, I put this page together manually. However, you will find presently over 100 more shows already that should be added, and three new shows get added each year.

Within the old system, a text document was adopted like a makeshift 'database' it saved data about each show, with shows separated by '#' and data fields separated with ']'. Here's an excerpt:

#The Whorl of the Leaves]WhorlOfTheLeaves]3]F]167
#A Christmas Carol]XmasCarol84-]7]N]0
#The Feral Child]FeralChild]7]N]118

A PHP script ended up being accustomed to extract the data about each show making the page seen here.

I am sure a script could be employed to come up with a webpage like the one proven above, however it appears like there must be a much better system than the usual text document to keep the data.

My real question is: when the text document 'database' is working, must i bother altering it? It is possible to better method to organize the data about each show?

SQLite could be prefect for you personally. It is a small database that needs no configuration or setup - yet comes included in most PHP installs.

Only use PDO as well as your good.

$db = new PDO('sqlite:/path/to/here/mydb.sq3');

$db->query('SELECT * FROM shows');

Yep, you will find a lot of "better" methods for carrying this out. But when you are pleased with it and delay pills work, why change it out?

If you feel you'll have the ability to improve your text based database every single time with no hiccups (for example inconsistency between two files since you mis-submitted the older one) you actually have no need for a complete database implementation.

However you can test some better options (which you'll edit in many software including Stand out) for example SimpleXML.

It's a quite simple XML parser for PHP. It comes down enabled automatically for those who have PHP version 5.1.2 and also over.

If you wish to try something a lot more flexible than simply a text file but still not really a full resource hog database implementation, you can enable SQLite extensions in your PHP and begin utilizing it.

Benefits of SQLite (or other database implementation) is you can do CRUD (Create Retrieve Update Remove) procedures without uploading any file to server.

You could lay aside yourself lots of trouble using a cms for example drupal.