- ホーム
- > 洋書
- > 英文書
- > Computer / Languages
Full Description
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 AccessibleEasy to carry and easy to use-lets you ditch all those bulky books for one portable pocket guideFlexible and FunctionalPacked with more than 100 customizable code snippets-so you can readily code functional PHP and MySQL in just about any situation
Contents
Introduction 11 Manipulating Strings 7Comparing Strings 8Checking Usernames and Passwords 9Converting Strings into HTML 11Using Line Breaks 13Encrypting Strings 14Checksumming Strings 16Extracting Substrings 19Protecting Email Addresses Using ASCII Codes 20Scanning Formatted Strings 24Getting Detailed Information about Variables 25Searching in Strings 26Using Perl-Compatible Regular Expressions 29Finding Tags with Regular Expressions 30Validating Mandatory Input 31Validating Email Addresses 34Search and Replace 352 Working with Arrays 39Accessing All Elements of Numeric Arrays 41Accessing All Elements of Associative Arrays 43Accessing All Array Elements in Nested Arrays 44Turning an Array into Variables 47Converting Strings to Arrays 48Converting Arrays to Strings 49Sorting Arrays Alphabetically 50Sorting Associative Arrays Alphabetically 51Sorting Nested Arrays 53Sorting Nested Associative Arrays 55Sorting IP Addresses (as a Human Would) 57Sorting Anything 58Sorting with Foreign Languages 59Applying an Effect to All Array Elements 61Filtering Arrays 65Getting Random Elements Out of Arrays 67Making Objects Behave Like Arrays 683 Date and Time 71Using Text within date() 74Formatting DateTime Objects 75Automatically Localizing Dates 75Manually Localizing Dates 79Using the Current Date, the U.S./U.K./European Way 80Formatting a Specific Date 80Validating a Date 82Calculating a Relative Date 83Creating a Sortable Time Stamp 84Converting a String into a Date 85Determining Sunrise and Sunset 86Using Date and Time for Benchmarks 87Using Form Fields for Date Selection 89Create Self-Updating Form Fields for Date Selection 91Calculating the Difference between Two Dates 93Using GMT Date/Time Information 964 Working with Objects (and Related Topics) 99Setting Up Classes 100Understanding Inheritance 102Using Abstract Classes and Interfaces 104Preventing Inheritance and Overwriting 108Using Autoloading 109Cloning Objects 111Serializing and Deserializing Objects 113Implementing Singletons 115Using Traits 1205 Interacting with Web Forms 123Sending Form Data Back to the Current Script 124Reading Out Form Data 125Checking Whether a Form Has Been Submitted 128Saving Form Data into a Cookie 129Prefilling Text Fields and Password Fields 131Prefilling Multiline Text Fields 135Preselecting Radio Buttons 136Preselecting Check Boxes 137Preselecting Selection Lists 138Preselecting Multiple Selection Lists 140Processing Graphical Submit Buttons 143Checking Mandatory Fields 144Checking Selection Lists 146Escaping Output 149Validating Input 150Writing All Form Data into a File 151Sending All Form Data via Email 153Getting Information about File Uploads 154Moving Uploaded Files to a Safe Location 157Monitoring the Progress of a File Upload 1586 Remembering Users (Cookies and Sessions) 163Understanding Cookies 164Creating a Cookie 167Reading Out Cookies 169Setting a (Reasonable) Expiry Date 170Setting a Client-Specific Expiry Date 171Deleting a Cookie 172Making Cookies Accessible for Several Domains 174Checking Whether the Client Supports Cookies 176Saving Multiple Data in One Cookie 177Saving the User's Language Preference 180Understanding Sessions 182Where to Store the Sessions 183How to Maintain the Session State 184Activating Sessions 185Reading and Writing Sessions 186Closing Sessions 187Changing the Session ID 187Implementing a Custom Session Management 189Creating a Secured Area with Sessions 195Creating a Secured Area without Sessions 1977 Using Files on the Server File System 201Opening and Closing Files 202Reading from Files 205Writing to Files 207Locking Files 208Using Relative Paths for File Access 209Avoiding Security Traps with File Access 210Working with CSV Data 212Parsing INI Files 216Retrieving File Information 217Copying, Moving, and Deleting Files 220Browsing the File System 221Using PHP Streams 222Using Bzip2 Archives 224Returning Files with an HTTP Request 2278 Working with MySQL Databases 229Connecting to MySQLi 231Sending SQL to MySQL 233Prepared Statements with MySQL 235Retrieving Results of a Query to MySQL 236Retrieving the Last Inserted ID 239Using Transactions 2409 Working with Other Databases 243Connecting to SQLite 244Sending SQL to SQLite 246Retrieving Results of a Query to SQLite 248Using Prepared Statements with SQLite 250Connecting to PostgreSQL 252Sending SQL to PostgreSQL 253Updating Data in PostgreSQL 254Retrieving Results of a Query to PostgreSQL 255Connecting to Oracle 257Sending SQL to Oracle 258Retrieving Results of a Query to Oracle 260Connecting to MSSQL 262Sending SQL to MSSQL 264Retrieving Results of a Query to MSSQL 265Using Prepared Statements with MSSQL 266Using MSSQL without Windows 268Connecting to Firebird 270Sending SQL to Firebird 271Retrieving Results of a Query to Firebird 272Connecting via PDO 273Sending SQL via PDO 275Retrieving Results of a Query via PDO 27610 Using XML 279Parsing XML with SAX 280Parsing XML with XMLReader 282Using DOM to Read XML 284Using DOM to Write XML 285Using XMLWriter to Write XML 287Using SimpleXML 288Using XPath with SimpleXML 289Transforming XML with XSL 290Validating XML 29111 Communicating with Others 295Connecting with HTTP Servers 295Connecting with FTP Servers 298Checking Whether a Server Is Still Reacting 300Creating a Web Service with NuSOAP 304Automatically Generating WSDL with NuSOAP 306Consuming a Web Service with NuSOAP 308Creating a Web Service with the PHP 5 SOAP Extension 309Consuming a Web Service with the PHP 5 SOAP Extension 312Using Ajax 313Exchanging Data with the Server 316TOC, 9780321834638, 10/3/2012
