Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by W. Jason Gilmore
Beginning PHP and MySQL: From Novice to Professional, Third Edition
Title Page
Dedication
Contents at a Glance
Contents
About the Author
Acknowledgments
Introduction
Download the Code
Contact Me!
CHAPTER 1: Introducing PHP
History
General Language Features
Summary
CHAPTER 2: Configuring Your Environment
Installation Prerequisites
Installing Apache and PHP on Linux
Installing Apache and PHP on Windows
Installing IIS and PHP on Windows
Testing Your Installation
Configuring PHP
Run-Time Configuration
Choosing a Code Editor
Choosing a Web Hosting Provider
Summary
CHAPTER 3: PHP Basics
Embedding PHP Code in Your Web Pages
Commenting Your Code
Outputting Data to the Browser
PHP's Supported Datatypes
Identifiers
Variables
Constants
Expressions
String Interpolation
Control Structures
Summary
CHAPTER 4: Functions
Invoking a Function
Creating a Function
Function Libraries
Summary
CHAPTER 5: Arrays
What Is an Array?
Creating an Array
Adding and Removing Array Elements
Locating Array Elements
Traversing Arrays
Determining Array Size and Uniqueness
Sorting Arrays
Merging, Slicing, Splicing, and Dissecting Arrays
Other Useful Array Functions
Summary
CHAPTER 6: Object-Oriented PHP
The Benefits of OOP
Key OOP Concepts
Constructors and Destructors
Static Class Members
The instanceof Keyword
Helper Functions
Autoloading Objects
Summary
CHAPTER 7: Advanced OOP Features
Advanced OOP Features Not Supported by PHP
Object Cloning
Inheritance
Interfaces
Abstract Classes
Introducing Namespaces
Summary
CHAPTER 8: Error and Exception Handling
Configuration Directives
Error Logging
Exception Handling
Summary
CHAPTER 9: Strings and Regular Expressions
Regular Expressions
Other String-Specific Functions
Alternatives for Regular Expression Functions
Taking Advantage of PEAR: Validate_US
Summary
CHAPTER 10: Working with the File and Operating System
Learning About Files and Directories
Working with Files
Executing Shell Commands
System-Level Program Execution
Summary
CHAPTER 11: PEAR
Popular PEAR Packages
The Power of PEAR: Converting Numeral Formats
Installing and Updating PEAR
Using the PEAR Package Manager
Summary
CHAPTER 12: Date and Time
The Unix Timestamp
PHP's Date and Time Library
Date Fu
Date and Time Enhancements for PHP 5.1+ Users
Summary
CHAPTER 13: Forms
PHP and Web Forms
Taking Advantage of PEAR: HTML_QuickForm
Summary
CHAPTER 14: Authenticating Your Users
HTTP Authentication Concepts
PHP Authentication
PHP Authentication Methodologies
User Login Administration
Summary
CHAPTER 15: Handling File Uploads
Uploading Files via HTTP
Uploading Files with PHP
Taking Advantage of PEAR: HTTP_Upload
Summary
CHAPTER 16: Networking
DNS, Services, and Servers
Mail
Common Networking Tasks
Summary
CHAPTER 17: PHP and LDAP
Using LDAP from PHP
Summary
CHAPTER 18: Session Handlers
What Is Session Handling?
Configuration Directives
Working with Sessions
Practical Session-Handling Examples
Creating Custom Session Handlers
Summary
CHAPTER 19: Templating with Smarty
What's a Templating Engine?
Introducing Smarty
Installing Smarty
Using Smarty
Smarty's Presentational Logic
Creating Configuration Files
Using CSS in Conjunction with Smarty
Caching
Summary
CHAPTER 20: Web Services
Why Web Services?
Really Simple Syndication
SimpleXML
SOAP
Summary
CHAPTER 21: Secure PHP Programming
Configuring PHP Securely
Hiding Configuration Details
Hiding Sensitive Data
Sanitizing User Data
Data Encryption
Summary
CHAPTER 22: SQLite
Introduction to SQLite
PHP's SQLite Library
Summary
CHAPTER 23: Building Web Sites for the World
Translating Web Sites with Gettext
Localizing Dates, Numbers, and Times
Summary
CHAPTER 24: MVC and the Zend Framework
Introducing MVC
PHP's Framework Solutions
Introducing the Zend Framework
Summary
CHAPTER 25: Introducing MySQL
What Makes MySQL So Popular?
The Evolution of MySQL
Prominent MySQL Users
Summary
CHAPTER 26: Installing and Configuring MySQL
Downloading MySQL
Installing MySQL
Setting the MySQL Administrator Password
Starting and Stopping MySQL
Configuring and Optimizing MySQL
Configuring PHP to Work with MySQL
Summary
CHAPTER 27: The Many MySQL Clients
Introducing the Command-Line Clients
MySQL's GUI Client Programs
phpMyAdmin
Summary
CHAPTER 28: MySQL Storage Engines and Datatypes
Storage Engines
Datatypes and Attributes
Working with Databases and Tables
Summary
CHAPTER 29: Securing MySQL
What You Should Do First
Securing the mysqld Daemon
The MySQL Access Privilege System
User and Privilege Management
Limiting User Resources
Secure MySQL Connections
Summary
CHAPTER 30: Using PHP with MySQL
Handling Installation Prerequisites
Using the mysqli Extension
Interacting with the Database
Executing Database Transactions
Summary
CHAPTER 31: Introducing PDO
Another Database Abstraction Layer?
Using PDO
Summary
CHAPTER 33: MySQL Triggers
Introducing Triggers
MySQL's Trigger Support
Integrating Triggers into Web Applications
Summary
CHAPTER 34: MySQL Views
Introducing Views
MySQL's View Support
Incorporating Views into Web Applications
Summary
CHAPTER 35: Practical Database Queries
Sample Data
Creating Tabular Output with PEAR
Sorting Output
Creating Paged Output
Listing Page Numbers
Querying Multiple Tables with Subqueries
Iterating Result Sets with Cursors
Summary
CHAPTER 36: Indexes and Searching
Database Indexing
Forms-Based Searches
Summary
CHAPTER 37: Transactions
What's a Transaction?
MySQL's Transactional Capabilities
A Sample Project
Building Transactional Applications with PHP
Summary
CHAPTER 38: Importing and Exporting Data
Sample Table
Using Data Delimitation
Importing Data
Exporting Data
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset