Pearson-PHP-MYSQL ISBN: 978-1-61691-981-8
PHP and MySQL Web Development
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.
Self-paced · 1 year access 4.6/5 (213 Reviews)
01 / About
About This Course
Try Free →
No credit card required
Target Career Roles
- Web Designer
- Web Developer
- Lead Web Developer
- Senior Web Developer
- Full Stack Web Developer
- Front End Web Developer
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
33 Interactive Lessons · 292 topics01 Introduction 11 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
- Key Features of PHP 7
- Some of MySQL's Strengths
- What Is New in MySQL (8.x)?
- How Is This Book Organized?
- Finally
02 PHP Crash Course 20 topics +
- 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
03 Storing and Retrieving Data 13 topics +
- 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
04 Using Arrays 13 topics +
- 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
05 String Manipulation and Regular Expressions 12 topics +
- 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
06 Reusing Code and Writing Functions 13 topics +
- 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
07 Object-Oriented PHP 14 topics +
- 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
08 Error and Exception Handling 8 topics +
- 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
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 +
- 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 11 topics +
- 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 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 +
- The LOAD DATA INFILE Statement
- Storage Engines
- Transactions
- Foreign Keys
- Stored Procedures
- Triggers
- Further Reading
- Next
- Programming Exercises
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 +
- 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 8 topics +
- 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 8 topics +
- 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 9 topics +
- 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 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 +
- 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 8 topics +
- 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 7 topics +
- 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 9 topics +
- 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 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 +
- 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 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 +
- 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 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
03 / 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.