PHP and Redis Paging program code

After using the Redis speed up the result is the complexity of the operation of data, pagination has a feeling of the pants fart. But there is no other way. The code is as follows

The code is as follows

Copy Code

<?php $redis = new Redis; $redis->connect (' 127.0.0.1 ', 6379,0); //Database $host = ' ******** '; $user = ' root '; $psd = ' * * *; $dbname = ' ask ';   $link = mysql_connect ($host, $user, $PSD); mysql_select_db ($dbname, $link); mysql_query ("Set Names UTF8" );   $SQL = "SELECT * from question LIMIT"; $query = mysql_query ($SQL); $questionName = ' questionname '; while ($info = Mysql_fetch_array ($query)) { $list [] = $info; $redisName = ' question_id_ '. $info [' id ']; $redis- >hmset ($redisName, $info); $redis->zadd ($questionName, $info [' id '], $info [' id ']); $i + +; } $range = $redis->zrevrange ($questionName, 0,10);//Paging main function foreach ($range as $qid) { $pageList [] = $redis->hgetall (' question_id_ '. $qid); } Print_r ($pageList); ?

 
just knock and no code specification at all when doing an example. Please encapsulate the basic use of the method is Reids Hmset (), Zadd (), Hgetall (), Zrevrange (), if you do not understand can view the Redis manual, or with the pine forest discussion.