Database Register

Consolo can be used to edit content in database tables. Thanks to this you don’t have to design administration interfaces for ever single register an editor should work with. You are still in control of what can be edited and how.

The uses for this are unlimited. It can be used for everything from banner systems, discussion boards and voting features, to user databases, member- and client registers.

If you haven’t worked with Consolo’s databse support before, you should read these pages. This feature makes your work much easier. With four simple scripts, you will let the editor modify any given database table, right within Consolo.

In the Configuration Tool, six values have to be defined for every database register: the text for New button, four scripts and a password. Click on the scripts to read more about how to write them.

1. Text for New button. The text displayed on the New button next to every register e.g. “New Banner”, “New Question”, “New User” etc.
2. Script for listing. Script that lists selected columns in the register.
3. Script for editing. With the help of Consolo’s xml-defined forms you decide exactly how and what the editor will be able to edit. This script also handles the template for new objects.
4. Script for saving. The script that recieves the edited data, verifies it and saves it in the database. There is a possibility of displaying messages to the editor if the data isn’t correct.
5. Script for deleting. The script deletes an object from the database. Here, it is also possible to display messages to the editor.
6. Password. A password to be checked by all the scripts above. This prevents unauthorized calls for the scripts. Passwords with at least ten characters are recommended.