/** * Get all of the lists associated with this user. * * @return array * @access public */ public function getLists() { $lists = array(); // Make sure at least "My Favorites" always exists $list = new User_list(); $list->user_id = $this->id; if (!$list->find(true)) { $list->title = "My Favorites"; if (!$list->find(true)) { $list->insert(); } } $sql = 'SELECT "user_list".*, COUNT("user_resource"."id") AS cnt ' . 'FROM "user_list" LEFT JOIN "user_resource" ' . 'ON "user_list"."id" = "user_resource"."list_id" ' . 'WHERE "user_list"."user_id" = ' . "'" . $this->escape($this->id) . "' " . 'GROUP BY "user_list"."id", "user_list"."user_id", ' . '"user_list"."title", "user_list"."description", ' . '"user_list"."created", "user_list"."public" ' . 'ORDER BY "user_list"."created"'; $list = new User_list(); $list->query($sql); if ($list->N) { while ($list->fetch()) { $lists[] = clone $list; } } return $lists; }
function getLists() { require_once 'User_list.php'; $lists = array(); $sql = "SELECT user_list.*, COUNT(user_resource.id) AS cnt FROM user_list " . "LEFT JOIN user_resource ON user_list.id = user_resource.list_id " . "WHERE user_list.user_id = '{$this->id}' " . "GROUP BY user_list.id, user_list.user_id, user_list.title, " . "user_list.description, user_list.created, user_list.public " . "ORDER BY user_list.title"; $list = new User_list(); $list->query($sql); if ($list->N) { while ($list->fetch()) { $lists[] = clone $list; } } return $lists; }