Kohana 3.2 - 数据库搜索返回空对象

Question

Try to make 'archive' for my blog. If the search run for unavaliable items the return is an empty object. Here is my code:

For example wrong input:

http://www.my-site.com/archive/2011/01/27 - in database no post with this date 2011-01-27

The controller action:

public function action_archive() {
    $posts_model = new Model_Posts();

    // Év pl.: 2012
    if($year = $this->request->param("year")) {
        // Hónap pl.: 2012-03
        if($month = $this->request->param("month")) {
            // Nap pl.: 2012-03-27
            if($day = $this->request->param("day")) {
                if ($posts = $posts_model->get_post_by_date($year . "-" . $month . "-" . $day)) {
                    $this->template->content = View::factory('posts/default')
                        ->bind('posts', $posts);
                } else
                    throw new HTTP_Exception_404;
            } else {
                if($posts = $posts_model->get_post_by_date($year . "-" . $month)) {
                    $this->template->content = View::factory('posts/default')
                        ->bind('posts', $posts);
                } else
                    throw new HTTP_Exception_404;
            }

        } else {
            if($posts = $posts_model->get_post_by_date($year)) {
                $this->template->content = View::factory('posts/default')
                    ->bind('posts', $posts);
            } else
                throw new HTTP_Exception_404;
        }
    } else
        // Nem található archívum
        throw new HTTP_Exception_404;

    return false;
}

I am try to throw 404 exception if the search fails. Here comes the model:

public function get_post_by_date($date) {
    try {
        return DB::select()
            ->from("posts")
            ->where("date", "like", "$date%")
            ->and_where("publish", "=", "1")
            ->as_object()
            ->execute();
    } catch (Database_Exception $e) {
        Kohana::$log->add(Log::ERROR, Database_Exception::text($e));
    }

    return false;
}

Answer 1

If you need just to check if there is a particular entry in the database use ->execute()->count();

In your case you will need the actual posts, so you can use the count method of the Database_Result class (it implements the Countable interface).

$posts = $posts_model->get_post_by_date($year . "-" . $month . "-" . $day);
if ($posts->count()) {
    $this->template->content = View::factory('posts/default')
        ->bind('posts', $posts);
} else
    throw new HTTP_Exception_404;

And remove that try-catch block. You don't need it if your query is correct.