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.
- Price: $279.99
- Delivery method: eLearning
- DIR Discount: 20%
Submit form to obtain discount
Test Prep
100+ Pre Assessment Questions |
100+ Post Assessment Questions |
Features
60+ LiveLab |
60+ Video tutorials |
01:20+ Hours
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
Outline
Lessons 1:
Introduction
- 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