A10.2-R5-Full Stack Web Development using MVC Framework
Objective
The module is designed to equip learner to use PHP & MySQL with MVC framework. The module will cover aspects of how to use PHP, MySQL along with CakePHP MVC framework to create powerful and easy to maintain database driven websites.PHP, MySQL and CakePHP are also platform independent i.e. You can easily port a website developed on a windows machine to a Linux based apache web server with minimal to no changes.
After completing the module, the incumbent will be able to:
i. Understand the basics of the Web Technology
ii. Learn all major concepts of PHP and MySQL that beginner developers need to master.
iii. Learn all major concepts of MVC architecture in general and it advantages over conventional web development methods.
iv. Round off your application development skills by understanding how to implement PHP on a website using MVC framework.
v. Gain the PHP programming skills needed to successfully build interactive, data-driven sites
vi. Create forms easily using helper functions and work with form data
vii. Object oriented concepts
viii. Able to architect, write, debug, and run complete web applications
ix. Test and debug a PHP application
1. Learning Objectives
1. MVC Infrastructure Basics, Frameworks& Introduction to CakePHP
i. Gather knowledge MVCTerminology
ii. Advantages of MVC
iii. Brief Information about MVC Frameworks of PHP
iv. Installation of CakePHP
v. Configurations required for Framework
2. Models
i. Models in detail
ii. Defining Models
iii. Use it for database access and manipulation
iv. How to use basic SQL queries in models
3. Controller and Views
i. Create Controllers
ii. Create Views
iii. Controllers and Views Interaction and exchange data between them
4. PHP Basics and Conditional Logic
i. PHP and MYSQL Basics
ii. Installation Setup,Data Types.
iii. Get familiar with Arrays and Decision-Making Statement.
5. Functions and Error Handling
i. Well acquainted with functions and its uses.
ii. Able to understand various types of Functions.
iii. Able to create user defined functions.
iv. Well versed with Regular Expressions.
6. Object Oriented Programming
i. Object Oriented Concepts
ii. Classes, creation of Objects for Class.
iii. Methods and functions
iv. Object oriented functionalities i.e. Inheritance, Method Overriding, Interfaces
v. Constants
vi. Access Specifiers and Abstract Classes.
7. MySQL Installation and Basics
i. Database and Database Terminology
ii. Database creation and Connection
iii. Database manipulations like add, edit and delete
8. Advance Queries and Data Manipulation using PHPand MySQL
i. Advanced Queries.
ii. SQL Injection
iii. Sorting and Indexing
iv. Joins
v. Retrieving and manipulating Data using PHP.
vi. Creation of Login and Registration form for user authentication
vii. Searching, Updation, Deletion of data and users
9. Creating Dynamic Forms using CakePHP HTML Helpers
i. Generate forms using CakePHP
ii. Validate forms using model definitions.
iii. Difference between get and post methods
iv. Sessions and cookies
v. File uploading
Marks Distribution
1. MVC Infrastructure Basics, PHP Frameworks & Introduction to CakePHP 14
2. Models 11
3. Controller and Views 12
4. PHP Basics and Conditional Logic 10
5. Functions and Error Handling 10
6. Object Oriented Programming 13
7. MySQL Installation and Basics 7
8. Advance Queries and Data Manipulation using PHP and MySQL 13
9. Creating Dynamic Forms using CakePHP Html Helpers 10
Total 100
Detailed Syllabus
(i) MVC Infrastructure Basics.
PHP Frameworks& Introduction to CakePHP Introduction to MVC, What are Model-View-Controller, Why use framework in the project (conventional vs. MVC project), Introduction to PHP Frameworks i.e Zend, CodeIgniter, Laravel. Installation of CakePHP, CakePHP folder structure, File naming conventions, Important config file (core.php, database.php)
(ii) Models
Models: Different models of databases and interaction between databases. Creating up model for a database, Accessing and manipulating table data using find, save, update methods of the model, Deleting Data, User defined functions in model, data validations. National Institute of Electronics and Information Technology
(iii) Controller and Views
Application flow –Creating Controller Function, How Controller interact with model, how controller interact with views. CakePHPhelpers, Most commonly used helpers like Form, HTML, Session, Cookie etc, Create views and custom layouts
(iv) Php Basics and Conditional Logic
PHP introduction, Environment setup in different platforms, concept of Server-side scripting language and client side scripting language, Script syntax, How to declare variable and data types, Constants, Arrays, Strings, Web concepts, Decision making statements, loop types, operators
(v) Functionsand Error handling
What is Functions, Creating PHP functions, PHP functions with parameters, Argument by reference, setting default values for function parameters, dynamic function calls, regular expressions, Date and time functions ,Built-in functions, file inclusion, file manipulations
(vi) Object Oriented Programming
What is Object Oriented Concepts, Defining classes, Creating Objects, Member functions, The new keyword and Constructor ,Destructor, Access method and properties using $this variable, Inheritance& code reusability, Function overriding, Access Specifies- private, public and protected members, Static properties and method, Class constants, Polymorphism, Parent:: &self :: keyword, Instance of operator, Abstract method and class, Interface , Final, Exceptional handling.
(vii) MySQL Installation and Basics
Database Introduction, MySQL installation on various platforms, MySQL connection, Database creation, Database Manipulations- Add, Edit, Retrieve and Delete. Table creation and table manipulations- Add Edit, Retrieve and Delete, Like clause, Sorting, Group Functions with having clause
(viii) Advance Queries and Data Manipulation using PHPand MySQL
Joins, Handling NULL Values, Regular Expressions, , ALTER Command, Indexes, Temporary Tables, Database Handling Duplicates, SQL Injections. Creating user login form, Registration Form using database, User Authentication, Search, Update, Delete Users and Data. Fetching the data from database
(ix) Creating Dynamic Forms using CakePHP Html Helpers:
Introduction to basic html form, get, post methods, Generate form elements like input boxes, dropdowns, radio buttons, and links using CakePHP html helper, Form validation using Model validation definitions, Create, retrieve and delete cookies, Create, retrieve and delete session variables, File handling in CakePHP (create, delete, read files), CakePHP Global variables and their use
Reference Books/Study Material
1. PHP and MySQLWeb Development: Publisher: Addison-Wesley Professional Author: Laura Thomson, Luke Welling
2. PHP and MySQL Web Development: Publisher: Addison-Wesley Professional Author: Laura Thomson, Luke Welling
3. Beginning PHP6, Apache, MySQL Web Development Publisher: Wrox Author:
Elizabeth Naramore, Jason Gerner, Yann Le Scouarnec, Jeremy Stolz, Michael K. Glass Timothy Boronczyk
4. Learn CakePHP Publisher: Apress Author: Radharadhya Dasa
5. Practical CakePHP Projects Publisher: Apress Author : Miller Cheryl