On our PHP+MySQL training course, we will show you why it is such a popular language and how it makes learning programming very easy for the novice to expert programmer. We will also show you how object orientation, which was added to PHP 5, enables it to be used for more than just web development. Combined with MySQL, an open source database, we show how PHP can be used to develop applications for mobile and fixed devices. Not only will you look at the basics of PHP and MySQL, but we’ll also look at its framework Laravel. Using Laravel not only lets you leverage the popularity of PHP and MySQL, but develop apps quicker and faster by using built in features like Eloquent and the Blade templating engine.
Setting up the environment – Installing LAMP / WAMP / MAMP which includes PHP MySQL and Apache server for Windows, Linux, and Mac
Web servers - how they work, putting it all together
The built-in PHP testing server
PHP Variables and Data Types
Operators – math, assignment, comparison, logical
Incrementing / Decrementing
Operator precedence
Working with strings
Initializing arrays
Populating arrays
Accessing arrays
The empty and isset functions
Searching for elements in an array
Ordering arrays
Other array functions
Processing
Display
Formatting
Tokenising
Regular expressions
Conditionals
Switch…case
Loops – While, Do While, For, Foreach
Function declaration
Function arguments
The return statement
Type hinting and return types
Reading files
Writing files
Other filesystem functions
Classes and objects
Class properties
Class methods
Class constructors
Magic methods
Encapsulation
Static properties and methods
Namespaces
Autoloading classes
Using the __autoload function
Introducing inheritance
Overriding methods
Abstract classes
Polymorphism
Traits
The try…catch block
The finally block
Catching different types of exceptions
Factory
Singleton
Anonymous functions
MySQL
Schemas and tables
Understanding schemas
Database data types – Numeric, String, DateTime, List of Values
Managing tables
Primary keys
Foreign keys
Unique keys
Indexes
Using PDO
Connecting to the database
Performing queries with Prepared statements
Updating data
Foreign key behaviours
Deleting data
The MVC pattern
Using Composer
Managing dependencies
Autoloader with PSR-4
Adding metadata
The index.php file
The request object
Filtering parameters from requests
Mapping routes to controllers
The router
M for model
The customer model
The book model
The sales model
V for view 207
Introduction to Twig
The book view
Layouts and blocks
Paginated book list
The sales view
The error template
The login template
C for controller 215
The error controller
The login controller
The book controller
Borrowing books
The sales controller
Dependency injection
Why is dependency injection necessary?
Implementing our own dependency injector
Types of tests
Unit tests and code coverage
The phpunit.xml file
Your first test
Running test
The start and end of a test
Assertions
Expecting exceptions
Data providers
The purpose of frameworks
The main parts of a framework
Authentication and roles
ORM
Cache
Internationalization
Complete and robust frameworks
Lightweight and flexible frameworks
Symfony 4
Zend Framework 2
Other frameworks
Installation
Project setup
Adding the first endpoint
Managing users
Setting up relationships in models
Creating complex controllers
Adding tests
Classroom or Remote
Remote
Receive the latest version of this course by email & subscribe to our Newsletter
CONTACT
+44 (0)20 8446 7555
enquiries@jbinternational.co.uk
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address 1345 High Road, London, N20 9HR
POPULAR
AI & ML training course
React training course
Threat Modelling training course
Python for Data Analysts training course
Power BI training course
Machine Learning training course
Spring & Boot Microservices training course
Terraform training course
Kubernetes training course
C++ training course
Biztalk training course