A Level: Full Stack Web Development using MVC Framework (A10.2-R5, NIELIT / DOEACC)



    The module is designed to equip the learner to use PHP & MySQL with the 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 webserver with minimal to no changes.

    After completing the module, the incumbent will be able to:

    • Understand the basics of Web Technology
    • Learn all major concepts of PHP and MySQL that beginner developers need to master.
    • Learn all major concepts of MVC architecture in general and its advantages over conventional web development methods.
    • Round off your application development skills by understanding how to implement PHP on a website using the MVC framework.
    • Gain the PHP programming skills needed to successfully build interactive, data-driven sites
    • Create forms easily using helper functions and work with form data
    • Object-oriented concepts
    • Able to architect, write, debug, and run complete web applications
    • Test and debug a PHP application

    120 Hours – (Theory: 48hrs + Practical: 72 hrs)

    Detailed Syllabus

    (i) MVC Infrastructure Basics. PHP Frameworks& Introduction to CakePHP
    Introduction to MVC, What is Model-View-Controller, Why use the 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 the model, data validations.

    (iii) Controller and Views
    Application flow –Creating Controller Function, How Controller interacts with the model, how the controller interacts 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, the 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) Functions and Error handling
    What are 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 are 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 an 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) Advanced Queries and Data Manipulation using PHP and MySQL
    Joins, Handling NULL Values, Regular Expressions, ALTER Command, Indexes, Temporary Tables, Database Handling Duplicates, SQL Injections. Creating user login form, Registration Form using a database, User Authentication, Search, Update, Delete Users, and Data. Fetching the data from the database

    (ix) Creating Dynamic Forms using CakePHP Html Helpers:
    Introduction to a 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

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.