Contents Management and Database System
TeamNet combines an easy to use web site Contents Management System with an innovative Database Management System.
Contents is accessed via the menu. After login you can edit a page via an edit icon. If you copy such a page you actually start a new page that is immediately accessable via the menu. The visibility level can be set. A unique option is to include an application/app into such a site page. The editor also enables the use of multi-media.
A standard available application is a database. Just go to the database query start page. It gives access to all your database queries. The result of such a query opens the Database Management System. The relational database system is extremely user friendly. Configuration is limited to the selection of the right prefix for a field name to open a range of functions.
Database Search Engine
At the begnning of 2015 a powerfull search engine is available. System administrator can define table and fields that shall be searched. Both authorization for tables can be set and fields to be used in the result are selected by checkboxes. The result links to table records and if applicable to documents on the server or elsewhere on the Internet
TeamNet was originally developed in 2005 as a players administration in a web database for Oliveo, a footbal club in Pijnacker, The Netherlands. There was no overview of teams available, with both players and leaders. This case fitted to my other question. I never saw a web page presenting several record like a spreadsheet. The public part of the result is accessable from the left menu or here. This implementation was followed by a tournament web database system. This system has very useful functionalities like a chronological order and on-line result calculation. An example (click here) is incorporated in another implementation for a yearly school tournament in Pijnacker.
In 2010 development of the second generation started with the aim to minimize the amount of software, use open source tools like JQuery, minimize the maintenance effort and optimize the content and database functionality. This site is an example and a small company website example is shown here.
Key features are
- simplified content management;
- re-use of queries, simply by storing the query elements;
- user defined hierarchal structuring of the site layout, menu, links and queries;
- automatic generation of a database query start page;
- easy configuration and use of database function;
- relational database on the fly.
All information is stored in the database. This up to the page template layout. Layout and functionality is on-line defined by simply entering page part applications in the HTML database table.
In 2016 a search-engine, Bootstrap and DataTables are introduced in TeamNet3 supporting responsive design and easy searching within a table output or selected database tables.
Build on open source tools
Teamnet is a PHP-MySQL website system based on open source tools:
PHP is the basic language used for programming, initially procedural, moving to object oriented,
MySQL database is the base of Teamnet,
phpMyAdmin is used for for the configuration of database tables,
JQuery is included for effective user interaction,
CKEditor plugin is used for text editing, with TinyMCE as alternative
Bootstrap is used for its responsive layout opportunities, from Teamnet3 on,
DataTables is applied for query result table presentation and selection,
Flot is build in for site specific graphical presentations
Devrama slider is used for a site photo gallary
jquery.bxslider is used as slider in the photo album plugin
For an introduction to most of these tools see: W3School
Use and administration
There is only one interface for both user and administrator. After login, the administrator has editing icons and extra menu options available.
This documentation mainly presents TeamNet principles, possibilities and configuration. The complex part gives some definition of files and configurations of both the database and the system files is presented. It is assumed system administrators are familiar with phpMyAdmin.
Installation and configuration
For installing two parallel directories are made. A base directory with all system files and in parallel one (or more) site directories with only a few files. These files need some configuration for your own web site look, e.g. databse, colors and logo images.