provides an intranet solution for managing data in databases. Users
can retreive all kind of reports, as well as edit the data in the
databases. Both the reports and the input-screens can be defined
through the webinterface itself. Also links between tables in the
database are supported.
complete package is written in PHP with
MySQL as the database-server. Installation should be possible on
almost any system supporting PHP and
is aimed to be suitable for any browser that supports frames, CSS and
Explorer on Pocket PC/Windows Mobile
all features are working 100% on the mobile yet. For desktop
computers we recommend Firefox.
stable public release of Databrowser is version 0.4.
single contributor to this project I've decided to do further
development in the private company Lipronics
If you're interested in a commercial application of Databrowser
please contact me at Lipronics.
Mans, Aug 2008
is new in 0.4
bugfixes and enhancements in installation/setup procedure
a log of edits on a record
of implementing an ACL system,
still partially under development
extended features for defining list-views and record editing forms
was new in 0.3:
adapted to be also usable on a PDA (Ipaq)
lists are now split up in several pages
more requirement for register_globals=on. Thus usable on more
different php server-configurations.
throught the 'Releases' link.
available in the CVS and
to determine which users may edit data
the latest version from CVS or
to ZZZusers: verify that you've got at least 'admin' in the usrgroup
field, give some other users some groups as you like
to ZZZtables and fill in a value for EditCond. As soon as a
character is entered in the EditCond field, the EditLevel field is
ignored for that particular table.
the string 'manager' is found in the usrgroup field for the logged
in user, this user is allowed to edit the field contents of this
user is allowed to edit the field contents of this table
is allowed to edit the field contents of this table
any valid SQL condition
for the current record could be defined, where a $G will
be replaced with the usrgroup for the logged in user and $U will
be replaced with the username for the logged in user.
or Amount<1000 will
prevent employees not being a manager to edit records that involve
an amount higher than 1000.
go also to ZZZfields and fill in some values for EditCond. This
field will prevent editing certain fields from a table depending on
the specified condition. Syntax same as for ZZZtables. User should
fullfill both conditions in ZZZtables and ZZZfields to be allowed to
edit a field. If left empty only the ZZZtables definition is used.
work in progress…