Storing database connection in a session variable [duplicate]

by

You can’t store database connections or result sets in the session, since those are resources, and:

Some types of data can not be serialized thus stored in sessions. It includes resource variables or objects with circular references (i.e. objects which passes a reference to itself to another object).

http://php.net/manual/en/intro.session.php

You can extract a result set into a normal array and store that in the session like any other variable. That would be a fairly typical use case for sessions anyway. Just be careful not to store too much data in the session, as that can become more taxing than fetching it from the database.

More Related Contents:

  1. Gather column name of a table from database [closed]
  2. inserting image in database using php [closed]
  3. Is it ” RTSi6+yxLwIW7KsnoehVDA== ” md5? or How to get original string? [closed]
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. How to convert the json image url string into Bitmap image to display images in android application
  6. How to secure database passwords in PHP?
  7. How to use multiple databases in Laravel
  8. PDO get the last ID inserted
  9. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  10. How can I store and retrieve images from a MySQL database using PHP?
  11. Importing CSV data using PHP/MySQL
  12. Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL
  13. How to store file name in database, with other info while uploading image to server using PHP?
  14. PHP session side-effect warning with global variables as a source of data
  15. Mechanisms for tracking DB schema changes [closed]
  16. Sharing SESSION Variables Between Multiple Subdomains
  17. Generating a single Entity from existing database using symfony2 and doctrine
  18. How to store an array into mysql?
  19. PHP + SQL Server – How to set charset for connection?
  20. How to execute raw queries with Laravel 5.1?
  21. Laravel – Database, Table and Column Naming Conventions?
  22. How can I refresh a page when a database is updated?
  23. Saving images in database mysql
  24. PHP – Secure member-only pages with a login system
  25. Advantages / Disadvantages of pconnect option in CodeIgniter
  26. Storing arrays in the database
  27. laravel 4 custom named password column
  28. mysql injection damages?
  29. PHP session seemingly not working
  30. CakePHP switch database (using same datasource) on the fly?

Leave a Comment