PHP with MySQL Essential Training

PHP with MySQL Essential Training

English | MP4 | AVC 1280×800 | AAC 44KHz 2ch | 14.5 Hours | 1.58 GB

PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code.

Topics include:

  • What is PHP?
  • Installing and configuring PHP and MySQL
  • Exploring data types
  • Controlling code with logical expressions and loops
  • Using PHP’s built-in functions
  • Writing custom functions
  • Building dynamic webpages
  • Working with forms and form data
  • Using cookies and sessions to store data
  • Connecting to MySQL with PHP
  • Creating and editing database records
  • Building a content management system
  • Adding user authentication
Table of Contents

001 Welcome
002 Using the exercise files

PHP Overview
003 What is PHP
004 The history of PHP
005 Why choose PHP
006 Installation overview

Mac Installation
007 Overview
008 Working with Apache Web Server
009 Changing the document root
010 Installing to Yosemite
011 Enabling PHP
012 Upgrading PHP
013 Configuring PHP
014 Installing MySQL
015 Configuring MySQL
016 Text editor

Windows Installation
017 Overview
018 Installing WampServer
019 Finding the document root
020 Configuring PHP
021 Configuring MySQL
022 Text editor

First Steps
023 Embedding PHP code on a page
024 Outputting dynamic text
025 The operational trail
026 Inserting code comments

Exploring Data Types
027 Variables
028 Strings
029 String functions
030 Numbers part one – Integers
031 Numbers part two – Floating points
032 Arrays
033 Associative arrays
034 Array functions
035 Booleans
036 NULL and empty
037 Type juggling and casting
038 Constants

Control Structures – Logical Expressions
039 If statements
040 Else and elseif statements
041 Logical operators
042 Switch statements

Control Structures – Loops
043 While loops
044 For loops
045 Foreach loops
046 Continue
047 Break
048 Understanding array pointers

User-Defined Functions
049 Defining functions
050 Function arguments
051 Returning values from a function
052 Multiple return values
053 Scope and global variables
054 Setting default argument values

055 Common problems
056 Warnings and errors
057 Debugging and troubleshooting

Building Web Pages with PHP
058 Links and URLs
059 Using GET values
060 Encoding GET values
061 Encoding for HTML
062 Including and requiring files
063 Modifying headers
064 Page redirection
065 Output buffering

Working with Forms and Form Data
066 Building forms
067 Detecting form submissions
068 Single-page form processing
069 Validating form values
070 Problems with validation logic
071 Displaying validation errors
072 Custom validation functions
073 Single-page form with validations

Working with Cookies and Sessions
074 Working with cookies
075 Setting cookie values
076 Reading cookie values
077 Unsetting cookie values
078 Working with sessions

MySQL Basics
079 MySQL introduction
080 Creating a database
081 Creating a database table
082 CRUD in MySQL
083 Populating a MySQL database
084 Relational database tables
085 Populating the relational table

Using PHP to Access MySQL
086 Database APIs in PHP
087 Connecting to MySQL with PHP
088 Retrieving data from MySQL
089 Working with retrieved data
090 Creating records with PHP
091 Updating and deleting records with PHP
092 SQL injection
093 Escaping strings for MySQL
094 Introducing prepared statements

Building a Content Management System (CMS)
095 Blueprinting the application
096 Building the CMS database
097 Establishing your work area
098 Creating and styling the first page
099 Making page assets reusable
100 Connecting the application to the database

Using Site Navigation to Choose Content
101 Adding pages to the navigation subjects
102 Refactoring the navigation
103 Selecting pages from the navigation
104 Highlighting the current page
105 Moving the navigation to a function

Application CRUD
106 Finding a subject in the database
107 Refactoring the page selection
108 Creating a new subject form
109 Processing form values and adding subjects
110 Passing data in the session
111 Validating form values
112 Creating an edit subject form
113 Using single-page submission
114 Deleting a subject
115 Cleaning up
116 Assignment – Pages CRUD
117 Assignment results – Pages CRUD

Building the Public Area
118 The public appearance
119 Using a context for conditional code
120 Adding a default subject behavior
121 The public content area
122 Protecting page visibility

Regulating Page Access
123 User authentication overview
124 Admin CRUD
125 Encrypting passwords
126 Salting passwords
127 Adding password encryption to CMS
128 New PHP password functions
129 Creating a login system
130 Checking for authorization
131 Creating a logout page

132 Next steps