.jpg){kind=logo}
GC-PHP-MYSQL.AB1
PHP MYSQL Web Development
Intermediate Self-paced · 1 year access
61 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
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 · 1 LiveLab +
- Solution Components
- Solution Overview
- Implementing the Database
- Implementing the Online Catalog
- Implementing the Shopping Cart
- Implementing Payment
- Implementing an Administration Interface
- Extending the Project
1 LiveLab in this lesson — see the labs panel →
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
61 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
- Building a Shopping Cart
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for PHP 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
- 61 LiveLab included
- Certificate of completion
No credit card required