Can’t pass mysqli connection in session in php

by

Yes, it is explicitly impossible.

See PHP Documentation here mentioning in a highlighted Warning: “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).”

MySQL connections are one such kind of resource.

You have to reconnect on each page run.

This is not as bad as it sounds if you can rely on connection pooling via mysql_pconnect(), but first see more background info on mysql_pconnect() in this article.

More Related Contents:

  1. How can I get an unknown username given an ID?
  2. PHP create new array by value
  3. Turning a SQL row into an array
  4. How to insert database rows if there are no answers
  5. two person chat room
  6. Allow php sessions to carry over to subdomains
  7. Check if PHP session has already started
  8. Understanding the “post/redirect/get” pattern
  9. Example of how to use bind_result vs get_result
  10. mysqli::query(): Couldn’t fetch mysqli
  11. get array of rows with mysqli result
  12. How to install MySQLi on MacOS
  13. How do I iterate over the results in a MySQLi result set?
  14. Is possible to keep session even after the browser is closed?
  15. PHP MySQLI Prevent SQL Injection [duplicate]
  16. The mysqli extension is missing. Please check your PHP configuration
  17. How to test if a MySQL query was successful in modifying database table data?
  18. Passing multiple variables to another page in url
  19. PHP Commands Out of Sync error
  20. Destroy PHP Session on closing
  21. Executing mysqli_query inside a function
  22. Can’t return a result set in the given context
  23. How to manage a single PHP5 session on multiple apache servers?
  24. How to run the bind_param() statement in PHP?
  25. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  26. Same domain, different folder PHP session
  27. Which is fastest in PHP- MySQL or MySQLi?
  28. Check to see if an email is already in the database using prepared statements
  29. How to insert into MySQL using mysqli
  30. How to send cookies with file_get_contents

Leave a Comment