Description  Features  Contents  Author  

Description

The definitive best-selling book on combining these two open source tools to create dynamic Web sites - updated for PHP 5 and MySQL 5.

  • A new, updated, and revised edition of the best-selling #1 book on any open source programming topic.
  • New edition updates the material and code to MySQL 5 and PHP 5, and includes new coverage of PHP's object model and validation.
  • Readers have consistently praised the book's clear, practical approach - some have even called it the best technical book they've ever read.
Features
  • Strong coverage of core PHP Web development techniques—Covers storing and retrieving data, using arrays, manipulating strings, writing regular expressions and functions, reusing code, and more.

    • Gives students a solid foundation in the basics of PHP scripting.

  • Thorough introduction to MySQL database development—Covers designing, creating, and working with MySQL Web databases; accessing MySQL databases from the Web with PHP, and more.

    • Helps students work with MySQL databases even if they have no prior database experience.

  • Thorough coverage of related e-commerce site technologies—Covers SSL, shopping carts, payment systems, and more.

    • Helps students master technologies that must be integrated with PHP and MySQL in order to deliver a complete e-commerce solution.

  • Several detailed case studies—Walks students through building user authentication and personalization systems, content management tools, Web-based email services, mailing list managers, Web forums, and more.

    • Gives students outstanding hands-on experience with PHP/MySQL Web development.

  • XML coverage—Includes a full chapter on XML.

    • Prepares students to build applications that generate XML or work with existing XML content.

  • CD-ROM containing all source code, and more—CD-ROM includes source code for all of the books examples and projects, along with PHP 5, MySQL 5, and Apache source code and binaries

    • Gives students all the software, resources, and files they need to build a wide range of Web-based database applications.

  • CD-ROM contains book in PDF format—Includes a complete, fully indexed version of the book on CD-ROM.

    • Enables students to learn from the books content and projects anywhere, even if they dont have access to the physical book.

Contents

I. USING PHP.

 1. PHP Crash Course.

 2. Storing & Retrieving Data.

 3. Using Arrays.

 4. String Manipulation & Regular Expressions.

 5. Reusing Code & Writing Functions.

 6. Object-Oriented PHP.

 7. Exception Handling.

II. USING MYSQL.

 8. Designing Your Web Database.

 9. Creating Your Web Database.

10. Working with Your MySQL Database.

11. Assessing Your MySQL Database from the Web with PHP.

12. Advanced MySQL Administration.

13. Advanced MySQL Programming.

III. E-COMMERCE & SECURITY.

14. Running an E-Commerce Site.

15. E-Commerce Security Issues.

16. Implementing Authentication with PHP & MySQL.

17. Implementing Secure Transactions with PHP & MySQL.

IV. ADVANCED PHP TECHNIQUES.

18. Interacting with the File System & the Server.

19. Using Network & Protocol Functions.

20. Managing the Date & Time.

21. Generating Images.

22. Using Session Control in PHP.

23. Other Useful Features.

V. BUILDING PRACTICAL PHP & MYSQL PROJECTS.

24. Using PHP & MySQL for Large Projects.

25. Debugging.

26. Building User Authentication & Personalization.

27. Building a Shopping Cart.

28. Building a Content Management System.

29. Building a Web-Based Email Service.

30. Building a Mailing List Manager.

31. Building Web Forums.

32. Generating Personalized Documents in Portable Document Format (PDF).

33. Connecting to Web Services with XML & SOAP.

A. Installing PHP & MySQL5.

B. Web Resources.

Author

PHP and MySQL Web Development Third EditionAbout the Authors

Laura Thomson is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. She is also a partner in the award-winning web development firm Tangled Web Design. Laura has previously worked for Telstra and the Boston Consulting Group. She holds a Bachelor of Applied Science (Computer Science) degree and a Bachelor of Engineering (Computer Systems Engineering) degree with honors, and is currently completing her Ph.D. in Adaptive Web Sites. In her spare time, she enjoys sleeping. Laura can be reached via email at laura@tangledweb.com.au.

Luke Welling is a senior web developer at MySQL AB, the company behind the MySQL database. He has previously taught engineering and computer science at RMIT University in Melbourne, Australia and worked as a computer programmer for many years. He holds a Bachelor of Applied Science (Computer Science) degree. In his spare time, he attempts to perfect his insomnia. Luke can be reached via email at luke@tangledweb.com.au.

Both authors have attained the MySQL Core Certification offered by MySQL AB and the Zend Certified PHP Engineer offered by Zend Technologies Ltd.


© Copyright Pearson Education. All rights reserved.