Learning PHP and MySQL

by Davis, Michele E.

• ISBN13: 9780596101107
• ISBN10: 0596101104
• Format: Paperback
• Copyright: 2006-06-01
• Publisher: Oreilly & Associates Inc

Summary

"Learning PHP and MySQL" starts with the very basics of the PHP language including arrays and strings, pattern matching, and a detailed discussion of the variances in different PHP versions. The book then moves on to explain how to work with MySQL, the popular open source database, with information on the SQL data access language, and database fundamentals like tables and statements. When readers are able to grasp both PHP and MySQL concepts, they learn how to put them together to generate dynamic content. In the process, they'll also learn about error handling, security, HTTP authentication, and be able to examine many real world examples of PHP & MySQL applications.

Author Biography

Michele Davis, a career writer since she was eight years old, has owned a technical writing and software training company since 1988. Michele contributed to the "HTML Bible 4.0" (Wiley).

Jon Phillips is a software developer who works with Oracle 9i, Oracle Financials and HRMS. Jon creates the backend of web sites that Michele designs and writes. Jon uses PHP and MySQL for numerous clients that want a database or web site interaction, such as forms. Both Michele and Jon are members of a PHP list serve.

Table of Contents

Preface	ix
Dynamic Content and the Web	1	(13)
PHP and MySQL's Place in Web Development	1	(2)
The Components of a PHP Application	3	(3)
Integrating Many Sources of Information	6	(4)
Requesting Data from a Web Page	10	(3)
Chapter 1 Questions	13	(1)
Installation	14	(19)
Developing Locally	14	(16)
Working Remotely	30	(2)
Chapter 2 Questions	32	(1)
Exploring PHP	33	(22)
PHP and HTML Text	33	(4)
Coding Building Blocks	37	(17)
Chapter 3 Questions	54	(1)
PHP Decision Making	55	(22)
Expressions	55	(2)
Operator Concepts	57	(7)
Conditionals	64	(6)
Looping	70	(6)
Chapter 4 Questions	76	(1)
Functions	77	(22)
Calling Functions	79	(2)
Defining Functions	81	(7)
Object-Oriented Programming	88	(9)
Chapter 5 Questions	97	(2)
Arrays	99	(14)
Array Fundamentals	99	(13)
Chapter 6 Questions	112	(1)
Database Basics	113	(21)
Database Design	114	(9)
Structured Query Language	123	(10)
Chapter 7 Questions	133	(1)
Using MySQL	134	(29)
MySQL Database	134	(3)
Managing the Database	137	(6)
Backing Up and Restoring Data	143	(3)
Advanced SQL	146	(16)
Chapter 8 Questions	162	(1)
Getting PHP to Talk to MySQL	163	(18)
The Process	163	(1)
Querying the Database with PHP Functions	164	(10)
Using Pear	174	(6)
Chapter 9 Questions	180	(1)
Working with Forms	181	(24)
Building a Form	181	(18)
Templates	199	(5)
Chapter 10 Questions	204	(1)
Practical PHP	205	(28)
String Functions	205	(10)
Date and Time Functions	215	(5)
File Manipulation	220	(10)
Calling System Calls	230	(2)
Chapter 11 Questions	232	(1)
Modifying MySQL Objects and PHP Data	233	(19)
Changing Database Objects from PHP	233	(2)
Manipulating Table Data	235	(1)
Displaying Results with Embedded Links	236	(3)
Presenting a Form to Add and Process in One File	239	(5)
Updating Data	244	(1)
Deleting Data	245	(5)
Performing a Subquery	250	(1)
Chapter 12 Questions	251	(1)
Cookies, Sessions, and Access Control	252	(21)
Cookies	252	(3)
PHP and HTTP Authentication	255	(5)
Sessions	260	(7)
Using Auth_HTTP to Authenticate	267	(5)
Chapter 13 Questions	272	(1)
Security	273	(17)
Session Security	282	(7)
Chapter 14 Questions	289	(1)
Validation and Error Handling	290	(12)
Validating User Input with JavaScript	290	(4)
Pattern Matching	294	(4)
Redisplaying a Form After PHP Validation Fails	298	(2)
Chapter 15 Questions	300	(2)
Sample Applications	302	(26)
Building a Blog	302	(25)
Chapter 16 Questions	327	(1)
Finishing Your Journey	328	(9)
Finding Help on the Web	328	(5)
Web Sites	333	(1)
Zend	334	(1)
Lampshade	335	(1)
Chapter 17 Questions	335	(2)
Appendix: Answers to Chapter Questions	337	(14)
Index	351