PHP and MySQL Web Development
(Pearson-PHP-MYSQL-complete)
/ ISBN: 978-1-61691-045-7
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
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.
Lessons
-
33+ Lessons
-
12+ Exercises
-
238+ Quizzes
-
170+ Flashcards
-
170+ Glossary of terms
TestPrep
-
100+ Pre Assessment Questions
-
100+ Post Assessment Questions
LiveLab
-
60+ LiveLab
-
60+ Video tutorials
-
01:20+ Hours
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Relational Database Concepts
- Designing Your Web Database
- Web Database Architecture
- Further Reading
- Next
- 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
- 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
- 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
- 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
- The LOAD DATA INFILE Statement
- Storage Engines
- Transactions
- Foreign Keys
- Stored Procedures
- Triggers
- Further Reading
- Next
- Programming Exercises
- Identifying the Threats We Face
- Understanding Who We're Dealing With
- Next
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Understanding AJAX
- A Brief Introduction to jQuery
- Using jQuery in Web Applications
- Using jQuery and AJAX with PHP
- Further Reading
- Next
- Programming Exercises
- 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
- 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
- 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
- Solution Components
- Solution Overview
- Implementing the Database
- Implementing the Basic Site
- Implementing User Authentication
- Implementing Bookmark Storage and Retrieval
- Implementing Recommendations
- Considering Possible Extensions
- Introducing Laravel
- Building a Simple IMAP Client using Laravel
- Pulling it All Together to Build a Web-based Email Client
- Conclusion
- Web Service Authentication with OAuth
- Conclusion
- Solution Components
- Solution Overview
- Implementing the Database
- Implementing the Online Catalog
- Implementing the Shopping Cart
- Implementing Payment
- Implementing an Administration Interface
- Extending the Project
- 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 Activities (Live Labs)
- 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
×
