PHP and MySQL Phrasebook

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