1. Home
  2. Programming
  3. PHP & MySQL. Building web database applications

Appendix F. Managing Sessions in theDatabase Tier

Appendix F. Managing Sessions in theDatabase Tier

In Chapter 10, we discussed the development of session-based applications using the PHP session management features. In this appendix, we briefly explain how to create your own, alternative session storage functions that store session variables in a database. Specifically, this appendix covers:

  • Why you might want to replace the default PHP session storage layer with customized functions using the database tier

  • How to write user-defined PHP session storage handlers

  • How to create and install a fully functional set of PHP handlers that use a table in a MySQL database to store session variables



    		Chapter 1. Database Applications and the Web
    		Chapter 2. The PHP Scripting Language
    		Chapter 3. Arrays, Strings, and Advanced Data Manipulation in PHP
    		Chapter 4. Introduction to Object-Oriented Programming with PHP 5
    		Chapter 5. SQL and MySQL
    		Chapter 6. Querying Web Databases
    		Chapter 7. PEAR
    		Chapter 8. Writing to Web Databases
    		Chapter 9. Validation with PHP and JavaScript
    		Chapter 10. Sessions
    		Chapter 11. Authentication and Security
    		Chapter 12. Errors, Debugging, and Deployment
    		Chapter 13. Reporting
    		Chapter 14. Advanced Features of Object-Oriented Programming in PHP 5
    		Chapter 15. Advanced SQL
    		Chapter 16. Hugh and Dave's Online Wines:A Case Study
    		Chapter 17. Managing Customers
    		Chapter 18. The Shopping Cart
    		Chapter 19. Ordering and Shipping at the Online Winestore
    		Chapter 20. Searching and Authentication in the Online Winestore
    		Appendix A. Linux Installation Guide
    		Appendix B. Microsoft Windows Installation Guide
    		Appendix C. Mac OS X Installation Guide
    		Appendix D. Web Protocols
    		Appendix E. Modeling and Designing Relational Databases
    		Appendix F. Managing Sessions in theDatabase Tier
    		F.1 Using a Database to Keep State
    		F.2 PHP Session Management
    		F.3 MySQL Session Store
    		Appendix G. Resources
    		Appendix H. The Improved MySQL Library