rtgx

Recommended Frameworks:

Presentation Layer

For template parsing, and visual data representation Smarty framework is recommended (http://smarty.php.net).


To implement modern JavaScript controls, and to bind JavaScript with PHP Sajax is recommended (http://www.modernmethod.com/sajax).


[Other similar projects for the presentation layer are Flexy and WACT]

Business Logic Layer

To take care of controllers and action handlers, as well as implementing the business logic it is recommended to use Agavi Framework (http://www.agavi.org).


[Other similar projects for the business layer are Mojavi, PRADO, WACT, PHP.MVC, MVC, and Phrame]

Data Layer

To implement an OO model of the database connection libraries it is recommended to use Creole (http://creole.phpdb.org/wiki/wiki.php).


[Other similar projects for the data layer are PDO and AodDB]

Supporting Frameworks

For system logging it is recommended to use Log4php (http://logging.apache.org/log4php).


[Another simillar project is Log from PEAR]

File Structure

www
 +---smarty
 |   +--- ...
 +---mojavi
 |   +--- ...
 +---creole
 |   +--- ...
 +---log4php
 |   +--- ...
 +---DAO
 |   +---MySQLParams.php
 |   +---MySQLDAO.php
 +---actions
 |   +---[action1]
 |   +---[action2]
 |   +---[action3]
 |   +---...
 +---modules
 |   +---stats
 |   +---invoice
 +---utils
 |   +---...
 +---templates
 |   +---default
 |       +---css
 |       +---img
 |       +---header.tpl
 |       +---footer.tpl
 |       +---index.tpl
 |       +---...
 +---index.php
 +---...

Database Naming Convensions

Názvy tabuliek: use simple meaningfull names, all in english, lower case letters, no spaces, including module prefix (e.g. core_users, core_companies, stats_counter, ...).

Názvy stĺpcov:  use simple meaningfull names, all in english, lower case letters, no spaces (e.g. id, first_name, phone_1, ...).

Triggery a iné databázové záznamy: use simple meaningfull names, all in english, lower case letters, no spaces, with recognisable prefix (e.g. Trigger for user deletion – trg_user_delete, stored procedure for inserting a new user – sp_ins_user, ...)

 
OpenOffice dokument (Open Document) Pôvodný dokument, 10.7 (kB)
OpenOffice dokument Projekt, 22.0 (kB)