PHP and MySQL Web Development

(Pearson-PHP-MYSQL) / ISBN : 978-1-61691-981-8
This course includes
Interactive Lessons
Gamified TestPrep
213 Reviews
Get A Free Trial

About This Course

PHP and MySQL Web Development course is designed for the professionals with basic knowledge of HTML and work experience of programming in a modern programming language before but have not necessarily programmed for the web or used a relational database. The course trains you on the topics of web development such as using arrays; storing and retrieving data; Object-Oriented PHP; advanced MySQL administration and programming; Web application; internationalization and localization, and many more.

Skills You’ll Get

Download Course Outline

1

Introduction

  • 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 (8.x)?
  • How Is This Book Organized?
  • Finally
2

PHP Crash Course

  • 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
3

Storing and Retrieving Data

  • 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
4

Using Arrays

  • 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
5

String Manipulation and Regular Expressions

  • 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
6

Reusing Code and Writing Functions

  • 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
7

Object-Oriented PHP

  • 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
8

Error and Exception Handling

  • 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
9

Designing Your Web Database

  • Relational Database Concepts
  • Designing Your Web Database
  • Web Database Architecture
  • Further Reading
  • Next
10

Creating Your Web Database

  • 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
11

Working with Your MySQL Database

  • 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
12

Accessing Your MySQL Database from the Web with PHP

  • 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

  • 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

  • The LOAD DATA INFILE Statement
  • Storage Engines
  • Transactions
  • Foreign Keys
  • Stored Procedures
  • Triggers
  • Further Reading
  • Next
  • Programming Exercises
15

Web Application Security Risks

  • Identifying the Threats We Face
  • Understanding Who We're Dealing With
  • Next
16

Building a Secure Web Application

  • 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

  • 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
18

Interacting with the File System and the Server

  • 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
19

Using Network and Protocol Functions

  • 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
20

Managing the Date and Time

  • 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
21

Internationalization and Localization

  • 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

  • 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
23

Using Session Control in PHP

  • 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
24

Integrating JavaScript and PHP

  • Understanding AJAX
  • A Brief Introduction to jQuery
  • Using jQuery in Web Applications
  • Using jQuery and AJAX with PHP
  • Further Reading
  • Next
  • Programming Exercises
25

Other Useful Features

  • 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
26

Using PHP and MySQL for Large Projects

  • 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

  • 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
28

Building User Authentication and Personalization

  • 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

  • Introducing Laravel
30

Building a Web-Based Email Service with Laravel Part II

  • 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

  • Web Service Authentication with OAuth
  • Conclusion
32

Building a Shopping Cart

  • 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

  • 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
scroll to top