WPH01 – Comprehensive PHP & MySQL

WPH01 – Comprehensive PHP & MySQL courses are offered by Software Training Academy. 

Section 1: Get started fast with PHP and MySQL

Chapter 1: Introduction to web development with PHP

• The architecture of a web application

• How a client-server architecture works

• How static web pages are processed

• How dynamic web pages are processed

• A survey of web application software

• Highlights in the history of PHP

• Highlights in the history of MySQL

• The Product Discount application

• The user interface

• The HTML file

• The CSS file

• The PHP file

• How to edit and test a PHP application

• How to edit a PHP page with a text editor

• How to start and stop Apache and MySQL on your own computer

• How to deploy a PHP application

• How to run a PHP application

• How to test and debug a PHP page

• How to view the source code for a web page

• How to use NetBeans to develop a PHP application

• How to work with PHP projects and files

• How to edit and test a PHP application

• How to import and configure a PHP project

Chapter 2: How to code a PHP application

• Basic PHP skills

• How to embed PHP in HTML

• How to code comments and statements

• The six PHP data types

• How to declare variables and constants

• How to get data from a request

• How to use the built-in $_GET array

• How to use the built-in $_POST array

• When to use the HTTP GET and POST methods

• How to work with data

• How to code string expressions

• How to code echo statements

• How to code numeric expressions

• How to use the compound assignment operators

• How to use some built-in functions

• How to use the filter_input() function

• The Product Discount application

• The user interface

• The form in the HTML file

• The PHP file

• How to code control statements

• How to code conditional expressions

• How to code if statements

• How to code while and for statements

• How to pass control to another page

• The Future Value application

• The user interface

• The code for the index.php file

• The code for the display_results.php file

• How to use the PHP documentation

• How to access the PHP manual

• How to find the documentation you need

Chapter 3: Introduction to relational databases and MySQL

• An introduction to relational databases

• How a database table is organized

• How the tables in a relational database are related

• How the columns in a table are defined

• The SQL statements for data manipulation

• How to select data from a single table

• How to select data from multiple tables

• How to insert, update, and delete data

• An introduction to MySQL

• What MySQL provides

• There are two ways to work with MySQL

• How to use phpMyAdmin

• How to start phpMyAdmin

• How to log in, log out, and change your password

• How to import and run a SQL script that creates a database

• How to review the data and structure of a table

• How to run SQL statements

• How to create users with limited privileges

Chapter 4: How to use PHP with a MySQL database

• How to connect to a database and handle exceptions

• How to connect to a database

• How to handle exceptions

• How to get and modify data

• How to execute SELECT statements

• How to work with the first row of a result set

• How to work with all the rows of a result set

• How to execute INSERT, UPDATE, and DELETE statements

• The Product Viewer application

• The user interface

• The code

• The Product Manager application

• The user interface

• The code

• Expanded contents (vii)

Chapter 5: How to use the MVC pattern to organize your code

• How to use the MVC pattern

• An introduction to the MVC pattern

• How to code functions

• How to redirect requests

• The Product Manager application

• The user interface

• The model

• The controller

• The view

• The Product Catalog application

• The user interface

• The model

• The controller

• The view

Chapter 6: How to test and debug a PHP application

• An introduction to testing and debugging

• Typical test phases for a PHP application

• The three types of errors that can occur

• Common PHP errors

• An easy way to trace the execution of your PHP code

• How to debug with Xdebug and NetBeans

• How to set and remove breakpoints

• How to step through code

• How to inspect variables

• How to inspect the stack trace

Section 2: Master PHP programming

Chapter 7: How to work with form data

• How to get data from a form

• How to get data from text boxes, password boxes, and hidden fields

• How to get data from a radio button

• How to get data from a check box

• How to get data from an array of check boxes

• How to get data from a drop-down list

• How to get data from a list box

• How to get data from a text area

• How to display data on a web page

• How to format special characters

• How to format line breaks

• How to display data with echo and print statements

Chapter 8: How to code control statements

• How to code conditional expressions

• How to use the equality and identity operators

• How to use the relational operators

• How to use the logical operators

• viii Expanded contents

• How to code the selection structures

• How to code if statements with else clauses

• How to code if statements with else if clauses

• How to use the conditional and null coalesce operators

• How to code switch statements

• How to use a switch statement in the controller

• How to code the iteration structures

• How to code while loops

• How to code do-while loops

• How to code for loops

• How to use the break and continue statements

Chapter 9: How to work with strings and numbers

• How to work with strings

• How to create strings

• How to use escape sequences

• How to work with string length and substrings

• How to search a string

• How to replace part of a string

• How to modify strings

• How to convert strings to and from arrays

• How to convert strings to and from ASCII values

• How to compare strings

• How to work with numbers

• How to assign integers

• How to assign floating-point values

• How to use the math functions

