PHP and MySQL Phrasebook gives you the code you need to  complete your web programming projects quickly and effectively in PHP, the leading scripting language for creating dynamic web pages.   Concise and Accessible Easy to carry and easy to use–lets you ditch all those bulky books for one portable pocket guide   Flexible and Functional Packed with more than 100 customizable code snippets–so you can readily code functional PHP and MySQL in just about any situation    

Table of Contents:
Introduction            1 1 Manipulating Strings      7     Comparing Strings      8     Checking Usernames and Passwords      9     Converting Strings into HTML      11     Using Line Breaks      13     Encrypting Strings      14     Checksumming Strings      16     Extracting Substrings      19     Protecting Email Addresses Using ASCII Codes      20     Scanning Formatted Strings      24     Getting Detailed Information about Variables      25     Searching in Strings      26     Using Perl-Compatible Regular Expressions      29     Finding Tags with Regular Expressions      30     Validating Mandatory Input      31     Validating Email Addresses      34     Search and Replace      35 2 Working with Arrays      39     Accessing All Elements of Numeric Arrays      41     Accessing All Elements of Associative Arrays      43     Accessing All Array Elements in Nested Arrays      44     Turning an Array into Variables      47     Converting Strings to Arrays      48     Converting Arrays to Strings      49     Sorting Arrays Alphabetically      50     Sorting Associative Arrays Alphabetically      51     Sorting Nested Arrays      53     Sorting Nested Associative Arrays      55     Sorting IP Addresses (as a Human Would)      57     Sorting Anything      58     Sorting with Foreign Languages      59     Applying an Effect to All Array Elements      61     Filtering Arrays      65     Getting Random Elements Out of Arrays      67     Making Objects Behave Like Arrays      68 3 Date and Time      71     Using Text within date()      74     Formatting DateTime Objects      75     Automatically Localizing Dates      75     Manually Localizing Dates      79     Using the Current Date, the U.S./U.K./European Way      80     Formatting a Specific Date      80     Validating a Date      82     Calculating a Relative Date      83     Creating a Sortable Time Stamp      84     Converting a String into a Date      85     Determining Sunrise and Sunset      86     Using Date and Time for Benchmarks      87     Using Form Fields for Date Selection      89     Create Self-Updating Form Fields for Date Selection      91     Calculating the Difference between Two Dates      93     Using GMT Date/Time Information      96 4 Working with Objects (and Related Topics)      99     Setting Up Classes      100     Understanding Inheritance      102     Using Abstract Classes and Interfaces      104     Preventing Inheritance and Overwriting      108     Using Autoloading      109     Cloning Objects      111     Serializing and Deserializing Objects      113     Implementing Singletons      115     Using Traits      120 5 Interacting with Web Forms      123     Sending Form Data Back to the Current Script      124     Reading Out Form Data      125     Checking Whether a Form Has Been Submitted      128     Saving Form Data into a Cookie      129     Prefilling Text Fields and Password Fields      131     Prefilling Multiline Text Fields      135     Preselecting Radio Buttons      136     Preselecting Check Boxes      137     Preselecting Selection Lists      138     Preselecting Multiple Selection Lists      140     Processing Graphical Submit Buttons      143     Checking Mandatory Fields      144     Checking Selection Lists      146     Escaping Output      149     Validating Input      150     Writing All Form Data into a File      151     Sending All Form Data via Email      153     Getting Information about File Uploads      154     Moving Uploaded Files to a Safe Location      157     Monitoring the Progress of a File Upload      158 6 Remembering Users (Cookies and Sessions)      163     Understanding Cookies      164     Creating a Cookie      167     Reading Out Cookies      169     Setting a (Reasonable) Expiry Date      170     Setting a Client-Specific Expiry Date      171     Deleting a Cookie      172     Making Cookies Accessible for Several Domains      174     Checking Whether the Client Supports Cookies      176     Saving Multiple Data in One Cookie      177     Saving the User’s Language Preference      180     Understanding Sessions      182     Where to Store the Sessions      183     How to Maintain the Session State      184     Activating Sessions      185     Reading and Writing Sessions      186     Closing Sessions      187     Changing the Session ID      187     Implementing a Custom Session Management      189     Creating a Secured Area with Sessions      195     Creating a Secured Area without Sessions      197 7 Using Files on the Server File System      201     Opening and Closing Files      202     Reading from Files      205     Writing to Files      207     Locking Files      208     Using Relative Paths for File Access      209     Avoiding Security Traps with File Access      210     Working with CSV Data      212     Parsing INI Files      216     Retrieving File Information      217     Copying, Moving, and Deleting Files      220     Browsing the File System      221     Using PHP Streams      222     Using Bzip2 Archives      224     Returning Files with an HTTP Request      227 8 Working with MySQL Databases      229     Connecting to MySQLi      231     Sending SQL to MySQL      233     Prepared Statements with MySQL      235     Retrieving Results of a Query to MySQL      236     Retrieving the Last Inserted ID      239     Using Transactions      240 9 Working with Other Databases      243     Connecting to SQLite      244     Sending SQL to SQLite      246     Retrieving Results of a Query to SQLite      248     Using Prepared Statements with SQLite      250     Connecting to PostgreSQL      252     Sending SQL to PostgreSQL      253     Updating Data in PostgreSQL      254     Retrieving Results of a Query to PostgreSQL      255     Connecting to Oracle      257     Sending SQL to Oracle      258     Retrieving Results of a Query to Oracle      260     Connecting to MSSQL      262     Sending SQL to MSSQL      264     Retrieving Results of a Query to MSSQL      265     Using Prepared Statements with MSSQL      266     Using MSSQL without Windows      268     Connecting to Firebird      270     Sending SQL to Firebird      271     Retrieving Results of a Query to Firebird      272     Connecting via PDO      273     Sending SQL via PDO      275     Retrieving Results of a Query via PDO      276 10 Using XML      279     Parsing XML with SAX      280     Parsing XML with XMLReader      282     Using DOM to Read XML      284     Using DOM to Write XML      285     Using XMLWriter to Write XML      287     Using SimpleXML      288     Using XPath with SimpleXML      289     Transforming XML with XSL      290     Validating XML      291 11 Communicating with Others      295     Connecting with HTTP Servers      295     Connecting with FTP Servers      298     Checking Whether a Server Is Still Reacting      300     Creating a Web Service with NuSOAP      304     Automatically Generating WSDL with NuSOAP      306     Consuming a Web Service with NuSOAP      308     Creating a Web Service with the PHP 5 SOAP Extension      309     Consuming a Web Service with the PHP 5 SOAP Extension      312     Using Ajax      313     Exchanging Data with the Server      316 TOC, 9780321834638, 10/3/2012