PHP-MYSQL : PHP and MySQL® Web Development

PHP and MySQL® Web Development course is aimed at readers who already know at least the basics of HTML and have done some programming in a modern programming language before but have not necessarily programmed for the web or used a relational database. The course teaches how to create interactive web applications from the simplest order form through to complex, secure web applications and how to do it using open-source technologies. The course enables you to build real-world, dynamic web applications.
Pearson-PHP-MYSQL
PHP and MySQL® Web Development
ISBN : 978-1-61691-981-8

Here's what will you get

Lessons
33+
Quizzes
240+
Flashcards
170+
Glossary of terms
170+
Pre-assessment Questions
100+
Post-Assessment Questions
100+

Here's what will you 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
uCertify

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved
app_store
google_play