• How to generate random numbers

• Other skills for working with strings and numbers

• How to use the sprintf() function to format strings and numbers

• How to convert strings to numbers

Chapter 10: How to work with dates

• How to use timestamps to work with dates

• How to create and format timestamps

• How to work with timestamps

• How to use the strtotime() function

• Examples of working with timestamps

• How to use objects to work with dates

• How to use the DateTime class

• How to use the DateInterval class

• How to use the DateInterval and DateTime classes together

• Examples of working with DateTime objects

Chapter 11: How to create and use Arrangements

• How to create and use an array

• How to create an array

• How to add and delete elements

• How to work with variable substitution

• How to use for loops to work with arrays

• How to create and use an associative array

• How to create an associative array

• How to add and delete elements

• How to work with variable substitution

• How to use foreach loops to work with arrays

• How to use functions to work with arrays

• How to fill, merge, slice, and splice arrays

• How to work with queues and stacks

• How to get the sum and product of elements

• How to search arrays

• How to sort arrays

• How to modify arrays

• How to work with arrays of arrays

• Understanding an array of arrays

• How to create and use an array of arrays

• The Task List Manager application

• The user interface

• The code for the controller

• The code for the view

Chapter 12: How to work with cookies and sessions

• How to work with cookies

• An introduction to cookies

• How to set and get a cookie

• How to enable or disable cookies

• How to work with sessions

• Why session tracking is difficult with HTTP

• How session tracking works in PHP

• How to start a session

• How to set and get session variables

• How to manage a session

• How to end a session

• The Shopping Cart application

• The user interface

• The controller

• The model

• The Add Item view

• The Cart view

Chapter 13: How to create and use functions

• Basic skills for working with functions

• How to create and call a function

• How to pass arguments by value and by reference

• How variable scope works

• How to provide default values for parameters

• How to work with type declarations

• How to use variable-length parameter lists

• How to create and use a library of functions

• A library of functions

• How to set the include path

• How function scope works

• How to create and use namespaces

• Advanced skills for working with functions

• How to work with variable functions and callbacks

• How to work with anonymous functions

• How to work with closures

• The Shopping Cart application

• The user interface

• The model

• The controller

• The view

Chapter 14::::: How to create and use objects

• How to create and use classes

• The code for the Category class

• The code for the Product class

• How to code properties

• How to code constructors and destructors

• How to code methods

• How to create and use objects

• How to code class constants, properties, and methods

• How to code class constants

• How to code static properties and methods

• The object-oriented Product Manager application

• The user interface

• The model

• The controller

• The view

• Additional skills for working with objects

• How to loop through an object’s properties

• How to clone and compare objects

• How to inspect an object

• How to work with inheritance

• How to inherit a class

• How to use the protected access modifier

• How to create abstract classes and methods

• How to create final classes and methods

• How to work with interfaces

Chapter 15 How to use regular expressions, handle exceptions, and validate data

• How to use regular expressions

• How to create and use regular expressions

• How to match characters

• How to use the character class

• How to create complex patterns

• How to use look-ahead assertions

• How to use a multiline regular expression

• How to use a global regular expression

• How to replace a regular expression with a string

• How to split a string on a regular expression

• Regular expressions for data validation

• How to handle exceptions

• How to create and throw exceptions

• How to catch exceptions

• How to catch errors

• The Registration application

• The user interface

• The file structure

• The model

• The controller

• The view

• A long version of the Registration application

Section 3 Master MySQL programming

Chapter 16 How to design a database

• How to design a data structure

• The basic steps for designing a data structure

• How to identify the data elements

• How to subdivide the data elements

• How to identify the tables and assign columns

• How to identify the primary and foreign keys

• How to enforce the relationships between tables

• How normalization works

• How to identify the columns to be indexed

• How to normalize a data structure

• The seven normal forms

• How to apply the first normal form

• How to apply the second normal form

• How to apply the third normal form

• When and how to denormalize a data structure

• A database design tool

• An introduction to MySQL Workbench

• How to use MySQL Workbench to create database diagrams

Chapter 17 How to use SQL to create a database

• How to work with databases

• How to create a database

• How to select a database

• How to drop a database

• How to work with tables

• An introduction to MySQL data types

• How to create a table

• How to code a primary key

• How to code a foreign key constraint

• How to alter a table

• How to drop a table

• How to work with indexes

• How to create an index

• How to drop an index

• How to work with users and privileges

• A summary of privileges

• How to create, rename, and drop users

• How to grant privileges

• How to revoke privileges

• How to view privileges

Other skills for creating a database

How to load data from text files

How to dump a database to a SQL script

The script for the Guitar Shop database

Chapter 18 How to use SQL to work with a database

• How to select data from a single table

• How to select columns from a table

• How to use an alias for a column

• How to select rows with a LIMIT clause

• Inquire Now