Add array to memcache

Question

Here is my code to "store" mysql queries with memcache

$mem = new Memcache;
$mem->connect('127.0.0.1', 11211);

$query = "SELECT * FROM tbl limit 0,20 ";
$key = md5($query);

$get_data = $memcache->get($key);

if($get_data) {
 echo 'Data Pulled From Cache';
} else {
   $res = mysql_fetch_array(mysql_query($query));
   $memcache->set($key, $res, TRUE, 3600); 
}

The problem is that memcache store only the first row returned by query. How to save all 20 rows within one key in memcache ?

origo · Accepted Answer · 2011-01-20 12:45:28Z

7

The statement

$res = mysql_fetch_array(mysql_query($query);

only fetches ONE row from the query result.

Try something like this to fetch the entire result before storing it in the cache:

$res = array();
$qres = mysql_query($query);
while($a = mysql_fetch_array($qres, MYSQL_ASSOC))
  $res[] = $a;
mysql_free_result($res);

$memcache->set($key, $res, TRUE, 3600);

answered Jan 20, 2011 at 12:45

origo

5333 silver badges6 bronze badges

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

Comments

powtac · Accepted Answer · 2012-08-20 12:06:24Z

1

Instead of

$res = mysql_fetch_array(mysql_query($query));
$memcache->set($key, $res, TRUE, 3600);

use mysql_fetch_array() with while, check this

edited Aug 20, 2012 at 12:06

answered Jan 20, 2011 at 12:45

powtac

41.1k28 gold badges120 silver badges173 bronze badges

1 Comment

Toni Michel Caubet Over a year ago

would you mind elaborating the example? i am having a lot of trouble here.. stackoverflow.com/posts/comments/14014953

Collectives™ on Stack Overflow

Add array to memcache

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related