Using PHP SESSION Variables to store MySQL query results

Question

I want to execute a query in one file, store it in a session variable, and access the result in another file.

File1.php:

//This is the file I have executed my sql statement in
//I have already done session_start(); and initialized $conn
$query = //my query. I know it is working because I have tested it elsewhere, so I 
         // don't believe it is the problem
$_SESSION['query2'] = mysqli_query($conn, $query)

File2.php:

//This is the file I want to access my query results in.
//I have already done session_start(); and initialized $conn

$tempArray =  $_SESSION['query2'];

if (isset($tempArray)) {
    $row = mysqli_fetch_array($tempArray, MYSQL_NUM);
    if ($row == null) {
        echo "<h1> error </h1>"; //This line gets executed
    } else {
        echo "<h1> works! </h1>";
    }
} else {
    echo "<h1> array not set </h1>";
}

Any ideas as to what I am doing wrong? Or, is there another way to accomplish what I'm trying to do here?

Steve · Accepted Answer · 2014-07-21T21:33:07.610

2

Store the actual array in session:

File1.php:

$query = //my query. 
$result = array();
$res = mysqli_query($conn, $query);
while($row = mysqli_fetch_array($res, MYSQL_NUM){
    $result[] = $row;
}
$_SESSION['query2'] = $result;

File2.php:
//I have already done session_start(); and initialized $conn

$tempArray =  $_SESSION['query2'];
var_dump($tempArray);

edited Jul 21 '14 at 21:33

answered Jul 21 '14 at 20:51

Steve

20,703
5
41
67

Awesome! This helped a lot, but unfortunatly, it turns out that sometimes my data will have have multiple rows.. How should I run a loop to accomplish my task? – user2771279 Jul 21 '14 at 21:05
@user2771279 edited with solution – Steve Jul 21 '14 at 21:08
hmm, this seems to run infinitely for me. Is it suppose to be mysqli_fetch_array(mysqli_query($conn, $query))? – user2771279 Jul 21 '14 at 21:26
@user2771279 Oops, yes, stupid mistake. Sorry about that, will edit! – Steve Jul 21 '14 at 21:31

score 2 · Answer 2 · answered Jul 21 '14 at 21:03

You have two problems there:

Trying to store a class instance is as they told you (remember that the class should implement __sleep() and __wakeup() so you can choose how to serialize the object - what members will you include in serialization, and how will you re-initialize other members when you deserialize - also remember that the object's class must be defined when you unserualiza such object).
Trying to store, particularly, a myqsli object. Those objects contain references to resources which can be collected, so even if you successfully serialize-back such object, their internal references could not be valid anymore.

Your end solution will be, as said before, fetching the rows and keeping them in session. If you don't want to keep the rows (you told there's only one row, but perhaps you don't want an eager-fetching), keep an array with the data to define and bind the query again.

Using PHP SESSION Variables to store MySQL query results

2 Answers2

Linked

Related