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