Flatfile database

AlpineMan

I'm a newbie PHP coder. I have a flatfile database with the following fields in the format:

aaa:bbb:ccc:ddd:eee:fff

I'm looking for a PHP class/function that will allow me to add/edit/delete/and show records for the above. Do you have any recommendations? The simpler the better. Thanks!

KoshNaranek

my recomendation: use a SQL-Server 🙂

Flat-Line-Databases ... :rolleyes:
It's ok for a guestbook ... "bigger data" -> SQL-Server

I think, there is a workshop here "creating a simple guestbook"

When i'll find it, i'll edit the Post 🙂

Here i am again...

it WAS
creating a guestbook WITHOUT php
maybe you can find it, when the search-function is working properly again
🆒

AlpineMan

Very small data...less than 200 lines (records).

KoshNaranek

found something

maybe this will help

snippet

AlpineMan

I got an invalid link when I attempted to download the snippet.

KoshNaranek

I hate "download it at..." 😕 :mad:
Sorry ... i haven't tested it... seemed to be right...

found something on a german site...

Just give it a try 🙂

Example on [url]www.php4-forum.de[/URL]

The "interesting" parts are php

edwardsbc

If your data is only 200 lines or so and won't ever change much you can easily manage it within memory with PHP. Just load the "DB" into an array with the file function. Then use explode to separate the parts. Sorting and rewriting are a bit more work but not undoable. You could probably find a little class someone has written that already does all of this stuff.

AlpineMan

Originally posted by edwardsbc
If your data is only 200 lines or so and won't ever change much you can easily manage it within memory with PHP. Just load the "DB" into an array with the file function. Then use explode to separate the parts. Sorting and rewriting are a bit more work but not undoable. You could probably find a little class someone has written that already does all of this stuff.

So what happens if the server is rebooted? The records do change...

edwardsbc

Note that I did say "rewrite". The script has to write all changes back to the file before it finishes. In general, if the file is small, just overwrite the old file with the contents of the array.

There is one place where this "method" may cause problems. If two users hit the script at the same time and both induce some modification, you could end up with only one of the changes (the last one). This is why database systems are so very popular. They make sure all the changes get used, even during simulatneous usage.