PHP and MySQL Web Development
(Pearson-PHP-MYSQL-complete)
/ ISBN: 9781616910457
This course includes
Lessons
TestPrep
LiveLab
PHP and MySQL Web Development
Learn about Web development with the PHP and MySQL Web Development course and lab. The lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any text-book, course, or training. The PHP/MySQL training course and lab provide knowledge on topics such as Web application security, MySQL administration, networks and protocol functions; image generation, debugging and logging; authentication, and personalization. The course and lab are designed for web developers and professionals working in the field of software development with PHP in focus.
Lessons
-
33+ Lessons
-
240+ Quizzes
-
170+ Flashcards
-
170+ Glossary of terms
TestPrep
-
100+ Pre Assessment Questions
-
100+ Post Assessment Questions
Lab
-
60+ Performance lab
-
60+ Video tutorials
-
01:21+ 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
- Key Features of PHP 7
- Some of MySQL's Strengths
- What Is New in MySQL (5.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 5
- 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 (Performance Labs)
- Creating a form
- Creating a dynamic form
- Declaring constants
- Using the arithmetic operators
- Concatenating strings
- Using the ternary operator
- Using the type operator
- Creating a complete 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 dowhile loop
- Opening and reading a file
- Creating an array
- Inserting and retrieving values from the array using the foreach loop
- Creating the multidimensional 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
×
