Serialize BEFORE the mysql_fetch_array?

Question

I'm trying to use memcache but I'm stuck on a small part. I've got a function that gives in result an array of several things (most of them being strings), and one of them is the result of the mysql_query() function. Here is how I am trying to unserialize:

    $posts_count = my query;                

    /* MEMCACHE KEY GEN*/
    $memcache_key = md5($posts);
    $pagination = memcache_get($memcache, $memcache_key);
    if($pagination==NULL) {
        echo 'NOT CACHED';
        $pagination = (the function that will call mysql_query)
        //SAVE A SERIALIZED VERSION OF THE ARRAY
        $memcache->set($memcache_key, serialize($pagination), 0, 3600); 
    }
    else {
        $pagination = unserialize($pagination);
    }

    //THIS IS ONLY THE RESULT OF mysql_query!!!     

    $posts = $pagination[result]; 
    while($var = mysql_fetch_array($posts)) { ... stuffs here }

Any idea on how to "save" this result of mysql_query before the mysql_fetch_array? Or any idea how to use memcache to cache the whole while loop?

Ok, but then is there a way to use memcache in a while loop? — Alb Dum
– Alb Dum, Commented Nov 15, 2011 at 1:00

DaveRandom · Accepted Answer · 2011-11-15 09:27:34Z

1

How about something like this:

$posts_count = "my query";                

/* MEMCACHE KEY GEN*/
$memcache_key = md5($posts);
$pagination = memcache_get($memcache, $memcache_key);
if ($pagination == NULL) {
  echo 'NOT CACHED';
  $pagination = function_that_will_call_mysql_query();
  // Create an array of all the results
  $data = array();
  while ($row = mysql_fetch_assoc($pagination['result'])) {
    $data[] = $row;
  }
  $pagination['result'] = $data;
  //SAVE A SERIALIZED VERSION OF THE ARRAY
  $memcache->set($memcache_key, serialize($pagination), 0, 3600); 
} else {
    $data = unserialize($pagination);
}

// THIS IS ONLY THE RESULT OF mysql_query!!! (but now it's an array)

$posts = $pagination['result']; 
while ($var = array_shift($posts)) {
  // ... do stuff here
}

edited Nov 15, 2011 at 9:27

answered Nov 15, 2011 at 1:06

DaveRandom

88.8k11 gold badges159 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mike Purcell Over a year ago

Was going to suggest something similar but the OP is pretty confusing. Hopefully it sticks.

Alb Dum Over a year ago

That's perfect! I would never have thought of array_shift ! Thanks a lot ! :)

Django Anonymous Over a year ago

Hey @DaveRandom Please check out this : stackoverflow.com/questions/9798949/… If you can help...

Collectives™ on Stack Overflow

Serialize BEFORE the mysql_fetch_array?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related