Pearson-PHP-MYSQL-Labs ISBN: 978-1-61691-017-4
PHP and MySQL Web Development
Gain skills and expertise in Web development with PHP and MySQL Web Development performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The labs offer hands-on experience on the topics like sorting and retrieving data; designing and creating Web database; administrating and programming advanced MySQL; generating images; social media integration and authentication; building a shopping cart; and many more. The labs covers all the concepts related to Web development and help you become a Web developer.
Self-paced · 1 year access 4.2/5 (263 Reviews)
60 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
31 Interactive Lessons · 209 topics01 PHP Crash Course 18 topics · 15 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
15 LiveLab in this lesson — see the labs panel →
02 Storing and Retrieving Data 10 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
1 LiveLab in this lesson — see the labs panel →
03 Using Arrays 10 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
6 LiveLab in this lesson — see the labs panel →
04 String Manipulation and Regular Expressions 9 topics · 1 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
1 LiveLab in this lesson — see the labs panel →
05 Reusing Code and Writing Functions 10 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
4 LiveLab in this lesson — see the labs panel →
06 Object-Oriented PHP 12 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
4 LiveLab in this lesson — see the labs panel →
07 Error and Exception Handling 5 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
2 LiveLab in this lesson — see the labs panel →
08 Designing Your Web Database 3 topics +
- Relational Database Concepts
- Designing Your Web Database
- Web Database Architecture
09 Creating Your Web Database 10 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
1 LiveLab in this lesson — see the labs panel →
10 Working with Your MySQL Database 8 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
11 LiveLab in this lesson — see the labs panel →
11 Accessing Your MySQL Database from the Web with PHP 4 topics +
- How Web Database Architectures Work
- Querying a Database from the Web
- Putting New Information in the Database
- Using Other PHP-Database Interfaces
12 Advanced MySQL Administration 7 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
13 Advanced MySQL Programming 6 topics · 4 LiveLab +
- The LOAD DATA INFILE Statement
- Storage Engines
- Transactions
- Foreign Keys
- Stored Procedures
- Triggers
4 LiveLab in this lesson — see the labs panel →
14 Web Application Security Risks 2 topics +
- Identifying the Threats We Face
- Understanding Who We're Dealing With
15 Building a Secure Web Application 7 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
16 Implementing Authentication Methods with PHP 6 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
1 LiveLab in this lesson — see the labs panel →
17 Interacting with the File System and the Server 5 topics · 3 LiveLab +
- Uploading Files
- Using Directory Functions
- Interacting with the File System
- Using Program Execution Functions
- Interacting with the Environment: getenv() and putenv()
3 LiveLab in this lesson — see the labs panel →
18 Using Network and Protocol Functions 5 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
1 LiveLab in this lesson — see the labs panel →
19 Managing the Date and Time 6 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
1 LiveLab in this lesson — see the labs panel →
20 Internationalization and Localization 4 topics +
- Localization Is More than Translation
- Understanding Character Sets
- Creating a Basic Localizable Page Structure
- Using gettext() in an Internationalized Application
21 Generating Images 7 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
1 LiveLab in this lesson — see the labs panel →
22 Using Session Control in PHP 6 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
1 LiveLab in this lesson — see the labs panel →
23 Integrating JavaScript and PHP 4 topics · 1 LiveLab +
- Understanding AJAX
- A Brief Introduction to jQuery
- Using jQuery in Web Applications
- Using jQuery and AJAX with PHP
1 LiveLab in this lesson — see the labs panel →
24 Other Useful Features 7 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
1 LiveLab in this lesson — see the labs panel →
25 Using PHP and MySQL for Large Projects 11 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
26 Debugging and Logging 7 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
1 LiveLab in this lesson — see the labs panel →
27 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
28 Building a Web-Based Email Service with Laravel Part I 1 topics +
- Introducing Laravel 5
29 Building a Web-Based Email Service with Laravel Part II 2 topics +
- Building a Simple IMAP Client using Laravel
- Pulling it All Together to Build a Web-based Email Client
30 Social Media Integration Sharing and Authentication 1 topics +
- Web Service Authentication with OAuth
31 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
Hands-On Labs Our edge
60 LiveLabs- Creating a Form
- Creating a Dynamic 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
- 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.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for PHP and MySQL Web Development
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 60 LiveLab included
- Certificate of completion
No credit card required