About The Course
SMEClabs’s PHP & MySQL with MVC framework will introduce attendees to PHP, MySQL, and CakePHP MVC framework. The course will cover aspects of how to use PHP, MySQL along with CakePHP MVC framework to create powerful and easy to maintain database-driven websites.
The best PHP Mysql with MVC online course will also cover the Installation & Configuration of PHP, MySQL, and CakePHP. Attendees will also get to implement one project towards the end of the course.
What will you learn?
- Understand the basics of the 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 it advantages over conventional web development methods.
- Learn all major concepts of MVC architecture in general and it advantages over conventional web development methods.
- Round off your application development skills by understanding how to implement PHP on a website using 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
- Use cookies and sessions with helper functions
- Work with regular expressions, handle exceptions, and validate data
- Work with PHP text mails and HTML emails
- How to use and create functions
- Object oriented concepts
Course Objectives
PHP scripting and MySQL database are one of the worlds most popular open source techniques used to develop websites. Add an advantage of a MVC framework to it and you can develop powerful, dynamic 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. The CakePHP MVC architect also adds some additional security against threats like SQL injections, hacking etc.
PHP MySQL with MVC Online Training Syllabus:
- Introduction to HTML
- HTML fonts Styles, Links, Images
- Tables
- Static V/S Dynamic Websites
- HTML attributes, Headings,
- Paragraphs, Formatting
- Lists, Colors
- Forms
- Links on a same page, Tags
- CSS Introduction
- CSS Id & Class Styling Backgrounds Fonts,
- Links, CSS Border Margin, Cell padding.
CSS
- CSS Introduction
- CSS Id & Class Styling Backgrounds Fonts,
- Links
- CSS Border Margin
- Cell padding
- JS Introduction
- JS client Validations (Null and Password Validations)
- Introduction to Javascript
- Variables
- Operators
- Conditional Statements
- Looping Statements
- Functions
- Events
- Dialog Box
- Regular Expressions
- Form Manipulations
- JQUERY library
- JQUERY Introduction
- JQUERY effects
- Images and Forms
- JQUERY Ajax
- JQUERY Events
- Get and Set CSS
- Add and Remove Elements
- Selectors
- Animation
PHP Basics
- PHP installation and Introduction
- Object Oriented Concepts
- Variables and Constants
- PHP echo, print
- PHP Comments
- Data types, Operators
Control statements
- if else,
- switch
- for loop, while loop, do while loop
- break
PHP Functions
- Parameterized function
- Call by value
- Call by reference
- Variable arguments
- Recursive function
PHP Arrays
- Indexed array
- Associative array
- Multidimensional array
PHP Strings
- PHP String
- String Functions
PHP Advanced
- PHP Email Function
- Include, Require
- Date & Time, Image Uploading
- File handling in PHP
- File open/read
- File create/write
- File upload
- Cookies
- Sessions
- Errors handling in PHP
- Exceptions
Mini project
- MYSQL Connect
- MYSQL Create DB
- MYSQL Create tables, fields
- MYSQL Alter table
- MYSQL Insert, Update, Delete, Select
- MYSQL Order by, Group by
- MYSQL Joins, Union
- MYSQL Aggregate functions
- MYSQL Conditions
- MYSQL Import and Export Database
- Ajax Introduction
- XML HTTP Request
- Ajax Request
- Ajax Response
- Ajax PHP
- Ajax Database
- Config Class, Database Config
- Explanation of MVC Architecture
- Loader Class, Libraries
- Creating Static Pages
- Creating First Controller, Model & View
- CodeIgniter URLs, URI Routing
- Input Class, Form Validation Class
- File Uploading
- Page Redirection
- Database Configuration
- Connecting to a Database
- Running Queries
- Generating Query Results
- Selecting Data
- Inserting Data
- Updating Data
- Deleting Data
- Introduction to PHP Framework
- Introduction to Laravel
- Laravel Installation
- Routing in Laravel
- MVC in Laravel
- Caching in Laravel
- Event subscribers in Laravel
- Package Development
- Templates
- Creating an Application
- Testing in Laravel
- Database Configuration
- Helpers in Laravel
- Laravel Pagination
- Laravel Security
- Authentication Façade
- Validation in Laravel
- Eloquent ORM
- Artisan Command Line Interface
- Deploy Application using Laravel
- WordPress introduction
- Installing WordPress
- WP Dashboard
- Create WP Site
- WP Post
- WP Pages
- WP Comments
- WP Categories
- WP Tags
- WP Link
- WP Appearance
- WP Users
WordPress Themes
- Install WP themes
- Download WP themes
WordPress Plugins
- Install WP Plugins
WordPress Advanced
- Update WordPress
- Backup WordPress
- Improve Security
- Reset Password
JOOMLA Basics
- Installation
- Architecture
- Control Panel
- Toolbar
- Menus Menu
- Content Menu
- Components Menu
- Extensions Menu
- Help Menu
JOOMLA Menus
- Create Menus
- Adding Menu items
- Modify Menu items
- Creating Sub menus
JOOMLA Modules
- Create Module
- Breadcrumb Module
- Freed Display Module
- Footer Module
- Latest News Module
- Search Module
JOOMLA Global Settings
- System Settings
- Media Settings
- Language Manager
- Private Messages
- Cache Management
- Users Setting
- Debug
JOOMLA Advanced
- Template Manager
- Customize Template
- Adding Template
- Creating Template
- Customize Logo
- Category Management
- Adding Content
- Formatting Content
- Article Metadata
- Adding Banners
- Adding Contacts
- Adding News Feed
- Adding Forum
- Adding Web Links
- Plugin Manager
- Extensions Manager
Detailed Syllabus
Best-in-class content by leading faculty and industry leaders in the form of videos, cases and projects
Attend a 30-minute FREE class with our Top Trainers
Our Trainers are Industrial Experience super-experts who simplify complex
concepts visually through real examples
Enquiry for Batch & Seat Availability
Everything You Need is Here
- Designed for Working Professionals
- 71+ PHP Mysql Case Studies & Projects
- 17 Unique Specialisations
- IIIT Kanpur Alumni organised syllabus
- Job Assistance with Top Firms
Our Certification & Accreditation
The SMEClabs Advantage
Strong hand-holding with dedicated support to help you master Automation PLC SCADA DCS
Industry Mentors
- Receive unparalleled guidance from industry mentors, teaching assistants, and graders
- Receive one-on-one feedback on submissions and personalised feedback for improvement
Student Success Mentors
- A dedicated Success Mentors is allocated to each student so as to ensure consistent progress
- Success Mentors are your single points of contact for all your non-academic queries
Q&A Forum
- Timely doubt resolution by industry experts and peers
- 100% expert verified responses to ensure quality learning
Expert Feedback
- Personalised expert feedback on assignments and projects
- Regular live sessions by experts to clarify concept related doubts
SMEClabs BaseCamp
- Fun-packed, informative, and career building workshops
- Sessions by industry professionals and professors
- Group activities with your peers and alumni
Live Expert Interaction
- Live sessions by experts on various industrial topics
- One-on-one discussion and feedback sessions with industry mentors