Register your product to gain access to bonus material or receive a coupon.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
PDF The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
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
Working with Arrays in PHP and MySQL
Download the sample pages (includes Chapter 2 and Index)
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