Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

PHP and MySQL Web Development

Learn PHP MySQL tools and techniques with the PHP and MySQL Web Development course and lab. The lab provides a hands-on learning experience in a safe and online environment. The PHP MySQL course and lab provide hands-on expertise to work with Web application security, MySQL administration, networks and protocol functions; image generation, debugging and logging; authentication, and personalization.
PHP and MySQL Web Development
Test Prep
100+ Pre Assessment Questions | 100+ Post Assessment Questions |
60+ LiveLab | 60+ Video tutorials | 01:20+ Hours

Why choose TOPTALENT?


Lessons 1:

  • Why You Should Read This Book
  • What You Will Learn from This Book
  • What Is PHP?
  • What Is MySQL?
  • Why Use PHP and MySQL?
  • Some of PHP’s Strengths
  • Some of MySQL’s Strengths
  • What Is New in MySQL (8.x)?
  • How Is This Book Organized?
  • Finally

Lessons 2:
PHP Crash Course

  • Before You Begin: Accessing PHP
  • Creating a Sample Application: Bob’s Auto Parts
  • Embedding PHP in HTML
  • Adding Dynamic Content
  • Accessing Form Variables
  • Understanding Identifiers
  • Examining Variable Types
  • Declaring and Using Constants
  • Understanding Variable Scope
  • Using Operators
  • Working Out the Form Totals
  • Understanding Precedence and Associativity
  • Using Variable Handling Functions
  • Making Decisions with Conditionals
  • Repeating Actions Through Iteration
  • Breaking Out of a Control Structure or Script
  • Employing Alternative Control Structure Syntax
  • Using declare
  • Next
  • Programming Exercises

Lessons 3:
Storing and Retrieving Data

  • Saving Data for Later
  • Storing and Retrieving Bob’s Orders
  • Processing Files
  • Opening a File
  • Writing to a File
  • Closing a File
  • Reading from a File
  • Using Other File Functions
  • Locking Files
  • A Better Way: Databases
  • Further Reading
  • Next
  • Programming Exercises

Lessons 4:
Using Arrays

  • What Is an Array?
  • Numerically Indexed Arrays
  • Arrays with Different Indices
  • Array Operators
  • Multidimensional Arrays
  • Sorting Arrays
  • Sorting Multidimensional Arrays
  • Reordering Arrays
  • Loading Arrays from Files
  • Performing Other Array Manipulations
  • Further Reading
  • Next
  • Programming Exercises

Lessons 5:
String Manipulation and Regular Expressions

  • Creating a Sample Application: Smart Form Mail
  • Formatting Strings
  • Joining and Splitting Strings with String Functions
  • Comparing Strings
  • Matching and Replacing Substrings with String Functions
  • Introducing Regular Expressions
  • Finding Substrings with Regular Expressions
  • Replacing Substrings with Regular Expressions
  • Splitting Strings with Regular Expressions
  • Further Reading
  • Next
  • Programming Exercises

Lessons 6:
Reusing Code and Writing Functions

  • The Advantages of Reusing Code
  • Using require() and include()
  • Using Functions in PHP
  • Defining Your Own Functions
  • Examining Basic Function Structure
  • Using Parameters
  • Understanding Scope
  • Passing by Reference Versus Passing by Value
  • Using the return Keyword
  • Implementing Recursion
  • Further Reading
  • Next
  • Programming Exercises

Lessons 7:
Object-Oriented PHP

  • Understanding Object-Oriented Concepts
  • Creating Classes, Attributes, and Operations in PHP
  • Instantiating Classes
  • Using Class Attributes
  • Calling Class Operations
  • Controlling Access with private and public
  • Writing Accessor Functions
  • Implementing Inheritance in PHP
  • Using Traits
  • Designing Classes
  • Writing the Code for Your Class
  • Understanding Advanced Object-Oriented Functionality in PHP
  • Next
  • Programming Exercises

Lessons 8:
Error and Exception Handling

  • Exception Handling Concepts
  • The Exception Class
  • User-Defined Exceptions
  • Exceptions in Bob’s Auto Parts
  • Exceptions and PHP’s Other Error Handling Mechanisms
  • Further Reading
  • Next
  • Programming Exercises

Lessons 9:
Designing Your Web Database

  • Relational Database Concepts
  • Designing Your Web Database
  • Web Database Architecture
  • Further Reading
  • Next

Lessons 10:
Creating Your Web Database