Introduction php:

Recommended Software Overview

XAMPP Installation

Write Your First PHP Code: Display a Message in Your Web
Browser
Variables in PHP: What They are, How to Create Them, and How
to Name Them
Basic Variable Types: Strings and Numbers
Basic Variable Types: Boolean and Null
Perform Operations on Variables: Operators
Strings: Using Single or Double Quotes and Variable
Interpolation
PHP concepts, variables and operators
Variables and Operators

Introduction to Arrays: Create an Array and Access its Elements
Assign Manual Array Indexes and Create Associative Arrays
Create and Access Multidimensional Arrays
Process Each Element of an Array: foreach Loops
Process the value and index of each array element using a
foreach loop
Add More Conditions to an If Statement Using Elseif
Perform Different Actions Based on Different Conditions: The
Switch Statement
Control structures and comparison operators

The Language of Web Pages: an Introduction To Html
Use Head and Body Elements to Structure An Html Document
Structure the Content of your Page Using Heading and
Paragraph Elements
Give Text Emphasis or Importance Using the em and Strong
Elements
Display Ordered and Unordered Lists of Items
Insert Images Into an Html Document
Add a Link from One Page to Another Using a Hyperlink
Add Semantic Structure to The Body of an Html Document
HTML
HTML basics
Mixing PHP and HTML

Where to Store Data in a Dynamic Website: An Introduction to
Databases
Access the Database Server Using phpMyAdmin And Create a
Database
Use Tables to Store Structured Data in a Database
Select Some Data from The Database: An Introduction to Sql
Using Indexes: Make Queries Faster and Order the Result Set
Connect to the Database from PHP
Query the Database from PHP And Get the Results
Combine PHP and HTML to Show a Formatted List of Articles
Databases
Databases - connecting and selecting data

Add a New Page to Show a Single Article
Passing Data in the URL: Send the Article ID Using the Query

Getting Data From the User: An Introduction to Forms in HTML
Change the Method the Form Uses to Send its Data: get vs post
Addendum: datetime and datetime-local input types
Get Different Types of Data from the User: Basic Input Types
Access Data from the form on the Server
Add a Multi-line Text Control: the textarea Element
Present a Fixed List of Options: the Select Element
Toggle an Option on or off: checkboxes
Select only one Option from a List: Radio Buttons
Add an Accessible Caption to Each Input: the Label Element
Make the Form Easier to Use: fieldsets and placeholders
Common form Control Attributes: readonly, disabled and
autofocus
Validate Input Using HTML5 form Validation
Forms in HTML
HTML Forms

Inserting data into the database
Databases - inserting data

Functions: Define and Call a Function in PHP
Create a Function to Connect to the Database
Validate the Form Data and redisplay the Form with Error
Messages if Invalid
Maintain Previously-supplied Data When redisplaying an Invalid
Form
Avoid Cross-site Scripting (XSS) Attacks: Escape Untrusted
Content
Insert NULL if the Publication Date is Empty
Validate the Publication Date is a Valid Date and Time
Redirect to the Article Page After Inserting a New Article
Functions
Functions in PHP

Editing Existing Articles: Create a Function to Get a Single Article
Add a Form for Editing an Existing Article
Add a Validation Function and Validate the Form Data
Change Existing Data in the Database: The SQL UPDATE Statement
Update an Existing Article in the Database
Create a Function to Redirect to Another URL

Delete Existing Data in the Database: The SQL DELETE
Statement
Delete an Existing Article in the Database
Use the POST Request Method to Delete the Article
Get Confirmation from the User Before Deleting the Article
Improve Database Performance: Only use SELECT * when
Necessary
Updating and deleting data in the database

Make the Web Browser Remember you Between Visits: An
Introduction to Sessions
Store Data in the Browser: Cookies in PHP
Store a Value in the Session to Log in and Log out a User
Add a Login form and Process the User's Login Credentials
Completely Destroy the Session on Logout and Redirect Back
to the Index Page
Increase Security: Prevent Session Fixation Attacks
Restrict Access to a Page to a Logged-in User Only

Classes and Objects: An Introduction to Object-Oriented PHP
Object Attributes: Adding Properties to a Class
Object Functions: Adding Methods to a Class
Object Initialisation: the Constructor Method
Control Access: Public and Private visibility of Properties and Methods
Public Properties vs Getter and Setter Methods
Static Properties and Methods
Constants: Using Define and const to Create Constant Values
Inheritance: Using the Extends Keyword to reuse Code and
reduce Repetition
Overriding Methods and Using the Parent Keyword to Call the
Parent Class Code
Control Access: Protected Visibility of Properties and Methods

Add a Database Class and Connect to the Database Using PHP Data Objects (PDO)
Queries in PDO: Change the Index Page to Use the New Database Class
Catch Database Errors Using Exceptions and try ... catch Blocks
Prepared Statements with Named Parameters in PDO: view an Individual Article
Create an Article Class and Use it on the Index and Article Pages
Fetch the Database Record as an Object Instead of an Array
Update the Article Record Using PDO
Move the Validation Function to the Article Class
Delete the Article Record Using PDO
Insert a new Article Record Using PDO and get the ID of the New Record

Convert the auth Include into a Class
Convert the url Include into a Class
Autoloading Classes: Require Class Files Automatically
Add an Initialisation Script Including an Autoloader
Returning a Value Using Require: Add a Script to get the
Database Connection

Pagination: Split Database Results up Into Pages
Add a Method to the Article Class to get a Single Page of Article Records
Add a Paginator Class and Calculate the offset and Limit from the Page Number
Get the Page Number from the Query String
Validate the Page Number using the filter_var Function
Add Previous and Next Pagination Links
Calculate the Total Number of Records and Pages
Add Pagination to the admin Index and Create Shared Pagination Links

Database Relationships: Create a Table and Data for Categories
One-to-one Relationships Between Tables
One-to-many Relationships Between Tables
Joins: Selecting Data from Multiple, Related Tables at Once
Relationship Constraints
Many-to-many Relationships Between Tables

Execute Code in the Browser: An Introduction to JavaScript
Using the jQuery Library
Add jQuery and a Custom Script file to the CMS
Add Delete Confirmation Using JavaScript and POST
Client-side form Validation Using the jQuery Validation Plugin
An Introduction to Ajax with PHP
Use JSON to Safely Encode Structured Data in an Ajax Request

Add Styling and Formatting to HTML: an Introduction to CSS
Using CSS Frameworks: Bootstrap et al
Add a General Layout and Style the Navigation Links
Add Styling and Layout to Forms and Tables
Add a Custom Stylesheet and Style the List of Articles
Add a Date and Time Picker Plugin to make Selecting Dates and Times Easier

Extract Environment-dependent Settings out into a Single Configuration File
Deny Direct Access to the config file from a Browser
Handing Errors and Exceptions: user-defined Handling Functions
Display Error and Exception Details Depending on the Environment
HTTP Status Codes and Handling Ajax Errors

Publish your Code on a Live Server