photochallenge_memcached.php

<?php
function get_user($userid) {
   global $db, $m, $photo_urlbase;

   $key = "photochallenge_user_{$userid}";

   if (!($user = $m->get($key))) {
      $query = <<<EOT
         SELECT `userid`, `name`, `avatar`, `location`, `facebook`, `twitter`, `flickr`, `pro`
         FROM `users`
         WHERE `userid` = ? 
EOT;

      $stmt = $db->prepare($query);
      $stmt->bind_param("i", &$userid);
      $stmt->execute();
      $stmt->bind_result(&$userid, &$name, &$avatar, &$location, &$facebook, &$twitter, &$flickr, &$pro);
      $stmt->fetch();
      $stmt->close();

      $user = array(
         'userid' => $userid,
         'name' => $name,
         'avatar' => $avatar ? "{$photo_urlbase}/user/{$userid}.jpg" : "", 
         'location' => $location,
         'accounts' => array(
            'facebook' => $facebook,
            'twitter' => $twitter,
            'flickr' => $flickr
         ),  
         'pro' => $pro
      );  

      $m->set($key, $user, 600);
   }   

   return $user;
}
?>