Learning PHP and MySQL: Step-By-Step Guide to Creating Dynamic, Database-Driven Web Sites

Learning PHP and MySQL: Step-By-Step Guide to Creating Dynamic, Database-Driven Web Sites

Paperback(Second Edition)

$25.35 $29.99 Save 15% Current price is $25.35, Original price is $29.99. You Save 15%.

Product Details

ISBN-13: 9780596514013
Publisher: O'Reilly Media, Incorporated
Publication date: 08/15/2007
Edition description: Second Edition
Pages: 432
Product dimensions: 7.08(w) x 9.14(h) x 1.13(d)

About the Author

Michele E. Davis has co-authored and authored over 11 books and has been a career writer since she sold her first poem to CRICKET magazine in second grade. She has an MFA in Writing from Hamline University and is always trying to improve her writing technique. Someday it will be perfect.

Jon A. Phillips is a software engineer who loves Open Source technology. He's been working with web development and databases for over 12 years and is always exploring new technology. Additionally, he co-authored a Dreamweaver for Dummies book that came out July 2006.

Table of Contents

Preface;
Audience;
Assumptions This Book Makes;
Organization of This Book;
Supporting Books;
Conventions Used in This Book;
Using Code Examples;
How to Contact Us;
Safari® Books Online;
Acknowledgments;
Chapter 1: Dynamic Content and the Web;
1.1 HTTP and the Internet;
1.2 PHP and MySQL's Place in Web Development;
1.3 The Components of a PHP Application;
1.4 Integrating Many Sources of Information;
1.5 Requesting Data from a Web Page;
1.6 Questions;
Chapter 2: Installation;
2.1 Developing Locally;
2.2 Working Remotely;
2.3 Questions;
Chapter 3: Exploring PHP;
3.1 PHP and HTML Text;
3.2 Coding Building Blocks;
3.3 Questions;
Chapter 4: PHP Decision-Making;
4.1 Expressions;
4.2 Operator Concepts;
4.3 Conditionals;
4.4 Looping;
4.5 Questions;
Chapter 5: Functions;
5.1 Calling Functions;
5.2 Defining Functions;
5.3 Object-Oriented Programming;
5.4 Questions;
Chapter 6: Arrays;
6.1 Array Fundamentals;
6.2 Questions;
Chapter 7: Working with MySQL;
7.1 MySQL Database;
7.2 Managing the Database;
7.3 Using phpMyAdmin;
7.4 Database Concepts;
7.5 Structured Query Language;
7.6 Questions;
Chapter 8: Database Best Practices;
8.1 Database Design;
8.2 Backing Up and Restoring Data;
8.3 Advanced SQL;
8.4 Questions;
Chapter 9: Getting PHP to Talk to MySQL;
9.1 The Process;
9.2 Querying the Database with PHP Functions;
9.3 Using PEAR;
9.4 Questions;
Chapter 10: Working with Forms;
10.1 Building a Form;
10.2 Templates;
10.3 Questions;
Chapter 11: Practical PHP;
11.1 String Functions;
11.2 Date and Time Functions;
11.3 File Manipulation;
11.4 Calling System Calls;
11.5 Questions;
Chapter 12: XHTML;
12.1 Why XHTML?;
12.2 XHTML and XML Namespaces;
12.3 XHTML Versions;
12.4 Generating XHTML with PHP;
12.5 Questions;
Chapter 13: Modifying MySQL Objects and PHP Data;
13.1 Changing Database Objects from PHP;
13.2 Manipulating Table Data;
13.3 Displaying Results with Embedded Links;
13.4 Presenting a Form to Add and Process in One File;
13.5 Updating Data;
13.6 Deleting Data;
13.7 Performing a Subquery;
13.8 Questions;
Chapter 14: Cookies, Sessions, and Access Control;
14.1 Cookies;
14.2 PHP and HTTP Authentication;
14.3 Sessions;
14.4 Using Auth_HTTP to Authenticate;
14.5 Questions;
Chapter 15: Security;
15.1 ;
15.2 Session Security;
15.3 Questions;
Chapter 16: Validation and Error Handling;
16.1 Validating User Input with JavaScript;
16.2 Pattern Matching;
16.3 Redisplaying a Form After PHP Validation Fails;
16.4 Questions;
Chapter 17: Sample Application;
17.1 Configuration File;
17.2 Page Framework;
17.3 Database;
17.4 Displaying a Postings Summary;
17.5 Displaying a Posting and Its Comments;
17.6 Adding and Changing Posts;
17.7 Adding and Changing Comments;
17.8 Questions;
Chapter 18: Finishing Your Journey;
18.1 PHP Coding Standards;
18.2 PEAR;
18.3 Frameworks;
18.4 Ajax;
18.5 Wikis;
18.6 Finding Help on the Web;
18.7 Questions;
Solutions to Chapter Questions;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
;
Colophon;

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Learning PHP and MySQL: Step-By-Step Guide to Creating Dynamic, Database-Driven Web Sites 2.5 out of 5 based on 0 ratings. 2 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
sample won't load in nook for PC