Scroll to top button

PHP and MySQL Web Development

Learn the skills of Web development with the PHP and MySQL Web Development course and performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The course and labs provide knowledge and skills of the topics such as Web application security; MySQL administration; networks and protocol functions; image generation; debugging and logging; authentication and personalization with the real-world scenarios. The course and labs are designed for the web developers and professionals working in the field of software development with the PHP language in focus.

Here's what you will get

Lessons
Lessons
33+
Quizzes
240+
Flashcards
170+
Glossary of terms
170+
Test prep
Pre-assessment Questions
100+
Post-Assessment Questions
100+
Lab
Performance lab
60+

Here's what you will learn

  • 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
  • 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 (Labs)

  • Creating a form
  • Creating a dynamic form
  • Declaring constants
  • Using arithmetic operators
  • Concatenating string
  • Using ternary operator
  • Using type operator
  • Creating a complete output form
  • Using if statement
  • Using if-else statement
  • Using switch statement
  • Using while loop
  • Using for loop
  • Using foreach loop
  • Using dowhile loop
  • Opening and reading a file
  • Creating an array
  • Inserting and retrieving values from array using foreach loop
  • Creating multidimensional array
  • Sorting an array
  • Generating a random value
  • Loading arrays from file
  • Splitting strings with regular expressions
  • Reusing code
  • Creating a function
  • Using 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
  • Inserting values into a table
  • Retrieving all the attribute values using asterisk
  • Retrieving the data from multiple tables
  • Retrieving the data in a sorted order
  • Using Aggregate functions
  • Using the GROUP BY and HAVING clauses
  • Retrieving the limited rows from the table
  • Using the NOT IN operator
  • Updating the table
  • Modifying the table definition
  • Dropping the table
  • Declaring a basic stored procedure
  • Declaring a stored function
  • Using Cursors and Loops
  • Creating a trigger
  • Implementing simple authentication mechanism
  • Creating an HTML form for file upload
  • Displaying the uploaded files
  • Displaying the directory list of the uploaded files
  • Verifying URL and email address
  • Creating a simple line graph
  • Creating a simple session
  • Creating functions using jquery
  • Listing the extensions available to PHP
  • Declaring a custom error handler
Pearson-PHP-MYSQL_pro Pearson-PHP-MYSQL_pro
Pearson-PHP-MYSQL-complete
PHP and MySQL Web Development
ISBN : 9781616910457
Rating :
(16)