The programmer's Guide to building robust web applications with PHP and MySQL
This is a comprehensive, practical guide for programmers who want to develop production-quality, database-enabled web applications with PHP and MySQL. Long-time developer Marc Wandschneider systematically addresses the entire process: not only coding, but also upfront application, user interface and database design, PLUS security, testing, and more.
You'll walk through building three applications from start to finish: a calendaring system, a weblog engine, and an e-commerce store. Along the way, you'll master essential strategies for creating robust web database applications and learn how to avoid the common pitfalls that trip up many developers moving to PHP and MySQL.
- Starts with a complete primer on PHP for developers including coverage of code organization, reuse, and object-oriented PHP
- Contains detailed treatments of data access, including transactions, foreign keys, and indexes
- Presents powerful data validation techniques utilizing PHP regular expressions
- Walks through planning web applications, including user interfaces and user management
- Offers systematic guidance on securing web applications from end to end
- Covers a wide range of implementation issues including internationalization, error handling, data validation, debugging, session management, and deployment
- Includes detailed chapters on XML, XML-based web services, and the PEAR framework for reusable PHP components
- Shows how to work with the Oracle and PostgreSQL databases
|Product dimensions:||7.00(w) x 9.10(h) x 1.70(d)|
Table of Contents
I. THE BASICS OF PHP.
1. Getting Started with PHP.
2. The PHP Language.
3. Code Organization and Reuse.
4. Object-Oriented Programming.
5. Working with Arrays.
6. Strings and Characters of the World.
7. Interacting with the Server: Forms.
II. DATABASE BASICS.
8. Introduction to Databases.
9. Designing and Creating Your Database.
10. Using Databases: Storing and Retrieving Data.
11. Using Databases: Advanced Data Access.
12. PHP and Data Access.
III. PLANNING WEB APPLICATIONS.
13. Web Applications and the Internet.
14. Implementing a User Interface.
15. User Management.
16. Securing Your Web Applications: Planning and Code Security.
17. Securing Your Web Applications: Software and Hardware Security.
IV. IMPLEMENTING YOUR WEB APPLICATION.
18. Error Handling and Debugging.
19. Cookies and Sessions.
20. User Authentication.
21. Advanced Output and Output Buffering.
22. Data Validation with Regular Expressions.
23. XML and XHTML.
24. Files and Directories.
25. File Uploading.
26. Working with Dates and Times.
27. XML Web Services and SOAP.
28. Using PEAR.
29. Development and Deployment.
V. SAMPLE PROJECTS AND FURTHER IDEAS.
30. Strategies for Successful Web Applications.
31. An Appointment Manager.
32. A Blogging Engine.
33. An Ecommerce Application.
Appendix A. Installation/Configuration.
Appendix B. Database Function Equivalents.
Appendix C. Recommended Reading.
Most Helpful Customer Reviews
The reason for the book's length is that the author is attempting to cover a lot of ground. There are comprehensive and separate descriptions of PHP and MySQL. Keep in mind that each has multiple books devoted to it. The PHP section has a good emphasis on object oriented coding. This can be vital if you have a large PHP code body, for using OO helps code scale to larger sizes. The MySQL section of the text is also nontrivial. Amongst other things, it describes how to design and create a database. Ideas that are largely independent of MySQL, though they can be, and are, implemented in it, in the text. Of course, the main attraction of the book is in combining PHP and MySQL. Here, the book goes into how to make a multitier architecture, from the client side to the database. Chapter 14 on writing the user interface is a little skimpy. But other chapters on the server side issues have more detail on their subjects. Which includes a chapter on XML. Quite aside from PHP or MySQL, knowing how to use XML can be important to you. The book even finds time to cover Web Services and how you might implement and interact with these, using PHP.