PHP5 and MySQL Bible / Tim Converse and Joyce Parks, with Clark Morgan.

By:

Converse, Tim, 1961-

Contributor(s):

Material type: Text

TextPublication details: Indianapolis, IN : Wiley, 2004.Description: xxxvi, 1042 p. : ill. ; 24cmISBN:

0764557467 (pbk.)
9780764557460 (pbk.)

Subject(s):

DDC classification:

005.133 CON

Holdings
Item type	Current library	Call number	Copy number	Status	Date due	Barcode
Standard Loan	Moylish Library Main Collection	005.133 CON (Browse shelf(Opens below))	1	Available		39002100346460

Enhanced descriptions from Syndetics:

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 engine Explores why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL Offers an extensive tutorial for developing applications with PHP and MySQL Includes 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 functions The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience

Includes index.

Table of contents provided by Syndetics

Preface (p. ix)
Acknowledgments (p. xv)
Part I PHP: The Basics (p. 1)
Chapter 1 Why PHP and MySQL? (p. 3)
What Is PHP? (p. 3)
What Is MySQL? (p. 4)
The History of PHP (p. 4)
The History of MySQL (p. 5)
Reasons to Love PHP and MySQL (p. 6)
Summary (p. 17)
Chapter 2 Server-Side Web Scripting (p. 19)
Static HTML (p. 19)
Client-Side Technologies (p. 22)
Server-Side Scripting (p. 26)
What Is Server-Side Scripting Good for? (p. 32)
Summary (p. 33)
Chapter 3 Getting Started with PHP (p. 35)
Hosting versus DIY (p. 35)
Installing PHP (p. 39)
Summary (p. 50)
Chapter 4 Adding PHP to HTML (p. 53)
Your HTML Is Already PHP-Compliant! (p. 53)
Escaping from HTML (p. 53)
Summary (p. 59)
Chapter 5 Syntax and Variables (p. 61)
PHP Is Forgiving (p. 61)
HTML Is Not PHP (p. 61)
PHP's Syntax Is C-Like (p. 62)
Comments (p. 66)
Variables (p. 67)
Types in PHP: Don't Worry, Be Happy (p. 71)
Type Summary (p. 72)
The Simple Types (p. 72)
Output (p. 80)
Summary (p. 82)
Chapter 6 Control and Functions (p. 83)
Boolean Expressions (p. 84)
Branching (p. 88)
Looping (p. 94)
Alternate Control Syntaxes (p. 101)
Terminating Execution (p. 102)
Using Functions (p. 104)
Function Documentation (p. 105)
Defining Your Own Functions (p. 107)
Functions and Variable Scope (p. 110)
Function Scope (p. 115)
Summary (p. 118)
Chapter 7 Passing Information between Pages (p. 119)
HTTP Is Stateless (p. 119)
GET Arguments (p. 120)
A Better Use for GET-Style URLs (p. 122)
POST Arguments (p. 124)
Formatting Form Variables (p. 125)
PHP Superglobal Arrays (p. 132)
Extended Example: An Exercise Calculator (p. 134)
Summary (p. 136)
Chapter 8 Strings (p. 137)
Strings in PHP (p. 137)
String Functions (p. 140)
Extended Example: An Exercise Calculator (p. 151)
Summary (p. 156)
Chapter 9 Arrays and Array Functions (p. 157)
The Uses of Arrays (p. 157)
What Are PHP Arrays? (p. 158)
Creating Arrays (p. 160)
Retrieving Values (p. 162)
Multidimensional Arrays (p. 163)
Inspecting Arrays (p. 164)
Deleting from Arrays (p. 165)
Iteration (p. 165)
Extended Example: An Exercise Calculator (p. 175)
Summary (p. 189)
Chapter 10 Numbers (p. 191)
Numerical Types (p. 191)
Mathematical Operators (p. 192)
Simple Mathematical Functions (p. 196)
Randomness (p. 196)
Extended Example: An Exercise Calculator (p. 200)
Summary (p. 206)
Chapter 11 Basic PHP Gotchas (p. 209)
Installation-Related Problems (p. 209)
Rendering Problems (p. 210)
Failures to Load Page (p. 215)
Parse Errors (p. 216)
File Permissions (p. 219)
Missing Includes (p. 220)
Unbound Variables (p. 221)
Overwritten Variables (p. 223)
Function Problems (p. 224)
Math Problems (p. 225)
Time-outs (p. 227)
Summary (p. 227)
Part II PHP and MySQL (p. 231)
Chapter 12 Choosing a Database for PHP (p. 233)
What Is a Database? (p. 233)
Why a Database? (p. 233)
Choosing a Database (p. 236)
Advanced Features to Look For (p. 238)
PHP-Supported Databases (p. 241)
Database Abstraction (or Not) (p. 242)
Our Focus: MySQL (p. 243)
Summary (p. 244)
Chapter 13 SQL Tutorial (p. 245)
Relational Databases and SQL (p. 245)
SQL Standards (p. 246)
The Workhorses of SQL (p. 246)
Database Design (p. 252)
Privileges and Security (p. 255)
Summary (p. 258)
Chapter 14 MySQL Database Administration (p. 259)
MySQL Licensing (p. 259)
Installing MySQL: Moving to Version 4 (p. 260)
MySQL User Administration (p. 265)
PHPMyAdmin (p. 269)
Backups (p. 272)
Replication (p. 274)
Recovery (p. 276)
Summary (p. 278)
Chapter 15 PHP/MySQL Functions (p. 279)
Connecting to MySQL (p. 279)
Making MySQL Queries (p. 281)
Fetching Data Sets (p. 282)
Getting Data about Data (p. 284)
Multiple Connections (p. 285)
Building in Error Checking (p. 287)
Creating MySQL Databases with PHP (p. 288)
MySQL Functions (p. 291)
Summary (p. 293)
Chapter 16 Displaying Queries in Tables (p. 295)
HTML Tables and Database Tables (p. 295)
Complex Mappings (p. 302)
Creating the Sample Tables (p. 307)
Summary (p. 309)
Chapter 17 Building Forms from Queries (p. 311)
HTML Forms (p. 311)
Basic Form Submission to a Database (p. 312)
Self-Submission (p. 314)
Editing Data with an HTML Form (p. 322)
Summary (p. 335)
Chapter 18 PHP/MySQL Efficiency (p. 337)
Connections--Reduce, Reuse, Recycle (p. 337)
Indexing and Table Design (p. 340)
Making the Database Work for You (p. 345)
Summary (p. 350)
Chapter 19 PHP/MySQL Gotchas (p. 351)
No Connection (p. 351)
Problems with Privileges (p. 353)
Unescaped Quotes (p. 354)
Broken SQL Statements (p. 356)
Too Little Data, Too Much Data (p. 359)
Specific SQL Functions (p. 360)
Debugging and Sanity Checking (p. 361)
Summary (p. 362)
Part III Advanced Features and Techniques (p. 363)
Chapter 20 Object-Oriented Programming with PHP (p. 365)
What Is Object-Oriented Programming? (p. 365)
Basic PHP Constructs for OOP (p. 371)
Advanced OOP Features (p. 378)
Introspection Functions (p. 387)
Extended Example: HTML Forms (p. 398)
Gotchas and Troubleshooting (p. 404)
OOP Style in PHP (p. 405)
Summary (p. 407)
Chapter 21 Advanced Array Functions (p. 409)
Transformations of Arrays (p. 409)
Stacks and Queues (p. 415)
Translating between Variables and Arrays (p. 416)
Sorting (p. 417)
Printing Functions for Visualizing Arrays (p. 418)
Summary (p. 419)
Chapter 22 String and Regular Expression Functions (p. 421)
Tokenizing and Parsing Functions (p. 421)
Why Regular Expressions? (p. 424)
Perl-Compatible Regular Expressions (p. 427)
Example: A Simple Link-Scraper (p. 430)
Advanced String Functions (p. 434)
Summary (p. 438)
Chapter 23 Filesystem and System Functions (p. 439)
Understanding PHP File Permissions (p. 439)
File Reading and Writing Functions (p. 440)
Filesystem and Directory Functions (p. 447)
Network Functions (p. 450)
Date and Time Functions (p. 451)
Calendar Conversion Functions (p. 453)
Summary (p. 454)
Chapter 24 Sessions, Cookies, and HTTP (p. 455)
What's a Session? (p. 455)
Home-Grown Alternatives (p. 456)
How Sessions Work in PHP (p. 458)
Sample Session Code (p. 462)
Session Functions (p. 465)
Configuration Issues (p. 468)
Cookies (p. 469)
Sending HTTP Headers (p. 475)
Gotchas and Troubleshooting (p. 478)
Summary (p. 478)
Chapter 25 Types and Type Conversions (p. 479)
Type Round-up (p. 479)
Resources (p. 480)
Type Testing (p. 481)
Assignment and Coercion (p. 481)
Summary (p. 487)
Chapter 26 Advanced Use of Functions (p. 489)
Variable Numbers of Arguments (p. 489)
Call-by-Value (p. 493)
Call-by-Reference (p. 493)
Variable Function Names (p. 495)
An Extended Example (p. 495)
Summary (p. 499)
Chapter 27 Mathematics (p. 501)
Mathematical Constants (p. 501)
Tests on Numbers (p. 502)
Base Conversion (p. 503)
Exponents and Logarithms (p. 506)
Trigonometry (p. 507)
Arbitrary Precision (BC) (p. 511)
Summary (p. 515)
Chapter 28 PEAR (p. 517)
What Is PEAR? (p. 517)
The PEAR Package System (p. 518)
PHP Foundation Classes (PFC) (p. 525)
PHP Extension Code Library (PECL) (p. 525)
The PEAR Coding Style (p. 525)
Summary (p. 528)
Chapter 29 Security (p. 531)
Possible Attacks (p. 532)
Register Globals (p. 540)
File Uploads (p. 542)
Encryption (p. 545)
FYI: Security Web Sites (p. 552)
Summary (p. 552)
Chapter 30 Configuration (p. 555)
Viewing Environment Variables (p. 555)
Understanding PHP Configuration (p. 555)
Improving PHP Performance (p. 566)
Summary (p. 568)
Chapter 31 Exceptions and Error Handling (p. 569)
Error Handling in PHP5 (p. 569)
Other Methods of Error Handling (p. 576)
Logging and Debugging (p. 580)
Summary (p. 581)
Chapter 32 Debugging (p. 583)
General Troubleshooting Strategies (p. 583)
A Menagerie of Bugs (p. 584)
Using Web Server Logs (p. 585)
PHP Error Reporting and Logging (p. 587)
Error-Reporting Functions (p. 589)
Visual Debugging Tools (p. 593)
Summary (p. 596)
Chapter 33 Style (p. 599)
The Uses of Style (p. 599)
Readability (p. 600)
Maintainability (p. 605)
Robustness (p. 607)
Efficiency and Conciseness (p. 608)
HTML Mode or PHP Mode? (p. 613)
Separating Code from Design (p. 618)
Summary (p. 620)
Part IV Connections (p. 621)
Chapter 34 PostgreSQL (p. 623)
Why Choose PostgreSQL? (p. 623)
Why Object-Relational Anyway? (p. 624)
Installing PostgreSQL (p. 624)
Down to Real Work (p. 627)
PHP and PostgreSQL (p. 629)
The Cartoons Database (p. 630)
Summary (p. 637)
Chapter 35 Oracle (p. 639)
When Do You Need Oracle? (p. 639)
Oracle and Web Architecture (p. 641)
Using OCI8 Functions (p. 643)
Project: Point Editor (p. 647)
Project: Batch Editor (p. 657)
Summary (p. 667)
Chapter 36 PEAR Database Functions (p. 669)
The Debatable Virtue of Database Independence (p. 669)
Pear DB Concepts (p. 673)
PEAR DB Functions (p. 678)
Summary (p. 679)
Chapter 37 E-mail (p. 681)
Understanding E-mail (p. 681)
Receiving E-mail with PHP (p. 686)
Sending E-mail with PHP (p. 687)
More Fun with PHP E-mail (p. 690)
E-mail Gotchas (p. 701)
Summary (p. 701)
Chapter 38 PHP and JavaScript (p. 703)
Outputting JavaScript with PHP (p. 703)
PHP as a Backup for JavaScript (p. 705)
Static Versus Dynamic JavaScript (p. 707)
Summary (p. 717)
Chapter 39 PHP and Java (p. 719)
PHP for Java programmers (p. 719)
Integrating PHP and Java (p. 723)
Summary (p. 729)
Chapter 40 PHP and XML (p. 731)
What Is XML? (p. 731)
Working with XML (p. 734)
Documents and DTDs (p. 735)
SAX versus DOM (p. 739)
DOM (p. 740)
SAX (p. 743)
SimpleXML API (p. 747)
A Sample XML Application (p. 748)
Gotchas and Troubleshooting (p. 755)
Summary (p. 756)
Chapter 41 Web Services (p. 757)
The End of Programming as We Know It (p. 757)
REST, XML-PRC, SOAP, .NET (p. 760)
Current Issues with Web Services (p. 763)
Project: A REST Client (p. 765)
Project: A SOAP Server and Client (p. 770)
Summary (p. 774)
Chapter 42 Graphics (p. 775)
Your Options (p. 775)
HTML Graphics (p. 775)
Creating images using gd (p. 780)
Gotchas and Troubleshooting (p. 795)
Summary (p. 797)
Part V Case Studies (p. 799)
Chapter 43 Weblogs (p. 801)
Why Weblogs? (p. 801)
The Simplest Weblog (p. 801)
Adding an HTML Editing Tool (p. 808)
Adding Database Connectivity (p. 809)
Changes and Additions (p. 817)
Summary (p. 817)
Chapter 44 User Authentication (p. 819)
Designing a User-Authentication System (p. 819)
Avoiding Common Security Issues (p. 820)
Registration (p. 823)
Login/Logout (p. 831)
User Tools (p. 836)
Administrator Tools (p. 851)
Summary (p. 855)
Chapter 45 A User-Rating System (p. 857)
Initial Design (p. 857)
Collecting Votes (p. 859)
Aggregating Results (p. 867)
Extensions and Alternatives (p. 869)
Summary (p. 870)
Chapter 46 A Trivia Game (p. 871)
Concepts Used in This Chapter (p. 871)
The Game (p. 872)
The Code (p. 875)
General Design Considerations (p. 910)
Summary (p. 911)
Chapter 47 Converting Static HTML Sites (p. 913)
Planning the Big Upgrade (p. 913)
Redesigning the User Interface (p. 916)
Planning a New Database Schema (p. 918)
Dumping Data into a Database (p. 922)
Templating (p. 932)
Performance and Caching (p. 941)
Summary (p. 943)
Chapter 48 Data Visualization with Venn Diagrams (p. 945)
Scaled Venn Diagrams (p. 945)
Outline of the Code (p. 946)
Necessary Trigonometry (p. 947)
Planning the Display (p. 950)
Display (p. 957)
Visualizing a Database (p. 958)
Extensions (p. 965)
Summary (p. 965)
Appendix A PHP for C Programmers (p. 967)
Appendix B PHP for Perl Hackers (p. 973)
Appendix C PHP for HTML Coders (p. 979)
Appendix D PHP Resources (p. 987)
Index (p. 997)

Author notes provided by Syndetics

Tim Converse has written software to recommend neckties, answer questions about space stations, pick value stocks, and make simulated breakfast. He has an M.S. in Computer Science from the University of Chicago, where he taught several programming classes. He is now an engineering manager in the Web search group at Yahoo!.

Joyce Park has an M.A. in history from the University of Chicago, and has worked for several Silicon Valley startups including Epinions, KnowNow, and Friendster. She is a co-lead of the Mod-pubsub Open Source project.

Clark Morgan is a Web application and educational software developer with more than five years? experience writing PHP. He works primarily with medical clients and related businesses. Originally from Boston, he now lives and works in Jacksonville, Florida, with his wife and two children. Clark spends entirely too much of his free time reading other people's computer books.