PHP and MySQL Phrasebook / Edition 1

Paperback (Print)
Rent from
(Save 59%)
Est. Return Date: 07/22/2015
Buy Used
Buy Used from
(Save 41%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $9.20
Usually ships in 1-2 business days
(Save 69%)
Other sellers (Paperback)
  • All (14) from $9.20   
  • New (6) from $16.99   
  • Used (8) from $9.20   


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 an author and consultant with a focus on web technologies. He co-wrote the Zend PHP 5 and Zend PHP 5.3 Certifications and has contributed to several PHP packages in the PEAR repository.

Register your book at for convenient access to downloads, updates, and corrections as they become available.

Read More Show Less

Product Details

  • ISBN-13: 9780321834638
  • Publisher: Addison-Wesley
  • Publication date: 11/13/2012
  • Series: Developer's Library Series
  • Edition number: 1
  • Pages: 360
  • Sales rank: 969,307
  • Product dimensions: 4.50 (w) x 6.90 (h) x 0.80 (d)

Meet the Author

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.

Read More Show Less

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

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted May 29, 2013

    Must have

    Best book in this theme (php and mysql)

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)