Web application with Yii Framework
Henri Landvik · Theseus (Ammattikorkeakoulujen) · 2013
This thesis is about creating a web application and a database. Database is a structured collection of data. It usually has valuable data inside. Given the importance of valuable data, it is important to keep the data secured from outside attacks. There are different kinds of databases to choose from. An object-relational database management system called PostgreSQL was used in this thesis. To make it easy for a client to access a database, it is common that a web application is created on the top of the database. An object-oriented, open source and a component-based PHP web application framework called Yii Framework were used in this thesis. It uses a model-view-controller architecture, which makes development easier for companies because different development groups can be assigned to do either model, view or controller development. The second part of this thesis introduces the WISE project. WISE comes from the words white space test environment for broadcast frequencies. It develops and studies the efficient use of TV-band spectrum resources through cognitive radio technologies and geolocation databases. The third part gives a view of an open source framework called Yii Framework. This thesis introduces the object-oriented aspect of Yii Framework, the model-view-controller architecture, user management, modules and the security of Yii Framework. In the empiric part a database and a web application were developed and tested. Screenshots were used to give a clear image of how the empiric part was made step by step. In conclusion, this thesis is summarized. The process of creating an empiric part and the creation of this thesis were pondered.