Franklin

PHP5 and MySQL Bible.

Author/Creator:
Converse, Tim.
Publication:
Hoboken : John Wiley & Sons, Incorporated, 2004.
Format/Description:
Book
1 online resource (1082 pages)
Edition:
1st ed.
Series:
Bible Ser.
Bible Ser. ; v.147
Status/Location:
Loading...

Options
Location Notes Your Loan Policy

Details

Subjects:
PHP (Computer program language).
SQL (Computer program language).
Document markup languages.
Web sites -- Authoring programs.
Form/Genre:
Electronic books.
Summary:
This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engineExplores why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQLOffers an extensive tutorial for developing applications with PHP and MySQLIncludes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functionsThe authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience.
Contents:
Intro
PHP5 and MySQLBible
Preface
Acknowledgments
Contents at a Glance
Contents
Preface
What Is PHP?
Why PHP?
What's New in This Edition?
Whom This Book Is For
This Book Is Not the Manual
How the Book Is Organized
Conventions Used in This Book
What the Icons Mean
The Web Site and Sample Code
Part I: PHP: The Basics
Chapter 1: Why PHP and MySQL?
What Is PHP?
What Is MySQL?
The History of PHP
The History of MySQL
Reasons to Love PHP and MySQL
Summary
Chapter 2: Server-Side Web Scripting
Static HTML
Client-Side Technologies
Server-Side Scripting
What Is Server-Side Scripting Good for?
Summary
Chapter 3: Getting Started with PHP
Hosting versus DIY
Installing PHP
Summary
Chapter 4: Adding PHP to HTML
Your HTML Is Already PHP-Compliant!
Escaping from HTML
Summary
Chapter 5: Syntax and Variables
PHP Is Forgiving
HTML Is Not PHP
PHP's Syntax Is C-Like
Comments
Variables
Types in PHP: Don't Worry, Be Happy
Type Summary
The Simple Types
Output
Summary
Chapter 6: Control and Functions
Boolean Expressions
Branching
Looping
Alternate Control Syntaxes
Terminating Execution
Using Functions
Function Documentation
Defining Your Own Functions
Functions and Variable Scope
Function Scope
Summary
Chapter 7: Passing Information between Pages
HTTP Is Stateless
GET Arguments
A Better Use for GET-Style URLs
POST Arguments
Formatting Form Variables
PHP Superglobal Arrays
Extended Example: An Exercise Calculator
Summary
Chapter 8: Strings
Strings in PHP
String Functions
Extended Example: An Exercise Calculator
Summary
Chapter 9: Arrays and Array Functions
The Uses of Arrays
What Are PHP Arrays?
Creating Arrays
Retrieving Values.
Multidimensional Arrays
Inspecting Arrays
Deleting from Arrays
Iteration
Extended Example: An Exercise Calculator
Summary
Chapter 10: Numbers
Numerical Types
Mathematical Operators
Simple Mathematical Functions
Randomness
Extended Example: An Exercise Calculator
Summary
Chapter 11: Basic PHP Gotchas
Installation-Related Problems
Rendering Problems
Failures to Load Page
Parse Errors
File Permissions
Missing Includes
Unbound Variables
Overwritten Variables
Function Problems
Math Problems
Time-outs
Summary
Part II: PHP and MySQL
Chapter 12: Choosing a Database for PHP
What Is a Database?
Why a Database?
Choosing a Database
Advanced Features to Look For
PHP-Supported Databases
Database Abstraction ( or Not)
Our Focus: MySQL
Summary
Chapter 13: SQL Tutorial
Relational Databases and SQL
SQL Standards
The Workhorses of SQL
Database Design
Privileges and Security
Summary
Chapter 14: MySQL Database Administration
MySQL Licensing
Installing MySQL: Moving to Version 4
MySQL User Administration
PHPMyAdmin
Backups
Replication
Recovery
Summary
Chapter 15: PHP/MySQL Functions
Connecting to MySQL
Making MySQL Queries
Fetching Data Sets
Getting Data about Data
Multiple Connections
Building in Error Checking
Creating MySQL Databases with PHP
MySQL Functions
Summary
Chapter 16: Displaying Queries in Tables
HTML Tables and Database Tables
Complex Mappings
Creating the Sample Tables
Summary
Chapter 17: Building Forms from Queries
HTML Forms
Basic Form Submission to a Database
Self-Submission
Editing Data with an HTML Form
Summary
Chapter 18: PHP/MySQL Efficiency
Connections - Reduce, Reuse, Recycle
Indexing and Table Design.
Making the Database Work for You
Summary
Chapter 19: PHP/MySQL Gotchas
No Connection
Problems with Privileges
Unescaped Quotes
Broken SQL Statements
Too Little Data, Too Much Data
Specific SQL Functions
Debugging and Sanity Checking
Summary
Part III: Advanced Features and Techniques
Chapter 20: Object-Oriented Programming with PHP
What Is Object-Oriented Programming?
Basic PHP Constructs for OOP
Advanced OOP Features
Introspection Functions
Extended Example: HTML Forms
Gotchas and Troubleshooting
OOP Style in PHP
Summary
Chapter 21: Advanced Array Functions
Transformations of Arrays
Stacks and Queues
Translating between Variables and Arrays
Sorting
Printing Functions for Visualizing Arrays
Summary
Chapter 22: String and Regular Expression Functions
Tokenizing and Parsing Functions
Why Regular Expressions?
Perl-Compatible Regular Expressions
Example: A Simple Link-Scraper
Advanced String Functions
Summary
Chapter 23: Filesystem and System Functions
Understanding PHP File Permissions
File Reading and Writing Functions
Filesystem and Directory Functions
Network Functions
Date and Time Functions
Calendar Conversion Functions
Summary
Chapter 24: Sessions, Cookies, and HTTP
What's a Session?
Home-Grown Alternatives
How Sessions Work in PHP
Sample Session Code
Session Functions
Configuration Issues
Cookies
Sending HTTP Headers
Gotchas and Troubleshooting
Summary
Chapter 25: Types and Type Conversions
Type Round-up
Resources
Type Testing
Assignment and Coercion
Summary
Chapter 26: Advanced Use of Functions
Variable Numbers of Arguments
Call-by-Value
Call-by-Reference
Variable Function Names
An Extended Example
Summary
Chapter 27: Mathematics.
Mathematical Constants
Tests on Numbers
Base Conversion
Exponents and Logarithms
Trigonometry
Arbitrary Precision ( BC)
Summary
Chapter 28: PEAR
What Is PEAR?
The PEAR Package System
PHP Foundation Classes ( PFC)
PHP Extension Code Library ( PECL)
The PEAR Coding Style
Summary
Chapter 29: Security
Possible Attacks
Register Globals
File Uploads
Encryption
FYI: Security Web Sites
Summary
Chapter 30: Configuration
Viewing Environment Variables
Understanding PHP Configuration
Improving PHP Performance
Summary
Chapter 31: Exceptions and Error Handling
Error Handling in PHP5
Other Methods of Error Handling
Logging and Debugging
Summary
Chapter 32: Debugging
General Troubleshooting Strategies
A Menagerie of Bugs
Using Web Server Logs
PHP Error Reporting and Logging
Error-Reporting Functions
Visual Debugging Tools
Summary
Chapter 33: Style
The Uses of Style
Readability
Maintainability
Robustness
Efficiency and Conciseness
HTML Mode or PHP Mode?
Separating Code from Design
Summary
Part IV: Connections
Chapter 34: PostgreSQL
Why Choose PostgreSQL?
Why Object-Relational Anyway?
Installing PostgreSQL
Down to Real Work
PHP and PostgreSQL
The Cartoons Database
Summary
Chapter 35: Oracle
When Do You Need Oracle?
Oracle and Web Architecture
Using OCI8 Functions
Project: Point Editor
Project: Batch Editor
Summary
Chapter 36: PEAR Database Functions
The Debatable Virtue of Database Independence
Pear DB Concepts
PEAR DB Functions
Summary
Chapter 37: E-mail
Understanding E-mail
Receiving E-mail with PHP
Sending E-mail with PHP
More Fun with PHP E-mail
E-mail Gotchas
Summary
Chapter 38: PHP and JavaScript
Outputting JavaScript with PHP.
PHP as a Backup for JavaScript
Static Versus Dynamic JavaScript
Summary
Chapter 39: PHP and Java
PHP for Java programmers
Integrating PHP and Java
Summary
Chapter 40: PHP and XML
What Is XML?
Working with XML
Documents and DTDs
SAX versus DOM
DOM
SAX
SimpleXML API
A Sample XML Application
Gotchas and Troubleshooting
Summary
Chapter 41: Web Services
The End of Programming as We Know It
REST, XML-RPC, SOAP, . NET
Current Issues with Web Services
Project: A REST Client
Project: A SOAP Server and Client
Summary
Chapter 42: Graphics
Your Options
HTML Graphics
Creating images using gd
Gotchas and Troubleshooting
Summary
Part V: Case Studies
Chapter 43: Weblogs
Why Weblogs?
The Simplest Weblog
Adding an HTML Editing Tool
Adding Database Connectivity
Changes and Additions
Summary
Chapter 44: User Authentication
Designing a User-Authentication System
Avoiding Common Security Issues
Registration
Login/Logout
User Tools
Administrator Tools
Summary
Chapter 45: A User-Rating System
Initial Design
Collecting Votes
Aggregating Results
Extensions and Alternatives
Summary
Chapter 46: A Trivia Game
Concepts Used in This Chapter
The Game
The Code
General Design Considerations
Summary
Chapter 47: Converting Static HTML Sites
Planning the Big Upgrade
Redesigning the User Interface
Planning a New Database Schema
Dumping Data into a Database
Templating
Performance and Caching
Summary
Chapter 48: Data Visualization with Venn Diagrams
Scaled Venn Diagrams
Outline of the Code
Necessary Trigonometry
Planning the Display
Display
Visualizing a Database
Extensions
Summary
Appendix A: PHP for C Programmers
Similarities
Differences
Guide to the Book.
A Bonus: Just Look at the Code!.
Notes:
Description based on publisher supplied metadata and other sources.
Contributor:
Park, Joyce.
Morgan, Clark.
Other format:
Print version: Converse, Tim PHP5 and MySQL Bible
ISBN:
9780764571824
9780764557460
OCLC:
935228422