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
Christian Wenz is a professional phrasemonger, author, trainer, and consultant with a focus on web technologies. He has written or cowritten more than one hundred books. He frequently contributes articles to renowned IT magazines and speaks at developer conferences around the globe. Christian contributes to several PHP libraries and frameworks and other open source software. He holds university degrees in computer sciences and in business informatics and lives and works in Munich, Germany. He also is one of the authors of Zend's PHP 5 and PHP 5.3 certifications.
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