Beginning PHP and MySQL

by Gilmore, W. Jason

• ISBN13: 9781590598627
• ISBN10: 1590598628
• Edition: 3rd
• Format: Paperback
• Copyright: 2008-03-24
• Publisher: Apress

Summary

Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQL's most significant release to date, readers learn how to take advantage of the latest features of both technologies to build powerful, manageable, and stable web applications. Essentially three books in one, readers not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's 7 years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide.

Table of Contents

Introducing PHP	p. 1
Configuring Your Environment	p. 11
PHP Basics	p. 55
Functions	p. 113
Arrays	p. 127
Object-Oriented PHP	p. 163
Advanced OOP Features	p. 193
Error and Exception Handling	p. 213
Strings and Regular Expressions	p. 231
Working with the File and Operating System	p. 277
PEAR	p. 309
Date and Time	p. 323
Forms	p. 349
Authenticating Your Users	p. 365
Handling File Uploads	p. 387
Networking	p. 401
PHP and LDAP	p. 425
Session Handlers	p. 445
Templating with Smarty	p. 471
Web Services	p. 503
Secure PHP Programming	p. 539
SQLite	p. 567
Building Web Sites for the World	p. 591
MVC and the Zend Framework	p. 601
Introducing MySQL	p. 621
Installing and Configuring MySQL	p. 635
The Many MySQL Clients	p. 663
MySQL Storage Engines and Datatypes	p. 693
Securing MySQL	p. 731
Using PHP with MySQL	p. 767
Introducing PDO	p. 793
Stored Routines	p. 819
MySQL Triggers	p. 849
MySQL Views	p. 863
Practical Database Queries	p. 879
Indexes and Searching	p. 907
Transactions	p. 925
Importing and Exporting Data	p. 939
Index	p. 957
Table of Contents provided by Blackwell. All Rights Reserved.