CHAPTER 2 THEORETICAL FOUNDATION 2.1 Platforms Zend ...

fishhookFladgeInternet και Εφαρμογές Web

13 Δεκ 2013 (πριν από 3 χρόνια και 7 μήνες)

73 εμφανίσεις


 
CHAPTER 2
THEORETICAL FOUNDATION

2.1 Platforms
Zend Framework
Supports MVC architecture
Easy to use
Build in support for handling AJAX
Excellent user documentation
MySQL (PhpMyAdmin)
Open source database
Fast performance & high reliability
Ease of use
Cost effective
Zend Studio 7.2.1
Built-in support for Zend Framework
Built-in PHP debugger
XAMPP 2.5.8
Handle Apache and MySQL services
Easy to use (Click and autorun)
Auto-running the installed services

For presentation, Ajax library and Ajax plug-ins can be found in appendix B.



 
2.2 Zend Framework
Zend Framework is a free or open source framework (approved under Open Source
Initiative by New BSD License) based on object oriented web application framework.
It is called “component library” because it can be used independently (loosely
coupled component) and implemented in PHP 5.
Zend Framework introduced an advanced Model-View-Controller (MVC)
implementation to be a structure of basic Zend Framework application.
Below is the list of commonly used Zend Framework components:


Zend_Application, Zend_Application_Bootstrap, Zend_Application_Module,
Zend_Application_Resource

Zend_Controller_Front, Zend_Controller_Action, Zend_Controller_Dispatcher,
Zend_Controller_Plugin, Zend_Controller_Router

Zend_Form

Zend_Layout, Zend_View, Zend_View_Filter, Zend_View_Helper

For database command we used the following pre-defined methods :


Zend_Db, Zend_Db_Adapter, Zend_Db_Profiler, Zend_Db_Select, Zend_Db_Table

For authentication, authorization, and session management, we use :


Zend_Acl, Zend_Auth, Zend_Session





 
2.3 PHP and MySQL
Originally, PHP is developed based on set of Perl script named PHPT (Personal
Home Page Tools) to build and maintain personal home page. Along the way of
performing script task to display and record the page, in 1995 Rasmus Leodorf
initially announced the release of PHP. Until now the latest one is PHP 5.3.0 and
PHP 6 is still in process of development. Now, PHP stands for PHP:Hypertext
Preprocessor, a recursive acronym.
PHP is a widely used scripting language that is designed to produce dynamic web
content embedded in HTML source document. As PHP is dynamic web pages, it
usually comes with MySQL as the information storage, called PHPMyAdmin. It is
free software tools to handles information flow in and out to MySQL on PHP. The
software can be maintained in command line view or graphical user interface in web
pages view with some commonly used SQL commands such as create, insert, delete,
modify table, make constraint dataflow between tables, permissions, indexes,
relational databases, etc. The user can be either using clickable user interface in web
page format or typing and executing SQL commands in the command line interface.
Here are the following features of PHPMyAdmin :
 Intuitive web interface
 Support for most MySQL features:
 browse and drop databases, tables, views, fields and indexes
 create, copy, drop, rename and alter databases, tables, fields and indexes

 
 maintenance server, databases and tables, with proposals on server
configuration
 execute, edit and bookmark any SQL-statement, even batch-queries
 manage MySQL users and privileges
 manage stored procedures and triggers
 Import data from CSV and SQL
 Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 -
OpenDocument Text and Spreadsheet, Word, Excel, LATEX and others
 Administering multiple servers
 Creating PDF graphics of your database layout
 Creating complex queries using Query-by-example (QBE)
 Searching globally in a database or a subset of it
 Transforming stored data into any format using a set of predefined functions,
like displaying BLOB-data as image or download-link