Pearson-PHP-MYSQL-complete
PHP and MySQL Web Development
Upgrade your Web Development skills! Learn how to create dynamic and data-driven web applications.
- Practice in 60 Hands-On Labs — nothing to install
- 33 Interactive Lessons and 291 topics mapped to the official exam objectives
- 373 Practice Test Questions
Intermediate Self-paced · 1 year access 4.4/5 (243 Reviews)
60 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
33Interactive Lessons
291Topics
60LiveLab
373Practice Test Questions
170Flashcards
170Glossary of terms
01 / Skills you'll get
What you will be able to do
The PHP and MySQL training course equips you with the knowledge and skills needed to create innovative and dynamic websites. It is a step-by-step study guide that focuses on the fundamentals of PHP and MySQL to create interactive, database-driven sites. The course has a comprehensive curriculum covering everything from basic syntax to implementing advanced features. Additionally, it has been embedded with engaging multimedia resources, quizzes, flashcards and hands-on exercises to reinforce your learning. By the end of this course, you’ll be skilled to create simple websites as well as complex e-commerce platforms and content management systems.
- Understanding of core syntax: PHP, variables, data types, control structures, and functions
- Expertise in Object-Oriented Programming (OOP): create classes, and objects, and implement inheritance and polymorphism
- Manipulate files, directories, and the file system
- Session control and management
- Design relational databases using MySQL
- Skilled in data manipulation: Insert, retrieve, update, and delete
- Expert in writing SQL queries for various database operations
- Ability to integrate PHP and MySQL databases
- Skilled in dynamic content generation and form processing
- Identify and troubleshoot issues in PHP code and MySQL queries
Course Highlights
-
33 Structured Lessons Comprehensive coverage of core course objectives
-
60 Hands-On LiveLabs Interactive guided scenarios with instant evaluation
-
373 Practice Questions Assessment tests with detailed answer rationales
-
1 Year Full Access Self-paced learning accessible anytime on all devices
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
33 Interactive Lessons · 291 topics01 Introduction 10 topics +
- 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
02 PHP Crash Course 20 topics · 14 LiveLab +
- 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
14 LiveLab in this lesson — see the labs panel →
03 Storing and Retrieving Data 13 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
04 Using Arrays 13 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
05 String Manipulation and Regular Expressions 12 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
06 Reusing Code and Writing Functions 13 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
07 Object-Oriented PHP 14 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
08 Error and Exception Handling 8 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
09 Designing Your Web Database 5 topics +
- Relational Database Concepts
- Designing Your Web Database
- Web Database Architecture
- Further Reading
- Next
10 Creating Your Web Database 13 topics · 1 LiveLab +
- Using the MySQL Monitor
- Logging In to MySQL
- Creating Databases and Users
- Setting Up Users and Privileges
- Introducing MySQL's Privilege System
- Setting Up a User for the Web
- Using the Right Database
- Creating Database Tables
- Understanding MySQL Identifiers
- Choosing Column Data Types
- Further Reading
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
11 Working with Your MySQL Database 11 topics · 11 LiveLab +
- What Is SQL?
- Inserting Data into the Database
- Retrieving Data from the Database
- Updating Records in the Database
- Altering Tables After Creation
- Deleting Records from the Database
- Dropping Tables
- Dropping a Whole Database
- Further Reading
- Next
- Programming Exercises
11 LiveLab in this lesson — see the labs panel →
12 Accessing Your MySQL Database from the Web with PHP 7 topics +
- How Web Database Architectures Work
- Querying a Database from the Web
- Putting New Information in the Database
- Using Other PHP-Database Interfaces
- Further Reading
- Next
- Programming Exercises
13 Advanced MySQL Administration 10 topics +
- Understanding the Privilege System in Detail
- Making Your MySQL Database Secure
- Getting More Information About Databases
- Optimizing Your Database
- Backing Up Your MySQL Database
- Restoring Your MySQL Database
- Implementing Replication
- Further Reading
- Next
- Programming Exercises
14 Advanced MySQL Programming 9 topics · 4 LiveLab +
- The LOAD DATA INFILE Statement
- Storage Engines
- Transactions
- Foreign Keys
- Stored Procedures
- Triggers
- Further Reading
- Next
- Programming Exercises
4 LiveLab in this lesson — see the labs panel →
15 Web Application Security Risks 3 topics +
- Identifying the Threats We Face
- Understanding Who We're Dealing With
- Next
16 Building a Secure Web Application 9 topics +
- Strategies for Dealing with Security
- Securing Your Code
- Securing Your Web Server and PHP
- Database Server Security
- Protecting the Network
- Computer and Operating System Security
- Disaster Planning
- Next
- Programming Exercises
17 Implementing Authentication Methods with PHP 9 topics · 1 LiveLab +
- Identifying Visitors
- Implementing Access Control
- Using Basic Authentication
- Using Basic Authentication in PHP
- Using Basic Authentication with Apache's .htaccess Files
- Creating Your Own Custom Authentication
- Further Reading
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
18 Interacting with the File System and the Server 8 topics · 3 LiveLab +
- Uploading Files
- Using Directory Functions
- Interacting with the File System
- Using Program Execution Functions
- Interacting with the Environment: getenv() and putenv()
- Further Reading
- Next
- Programming Exercises
3 LiveLab in this lesson — see the labs panel →
19 Using Network and Protocol Functions 8 topics · 1 LiveLab +
- Examining Available Protocols
- Sending and Reading Email
- Using Data from Other Websites
- Using Network Lookup Functions
- Backing Up or Mirroring a File
- Further Reading
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
20 Managing the Date and Time 9 topics · 1 LiveLab +
- Getting the Date and Time from PHP
- Converting Between PHP and MySQL Date Formats
- Calculating Dates in PHP
- Calculating Dates in MySQL
- Using Microseconds
- Using the Calendar Functions
- Further Reading
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
21 Internationalization and Localization 7 topics +
- Localization Is More than Translation
- Understanding Character Sets
- Creating a Basic Localizable Page Structure
- Using gettext() in an Internationalized Application
- Further Reading
- Next
- Programming Exercises
22 Generating Images 9 topics · 1 LiveLab +
- Setting Up Image Support in PHP
- Understanding Image Formats
- Creating Images
- Using Automatically Generated Images in Other Pages
- Using Text and Fonts to Create Images
- Drawing Figures and Graphing Data
- Using Other Image Functions
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
23 Using Session Control in PHP 8 topics · 1 LiveLab +
- What Is Session Control?
- Understanding Basic Session Functionality
- Implementing Simple Sessions
- Creating a Simple Session Example
- Configuring Session Control
- Implementing Authentication with Session Control
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
24 Integrating JavaScript and PHP 7 topics · 1 LiveLab +
- Understanding AJAX
- A Brief Introduction to jQuery
- Using jQuery in Web Applications
- Using jQuery and AJAX with PHP
- Further Reading
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
25 Other Useful Features 9 topics · 1 LiveLab +
- Evaluating Strings: eval()
- Terminating Execution: die() and exit()
- Serializing Variables and Objects
- Getting Information About the PHP Environment
- Temporarily Altering the Runtime Environment
- Highlighting Source Code
- Using PHP on the Command Line
- Next
- Programming Exercises
1 LiveLab in this lesson — see the labs panel →
26 Using PHP and MySQL for Large Projects 13 topics +
- Applying Software Engineering to Web Development
- Planning and Running a Web Application Project
- Reusing Code
- Writing Maintainable Code
- Implementing Version Control
- Choosing a Development Environment
- Documenting Your Projects
- Prototyping
- Separating Logic and Content
- Optimizing Code
- Testing
- Further Reading
- Next
27 Debugging and Logging 8 topics · 1 LiveLab +
- Programming Errors
- Variable Debugging Aid
- Error Reporting Levels
- Altering the Error Reporting Settings
- Triggering Your Own Errors
- Logging Errors Gracefully
- Logging Errors to a Log File
- Next
1 LiveLab in this lesson — see the labs panel →
28 Building User Authentication and Personalization 8 topics +
- Solution Components
- Solution Overview
- Implementing the Database
- Implementing the Basic Site
- Implementing User Authentication
- Implementing Bookmark Storage and Retrieval
- Implementing Recommendations
- Considering Possible Extensions
29 Building a Web-Based Email Service with Laravel Part I 1 topics +
- Introducing Laravel
30 Building a Web-Based Email Service with Laravel Part II 3 topics +
- Building a Simple IMAP Client using Laravel
- Pulling it All Together to Build a Web-based Email Client
- Conclusion
31 Social Media Integration Sharing and Authentication 2 topics +
- Web Service Authentication with OAuth
- Conclusion
32 Building a Shopping Cart 8 topics +
- Solution Components
- Solution Overview
- Implementing the Database
- Implementing the Online Catalog
- Implementing the Shopping Cart
- Implementing Payment
- Implementing an Administration Interface
- Extending the Project
33 Installing Apache, PHP, and MySQL 4 topics +
- Installing Apache, PHP, and MySQL Under UNIX
- Installing Apache, PHP, and MySQL for Windows and Mac OS X Using All-in-One Installation Packages
- Installing PEAR
- Installing PHP with Other Web Servers
Hands-On Labs Our edge
60 LiveLabs- Creating a Form
- Declaring Constants
- Using Arithmetic Operators
- Concatenating Strings
- Using the Ternary Operator
- Using the Type Operator
- Creating an Output Form
- Using the if Statement
- Using the if-else Statement
- Using the switch Statement
- Using the while Loop
- Using the for Loop
- Using the foreach Loop
- Using the do-while Loop
- Opening and Reading a File
- Creating an Array
- Inserting and Retrieving Values from an Array Using the foreach Loop
- Creating a Multi-dimensional Array
- Sorting an Array
- Generating a Random Value
- Loading Arrays from a File
- Creating a Dynamic Form
- Splitting Strings with Regular Expressions
- Reusing the Code
- Creating a Function
- Using the Pass by Reference
- Reversing a String Using Recursion and Iteration
- Creating an Instance of a Class
- Implementing Function Overriding
- Implementing Static Methods
- Generating a Fizzbuzz Sequence
- Creating a User-Defined Exception Class
- Implementing Error Handling
- Creating a Table
- Inserting Values into a Table
- Retrieving All the Attribute Values Using an Asterisk
- Retrieving the Data from Multiple Tables
- Retrieving the Data in Sorted Order
- Using Aggregate Functions
- Using the GROUP BY and HAVING Clauses
- Retrieving the Limited Number of Rows from the Table
- Using the NOT IN Operator
- Updating a Table
- Modifying a Table Definition
- Dropping a Table
- Declaring a Basic Stored Procedure
- Declaring a Stored Function
- Using Cursors and Loops
- Creating a Trigger
- Implementing a Simple Authentication Mechanism
- Creating an HTML Form for File Upload
- Displaying the Uploaded Files
- Displaying the Directory List of the Uploaded Files
- Verifying the URL and Email Address
- Calculating Age
- Creating a Simple Line Graph
- Creating a Simple Session
- Creating Functions Using jQuery
- Listing the Extensions Available to PHP
- Declaring a Custom Error Handler
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
What are the benefits of learning PHP and MySQL? +
PHP and MySQL are amongst the most popular programming languages and databases for web development. Learning these technologies will make you a high-demand skilled professional suitable for a variety of job roles including web developer, software engineer, full-stack developer, and more.
What is the correlation between PHP and MySQL in web development? +
PHP is the server-side scripting language used to generate dynamic content on web pages whereas MySQL is the relational database management system (RDBMS). PHP acts as the bridge between the user and the database, while MySQL serves as the data storage and retrieval system. Both are needed to create interactive websites that can display personalized content, process user input, and manage data efficiently.
Does this course require any previous training or experience? +
It is recommended to have a foundational knowledge of HTML, CSS, and JavaScript to accelerate your learning and for better understanding. Although, it is a beginner-friendly course that will help you build on your web development skills gradually.
What is the difference between PHP vs JavaScript? +
PHP and JavaScript both are programming languages for web development with distinctive features used for different purposes. PHP is used for server-side scripting whereas JavaScript is used for the client-side. PHP can generate the initial HTML structure of a page, while JavaScript can add dynamic elements and interactivity to the page.
Does this course cover both PHP and JavaScript programming? +
This course primarily focuses on PHP and MySQL for web development. The use of JavaScript is only limited to PHP integration for adding interactive elements.
Keep going
You might also like
Build Websites From Scratch
Step-by-step guide to enhance your web development skills with PHP and MySQL.
- 1 year of full access
- 60 LiveLab included
- Certificate of completion