book

PHP and MySQL™ Phrasebook

Name: PHP and MySQL™ Phrasebook
Author: Christian Wenz
ISBN: 9780133040340

by Christian Wenz

October 2012

Intermediate to advanced

360 pages

4h 57m

English

Addison-Wesley Professional

Read now

Unlock full access

Title Page
Copyright Page
Table of Contents
About the Author
We Want to Hear from You!
Reader Services
Introduction
Introduction for the Second Edition
1. Manipulating Strings
Comparing StringsChecking Usernames and PasswordsConverting Strings into HTMLUsing Line BreaksEncrypting StringsChecksumming StringsExtracting SubstringsProtecting Email Addresses Using ASCII CodesScanning Formatted StringsGetting Detailed Information about VariablesSearching in StringsUsing Perl-Compatible Regular ExpressionsFinding Tags with Regular ExpressionsValidating Mandatory InputValidating Email AddressesSearch and Replace
2. Working with Arrays
Accessing All Elements of Numeric ArraysAccessing All Elements of Associative ArraysAccessing All Array Elements in Nested ArraysTurning an Array into VariablesConverting Strings to ArraysConverting Arrays to StringsSorting Arrays AlphabeticallySorting Associative Arrays AlphabeticallySorting Nested ArraysSorting Nested Associative ArraysSorting IP Addresses (as a Human Would)Sorting AnythingSorting with Foreign LanguagesApplying an Effect to All Array ElementsFiltering ArraysGetting Random Elements Out of ArraysMaking Objects Behave Like Arrays
3. Date and Time
Using Text within date()Formatting DateTime ObjectsAutomatically Localizing DatesManually Localizing DatesUsing the Current Date, the U.S./U.K./European WayFormatting a Specific DateValidating a DateCalculating a Relative DateCreating a Sortable Time StampConverting a String into a DateDetermining Sunrise and SunsetUsing Date and Time for BenchmarksUsing Form Fields for Date SelectionCreate Self-Updating Form Fields for Date SelectionCalculating the Difference between Two DatesUsing GMT Date/Time Information

4. Working with Objects (and Related Topics)
Setting Up ClassesUnderstanding InheritanceUsing Abstract Classes and InterfacesPreventing Inheritance and OverwritingUsing AutoloadingCloning ObjectsSerializing and Deserializing ObjectsImplementing SingletonsUsing Traits
5. Interacting with Web Forms
Sending Form Data Back to the Current ScriptReading Out Form DataChecking Whether a Form Has Been SubmittedSaving Form Data into a CookiePrefilling Text Fields and Password FieldsPrefilling Multiline Text FieldsPreselecting Radio ButtonsPreselecting Check BoxesPreselecting Selection ListsPreselecting Multiple Selection ListsProcessing Graphical Submit ButtonsChecking Mandatory FieldsChecking Selection ListsEscaping OutputValidating InputWriting All Form Data into a FileSending All Form Data via EmailGetting Information about File UploadsMoving Uploaded Files to a Safe LocationMonitoring the Progress of a File Upload
6. Remembering Users (Cookies and Sessions)
Understanding CookiesCreating a CookieReading Out CookiesSetting a (Reasonable) Expiry DateSetting a Client-Specific Expiry DateDeleting a CookieMaking Cookies Accessible for Several DomainsChecking Whether the Client Supports CookiesSaving Multiple Data in One CookieSaving the User’s Language PreferenceUnderstanding SessionsWhere to Store the SessionsHow to Maintain the Session StateActivating SessionsReading and Writing SessionsClosing SessionsChanging the Session IDImplementing a Custom Session ManagementCreating a Secured Area with SessionsCreating a Secured Area without Sessions
7. Using Files on the Server File System
Opening and Closing FilesReading from FilesWriting to FilesLocking FilesUsing Relative Paths for File AccessAvoiding Security Traps with File AccessWorking with CSV DataParsing INI FilesRetrieving File InformationCopying, Moving, and Deleting FilesBrowsing the File SystemUsing PHP StreamsUsing Bzip2 ArchivesReturning Files with an HTTP Request
8. Working with MySQL Databases
Connecting to MySQLiSending SQL to MySQLPrepared Statements with MySQLRetrieving Results of a Query to MySQLRetrieving the Last Inserted IDUsing Transactions
9. Working with Other Databases
Connecting to SQLiteSending SQL to SQLiteRetrieving Results of a Query to SQLiteUsing Prepared Statements with SQLiteConnecting to PostgreSQLSending SQL to PostgreSQLUpdating Data in PostgreSQLRetrieving Results of a Query to PostgreSQLConnecting to OracleSending SQL to OracleRetrieving Results of a Query to OracleConnecting to MSSQLSending SQL to MSSQLRetrieving Results of a Query to MSSQLUsing Prepared Statements with MSSQLUsing MSSQL without WindowsConnecting to FirebirdSending SQL to FirebirdRetrieving Results of a Query to FirebirdConnecting via PDOSending SQL via PDORetrieving Results of a Query via PDO
10. Using XML
Parsing XML with SAXParsing XML with XMLReaderUsing DOM to Read XMLUsing DOM to Write XMLUsing XMLWriter to Write XMLUsing SimpleXMLUsing XPath with SimpleXMLTransforming XML with XSLValidating XML
11. Communicating with Others
Connecting with HTTP ServersConnecting with FTP ServersChecking Whether a Server Is Still ReactingCreating a Web Service with NuSOAPAutomatically Generating WSDL with NuSOAPConsuming a Web Service with NuSOAPCreating a Web Service with the PHP 5 SOAP ExtensionConsuming a Web Service with the PHP 5 SOAP ExtensionUsing AjaxExchanging Data with the Server
Index

Content preview from PHP and MySQL™ Phrasebook

9. Working with Other Databases

Apart from MySQL, PHP supports almost all relevant (and some not-so-relevant ones, as well) databases on Earth. This chapter features the basic techniques used with many of those systems, especially connecting to the database, executing SQL statements, and retrieving the return data. As in Chapter 8, “Working with MySQL Databases,” we are using a sample database called phrasebook and a sample schema/table from within it called quotes, with the following four fields:

• id—An integer value that is increased by one for each new entry entered into the database. Depending on the database system, the data type is either called IDENTITY, auto_increment, or something similar.

• quote—The quote, as a VARCHAR(255); this ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

PHP 7: Real World Application Development

Publisher Resources

ISBN: 9780133040340Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

PHP and MySQL™ Phrasebook

by Christian Wenz

9. Working with Other Databases

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.