Simple flat file database

[Brianfree]

Hi, i am trying to write a simple php and flat file database to record fault issues..

I just need a form which i enter the following..

ID (auto increment)
Priority (High, Med, Low) Drop Down
Employee
Fault Description
Date/Time
Status (Open) by default

On submitting the form a webpage will display the issue(s) highest priority at the top to the lowest at the bottom (in date order). Will use colour like a traffic light to visually show the fault priority (red = high, amber = mid, green = low)

Once an issue has been resolved, i can select a fault and change the status to closed.

Please can someone help me with writing this… At a guess there will be 2 pages.. one to display the faults, the other to create / update??

Many thanks

Brian

 

[jpadie]

Sure Brian

we can help. Where are you stuck? what code do you have so far?

 

[Brianfree]

Hi, erm… nothing really.. I have some local webspace i can use(wamp), just being browsing google for some examples.. think flat file will be easier as not going to hold lots of data.. will just be displayed on a computer screen in the office on a refresh every 30 mins… thought a php page will look much better that an excel spreadsheet..

sorry….

 

[spamjim]

You probably lost many of us by specifying a "flat" file. It is certainly not "simple" to seek, sort and update rows in a flat file, especially when you have access to MySQL in WAMP.

But if you insist on doing it the hard way, there are existing libraries/projects that may help.

https://www.google.com/search?q=php+flat+file+database

 

[Brianfree]

Hi, i will have a play around tonight and put somthing together.. i think i can create a form and write the data to a flat txt file, then have another page to display the data… not sure how to open a fault and mark as closed????

Will post my code tomorrow..


many thanks

brian

 

[spamjim]

And if you are just looking to manage issues/tickets/etc, why not use a ready-made system?

ex:

http://flyspray.org/

 

[audiopro]

Personally, I would be going down the MySQL route as designing your own flat file handling routines really is inventing the wheel again.

Keith

http://www.studiosoft.co.uk