Beginning PHP and MySQL 5

An Introduction to PHP -- History -- PHP 4 -- PHP 5 -- General Language Features -- Practicality -- Power -- Possibility -- Price -- Installing and Configuring Apache and PHP -- Installation -- Obtaining the Distributions -- The Installation Process -- Testing Your Installation -- Customizing the Unix Build -- Customizing the Windows Build -- Common Pitfalls -- Viewing and Downloading the Documentation -- Configuration -- Managing PHP's Configuration Directives -- PHP's Configuration Directives -- PHP Basics -- Escaping to PHP -- Default Syntax -- Short-Tags -- Script -- ASP-Style -- Embedding Multiple Code Blocks -- Single-line C++ Syntax -- Shell Syntax -- Multiple-Line C Syntax -- Output -- print() -- echo() -- printf() -- sprintf() -- Datatypes -- Scalar Datatypes -- Compound Datatypes -- Special Datatypes -- Type Casting -- Type Juggling -- Type-Related Functions -- Type Identifier Functions -- Identifiers -- Variables -- Variable Declaration -- Variable Scope -- PHP's Superglobal Variables -- Variable Variables -- Constants -- Expressions -- Operands -- Operators -- String Interpolation -- Double Quotes -- Single Quotes -- Heredoc -- Control Structures -- Execution Control Statements -- Conditional Statements -- Looping Statements -- File Inclusion Statements -- Functions -- Invoking a Function -- Creating a Function -- Passing Arguments by Value -- Passing Arguments by Reference -- Default Argument Values -- Optional Arguments -- Returning Values from a Function -- Nesting Functions -- Recursive Functions -- Variable Functions -- Function Libraries -- Arrays -- What Is an Array? -- Outputting Arrays -- Creating an Array -- Testing for an Array -- Adding and Removing Array Elements -- Locating Array Elements -- Traversing Arrays -- Determining Array Size and Uniqueness -- Sorting Arrays -- Merging, Slicing, Splicing, and Dissecting Arrays -- Other Useful Array Functions -- Object-Oriented PHP -- The Benefits of OOP -- Encapsulation -- Inheritance -- Polymorphism -- Key OOP Concepts -- Classes -- Objects -- Fields -- Properties -- _set() -- Constants -- Methods -- Type Hinting -- Constructors and Destructors -- Constructors -- Destructors -- Static Class Members -- The instanceof Keyword -- Helper Functions -- Autoloading Objects -- Advanced OOP Features -- Advanced OOP Features Not Supported by PHP -- Object Cloning -- Cloning Example -- The_clone() Method -- Inheritance -- Class Inheritance -- Inheritance and Constructors -- Interfaces -- Implementing a Single Interface -- Implementing Multiple Interfaces -- Abstract Classes -- Reflection -- Writing the ReflectionClass Class -- Writing the ReflectionMethod Class -- Writing the ReflectionParameter Class -- Writing the ReflectionProperty Class -- Other Reflection Applications -- Error and Exception Handling -- Configuration Directives -- Error Logging -- Exception Handling -- Why Exception Handling Is Handy -- PHP's Exception-Handling Implementation -- Strings and Regular Expressions -- Complex (Curly) Offset Syntax -- Regular Expressions -- Regular Expression Syntax (POSIX) -- PHP's Regular Expression Functions (POSIX Extended) -- Regular Expression Syntax (Perl Style) -- Other String-Specific Functions -- Determining the Length of a String -- Comparing Two Strings -- Manipulating String Case -- Converting Strings to and from HTML -- Alternatives for Regular Expression Functions -- Padding and Stripping a String -- Counting Characters and Words -- Taking Advantage of PEAR: Validate_US -- Installing Validate_US -- Using Validate_US -- Working with the File and Operating System -- Learning About Files and Directories -- Parsing Directory Paths -- File Types and Links -- Calculating File, Directory, and Disk Sizes -- Access and Modification Times -- File Ownership and Permissions -- File I/O -- The Concept of a Resource -- Newline -- End-of-File -- Opening and Closing a File -- Reading from a File -- Moving the File Pointer -- Writing to a File -- Reading Directory Contents -- Executing Shell Commands -- PHP's Built-in System Commands -- System-Level Program Execution -- Sanitizing the Input -- PHP's Program Execution Functions -- PEAR -- Popular PEAR Packages -- Converting Numeral Formats -- Installing and Updating PEAR -- Installing PEAR -- PEAR and Hosting Companies -- Updating PEAR -- Using the PEAR Package Manager -- Viewing Installed Packages -- Learning More About an Installed Package -- Installing a Package -- Using a Package -- Upgrading a Package -- Uninstalling a Package -- Downgrading a Package -- Date and Time -- The Unix Timestamp -- PHP's Date and Time Library -- Date Fu -- Displaying the Localized Date and Time -- Displaying the Web Page's Most Recent Modification Date -- Determining the Number Days in the Current Month -- Calculating the Date X Days from the Present Date -- Creating a Calendar -- PHP 5.1 -- Date Fundamentals -- The Date Constructor -- Accessors and Mutators -- Validators -- Manipulation Methods -- Forms and Navigational Cues -- PHP and Web Forms -- Passing Form Data to a Function -- Working with Multivalued Form Components -- Generating Forms with PHP -- Autoselecting Forms Data -- PHP, Web Forms, and JavaScript -- Navigational Cues -- User-Friendly URLs -- Breadcrumb Trails -- Creating Custom Error Handlers -- Authentication -- HTTP Authentication Concepts -- PHP Authentication -- Authentication Variables -- Authentication Methodologies -- User Login Administration -- Password Designation -- Testing Password Guessability with the CrackLib Library -- One-Time URLs and Password Recovery -- Handling File Uploads -- Uploading Files via the HTTP Protocol -- Handling Uploads with PHP -- PHP's File Upload/Resource Directives -- The $_FILES Array -- PHP's File-Upload Functions -- Upload Error Messages -- File-Upload Examples -- Taking Advantage of PEAR: HTTP_Upload -- Installing HTTP_Upload -- Learning More About an Uploaded File -- Moving an Uploaded File to the Final Destination -- Uploading Multiple Files -- Networking -- DNS, Services, and Servers -- DNS -- Services -- Establishing Socket Connections -- Mail -- Configuration Directives -- Sending a Plain-Text E-Mail -- Sending an E-Mail with Additional Headers -- Sending an E-Mail to Multiple Recipients -- Sending an HTML-Formatted E-Mail -- Sending an Attachment -- IMAP, POP3, and NNTP -- Requirements -- Establishing and Closing a Connection -- Learning More About Mailboxes and Mail -- Retrieving Messages -- Composing a Message -- Sending a Message -- Mailbox Administration -- Message Administration -- Streams -- Stream Wrappers and Contexts -- Stream Filters -- Common Networking Tasks -- Pinging a Server -- A Port Scanner -- Subnet Converter -- Testing User Bandwidth -- PHP and LDAP -- An Introduction to LDAP -- Learning More About LDAP -- Using LDAP from PHP -- Connecting to the LDAP Server -- Binding to the LDAP Server -- Closing the LDAP Server Connection -- Retrieving LDAP Data -- Working with Entry Values -- Counting Retrieved Entries -- Retrieving Attributes -- Sorting and Comparing LDAP Entries -- Working with Entries -- Deallocating Memory -- Inserting LDAP Data -- Updating LDAP Data -- Deleting LDAP Data -- Configuration Functions -- Character Encoding -- Working with the Distinguished Name -- Error Handling -- Session Handlers -- What Is Session Handling? -- Cookies -- URL Rewriting -- The Session-Handling Process -- Configuration Directives -- Starting a Session -- Destroying a Session -- Retrieving and Setting the Session ID -- Creating and Deleting Session Variables -- Encoding and Decoding Session Data -- Practical Session-Handling Examples -- Auto-Login -- Recently Viewed Document Index -- Creating Custom Session Handlers -- Tying Custom Session Functions into PHP's Logic -- Custom MySQL-Based Session Handlers -- Templating with Smarty -- What's a Templating Engine? -- Introducing Smarty -- Installing Smarty -- Using Smarty -- Smarty's Presentational Logic -- Variable Modifiers -- Control Structures -- Statements -- Creating Configuration Files -- config_load -- Referencing Configuration Variables -- Using CSS in Conjunction with Smarty -- Caching -- Working with the Cache Lifetime -- Eliminating Processing Overhead with is_cached() -- Creating Multiple Caches per Template -- Some Final Words About Caching -- Web Services -- Why Web Services? -- Real Simple Syndication -- RSS Syntax -- MagpieRSS -- SimpleXML -- SimpleXML Functions -- SimpleXML Methods -- SOAP -- NuSOAP -- PHP 5's SOAP Extension -- Using a C# Client with a PHP Web Service -- Secure PHP Programming -- Configuring PHP Securely -- Safe Mode -- Other Security-Related Configuration Parameters -- Hiding Configuration Details -- Hiding Apache and PHP -- Hiding Sensitive Data -- Take Heed of the Document Root -- Denying Access to Certain File Extensions -- Sanitizing User Data -- File Deletion -- Cross-Site Scripting -- Sanitizing User Input: The Solution -- Data Encryption -- PHP's Encryption Functions -- mhash -- MCrypt -- SQLite -- Introduction to SQLite -- Installing SQLite -- Using the SQLite Command-Line Interface -- PHP's SQLite Library -- SQLite Directives -- Opening a Connection -- Creating a Table in Memory -- Closing a Connection -- Querying a Database -- Parsing Result Sets -- Retrieving Result Set Details -- Manipulating the Result Set Pointer -- Learning More About Table Schemas -- Working with Binary Data -- Creating and Overriding SQLite Functions -- Creating Aggregate Functions -- Introducing PDO -- Another Database Abstraction Layer? -- Using PDO -- Installing PDO -- PDO's Database Support -- Connecting to a Database Server and Selecting a Database -- Getting and Setting Attributes -- Error Handling -- Query Execution -- Prepared Statements -- Retrieving Data -- Setting Bound Columns -- Transactions -- Introducing MySQL -- What Makes MySQL So Popular? -- Flexibility -- Power -- Flexible Licensing Options -- A (Hyper) Active User Community -- MySQL 4 -- MySQL 5