Written in PHP and MySQL, ezDatabase is the foundation for your online databases. It is a powerful web based application that allows users with basic HTML knowledge to create online databases for their website. ezDatabase will do the hard work while you concentrate on building the databases you want.
MySQL-Formmaker is a tool for creating easy administration forms and output of data. You define your forms, types of input, order, and so on, and the system makes a database for you, along with the admin and output files all in PHP.
When I learned programming, I was intensively taught how to deal with data structures in programming languages like C, C++, Ada, Modula, ... When I tried to represent hierachical structures (tree structures) with databases, I realized that different representations and algorithms are more appropriate.
A web search reveiled an interesting approach to represent tree structures with databases which is based on nested sets. The basic idea is that each subtree is recursively represented as a subset of it's ancestor node. Each set is represented by a pair of integer values: the left (lower) value and the right (upper) value. The correct numbering is achieved by incrementally tagging the nodes while traversion the tree in modified preorder. See the image at the right for an example, and Gijs Van Tulder's article for a more detailed description
Actually no documentation is available on line. I will really try to put some more information about SQLAdmin on the page as soon as possible. In the meanwhile, you can:
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.