Geekly Articles each Day
📜 ⬆️ ⬇️

Basics of caching. Practice

Hi, habra people!

Introduction


After the publication of my previous post Basics caching. How? When? What for? I realized that I need to talk about practice, and that I’ll actually do it now. This post is similar to the previous one, only practical.

We will use a bunch of PHP + MySQL + memcache.
')

A bit of theory


- Cache keys. There are not many options for creating a key, you can use the obtained md5 from different parameters when creating the cache, or you can use the prefix + identifier, which is what I really prefer. For example, under the key news_id_1234 a cache of news id is stored which is 1234, and under the key news_comments_1234 comments are kept on news of which id is 1234.
- Serialization of arrays. Depending on the tool used, before you cache an array, you sometimes need to serialize it. For memcache, this procedure is not needed.

Home page


We have completely abandoned the caching of the main page, in favor of caching each block separately.
  2. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  3. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  4. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  5. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  6. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  7. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  8. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  9. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  10. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  11. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  13. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  14. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  15. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  16. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  17. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  18. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  19. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  20. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  21. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  22. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  23. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  24. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  25. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  26. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  27. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  28. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  29. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  30. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  31. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  32. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  33. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  34. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  35. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  37. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  38. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  39. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  40. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  41. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  42. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  43. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  44. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  45. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  46. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  47. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  49. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  50. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */
  51. // $mem_block_last_news = $memcache -> get ( 'block_last_news' ) ; if ( $mem_block_last_news === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_news // ... } $memcache -> set ( 'block_last_news' , $mem_block_last_news ) ; } // $mem_block_popular = $memcache -> get ( 'block_popular' ) ; if ( $mem_block_popular === false ) { $time = time ( ) - 86400 * 7 ; // 7 $result = mysql_query ( "SELECT * FROM news WHERE added > " . $time . " ORDER BY views DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_popular // ... } $live_time = 86400 ; // () $memcache -> set ( 'block_popular' , $mem_block_popular , false , $live_time ) ; } // $mem_block_most_commented = $memcache -> get ( 'block_most_commented' ) ; if ( $mem_block_most_commented === false ) { $result = mysql_query ( "SELECT * FROM news ORDER BY comments DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_most_commented // ... } $live_time = 60 * 60 ; // () $memcache -> set ( 'block_most_commented' , $mem_block_most_commented , false , $live_time ) ; } // $mem_block_last_comments = $memcache -> get ( 'block_last_comments' ) ; if ( $mem_block_last_comments === false ) { $result = mysql_query ( "SELECT * FROM comments ORDER BY id DESC LIMIT 10" ) ; while ( $row = mysql_fetch_array ( $result ) ) { // html $mem_block_last_comments // ... } $live_time = 60 ; // () $memcache -> set ( 'block_last_comments' , $mem_block_last_comments , false , $live_time ) ; } /* $mem_block_last_news, $mem_block_popular, $mem_block_most_commented $mem_block_last_comments */


View news


Caching the news itself
  2. $ mem_news_id = $ memcache -> get ( 'news_id_' . $ news_id ) ;
  3. if ( $ mem_news_id === false ) {
  4. $ result = mysql_query ( "SELECT * FROM news WHERE id =" . $ news_id ) ;
  5. list ( $ news ) = mysql_fetch_array ( $ result ) ;
  6. $ news [ 'text' ] = very_hard_processing_to_html ( $ news [ 'text' ] ) ; // Parsing formatting news in regular form in html
  8. $ mem_news_id = $ news ;
  9. $ memcache -> set ( 'news_id_' . $ news_id , $ mem_news_id ) ;
  10. }
  11. / *
  12. Next, to draw the news, we use the $ mem_news_id array obtained from the cache as well as previously used from the database.
  13. * /


View count
  2. $ mem_views = ( int ) $ memcache -> get ( 'news_id_views_' . $ news_id ) ;
  4. mysql_query ( "UPDATE news SET views = views + 1 WHERE id =" . $ news_id ) ; // Update the view counter in the database
  5. if ( mysql_affected_rows ( ) ) { // If the update was successful
  6. if ( $ mem_views )
  7. $ memcache -> increment ( 'news_id_views_' . $ news_id ) ; // If cache exists, increment value
  8. else
  9. $ memcache -> set ( 'news_id_views_' . $ news_id , 1 ) ; // If there is no cache, create a view counter
  10. }
  11. $ mem_views ++;
  12. / *
  13. The number of views is now in the $ mem_views variable
  14. * /


Comments to the news
  1. $ mem_comments = $ memcache -> get ( 'news_comments_' . $ news_id ) ;
  2. if ( $ mem_comments === false ) {
  3. $ mem_comments = array ( ) ;
  4. $ i = 0 ;
  6. $ result = mysql_query ( "SELECT * FROM comments WHERE news_id =" . $ news_id . "ORDER BY id DESC" ) ; // We immediately get all the comments to the news
  7. while ( $ row = mysql_fetch_array ( $ result ) ) { // Build an array with comments
  8. $ row [ 'text' ] = very_hard_processing_to_html ( $ row [ 'text' ] ) ; // very heavy comment formatting
  10. $ mem_comments [ $ i ] = $ row ;
  11. $ i ++;
  12. }
  13. $ memcache -> set ( 'news_comments_' . $ news_id , $ mem_comments ) ;
  14. }
  16. // html generation process
  17. for ( $ i = $ page_offset , $ c = count ( $ mem_comments ) ; $ i < $ c ; $ i ++ ) { // This is how you can simply navigate through the comments in one line
  18. $ comment = $ mem_comments [ $ i ] ;
  19. if ( $ comment ! = false ) { // If there is a comment
  20. // Here we process the comment in the $ comment variable and collect html
  21. // ...
  22. }
  23. }

Check for new messages


How to cache forever and so it is clear, so consider the short-term caching for the duration of the user activity (session).
  1. $ mem_new_messages = $ memcache -> get ( 'new_messages_' . $ user_id ) ;
  2. if ( $ mem_new_messages === false ) {
  3. $ result = mysql_query ( "SELECT COUNT (*) AS new_messages FROM messages WHERE to_user =" . $ user_id ) ; // Get the number of new messages from the database
  4. list ( $ mem_new_messages ) = mysql_fetch_array ( $ result ) ;
  6. $ live_time = 60 * 30 ; // (30 minutes)
  7. $ memcache -> set ( 'new_messages_' . $ user_id , $ mem_new_messages , false , $ live_time ) ;
  8. }
  10. if ( $ _SESSION [ 'last_check' ] < time ( ) - 60 * 10 ) { // Check whether it is necessary to extend the cache lifetime (every 10 minutes)
  11. $ _SESSION [ 'last_check' ] = time ( ) ;
  13. $ live_time = 60 * 30 ;
  14. $ memcache -> replace ( 'new_messages_' . $ user_id , $ mem_new_messages , false , $ live_time ) ;
  15. }


Delete cache


Do not forget to delete the cache if necessary! With the code given above in which cases it is necessary to delete it is described in the previous post. Delete the cache is extremely simple
  1. $ memcache -> delete ( 'some_key' ) ;
  2. $ memcache -> delete ( 'news_id_' . $ news_id ) ;


Ps. I apologize for the delay in post publication. Happy Easter!

Source: https://habr.com/ru/post/89122/

More articles:


All Articles