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