zubrag.com
Free php and cpanel scripts to automate your daily routine

Free PHP Scripts :: Flat File Database Manager

A flat file is a file that contains records. Each record is specified in a single line. Fields from each record may either have a fixed width, or may be delimited by commas (CSV), tube (|), whitespace, tabs, or any other character.

Flat File Database Manager will allow you to manage (update/delete/add) records in your flatfile database.
Note: Currently flat files of fixed field width are not supported.

Features:
  • user defined delimiter (usually pipe, colon, or comma (|:,)
  • customizable presentation of different data types. Following data types supported:
    • LIST - Rendered as list box or combo box.
    • STRING - Rendered as regular input field.
    • LOGICAL - Rendered as check box (flag).
    • TEXT - Rendered as text area.


Flat File Database Manager screenshot

What is in the package?
1) cities.txt - database itself, i.e. file containing data. Sample database.
2) cities.def - data definition file, describes database (how long each field can be, its type, etc). Update it.
3) cities.php - database settings file (delimiter, file names, etc). Update it. See instructions in the flatfile.inc.php. Run this script to manage your db.
4) flatfile.inc.php - flatfile db manager engine. This file should not be updated.

Download Flat File Database Manager


Comments

Flatfile database user October 4, 2007
My flatfile databse is about 500K. Loading on IE took few seconds. Loading on Firefox took about a minute. I wish firefox was faster. Thanks for the script!
PS: please add reporting or data filtering capabilities.
Girish Singh April 4, 2008
I was looking for flat file database to use on website where the host could not support a database.

Another page which I found useful was

http://www.mabaloo.com/Web-Development/Building-a-fully-function-website-but-without-a-DATABASE.html
k.bahadur673 [anti-spam] gmail.com May 3, 2008
its a very good work done by you people

Add Comment

!!! Comments posted here will not be answered. If you want to ask a question please post it on the forum.

E-mail or Name: Not required. Email will be protected from spammers

Comment: Please do not post unrelated comments

Anti-spam: Please enter (8be7723a) into the box