CodeIgniter查询WordPress博客

Question

我终于开始尝试一些CodeIgniter了，现在我被困住了。

新闻模型

public function get_news($slug = FALSE){
    if($slug === FALSE){
        // if there is no slug specified, pull all records from the 'wp_posts' table
        $this->db->select('post_title, post_content, post_name');
        $this->db->where('post_status', 'published');
        $this->db->where('post_type', 'post');
        $this->db->order_by("post_date", "desc");
        $this->db->order_by("post_title", "asc");
        $query = $this->db->get('wp_posts');
        
        var_dump($query);
        
        // return the resulting array
        return $query->result_array();
    }else{
        // if it does exist, pull only the record(s) specified where column 'slug' = the parameter
        $this->db->select('post_title, post_content, post_name');
        $query = $this->db->get_where('wp_posts', array('post_name' => $slug));
        // return the resulting array
        return $query->row_array();
    }
}

控制器

class News extends CI_Controller{
    
    public function __construct(){
        parent::__construct();
        // located @ /application/models/news_model.php
        $this->load->model('news_model');   
    }
    
    // pull in all news items
    public function index(){
        $data['news'] = $this->news_model->get_news();
        // give the page a title
        $data['title'] = 'Articles Archive';
        $data['c_year'] = date('Y');
        // Load the header template
        $this->load->view('templates/header', $data);
        // Load the page
        $this->load->view('news/index', $data);
        // Load the footer template
        $this->load->view('templates/footer', $data);
    }
    
    // pull in only the news item(s) where the slug matches
    public function view($slug){
        $data['news_item'] = $this->news_model->get_news($slug);
        // give the page a title
        $data['title'] = $data['news_item']['title'];
        $data['c_year'] = date('Y');
        // Load the header template
        $this->load->view('templates/header', $data);
        // Load the page
        $this->load->view('news/view', $data);
        // Load the footer template
        $this->load->view('templates/footer', $data);
    }
        
}

连接到数据库是可以的，但是在我看来，我只返回show_404();，因为有no记录。

直接对数据库运行类似的查询确实会返回我的所有记录。

以下是var_dump的结果

object(CI_DB_mysql_result)#18 (8) { 
   ["conn_id"]=> resource(3) of type (mysql link persistent) 
   ["result_id"]=> resource(4) of type (mysql result) 
   ["result_array"]=> array(0) { } 
   ["result_object"]=> array(0) { } 
   ["custom_result_object"]=> array(0) { } 
   ["current_row"]=> int(0) ["num_rows"]=> int(0)
   ["row_data"]=> NULL 
}

我在这里做错什么了？

Answer 1

变化：$this->db->where('post_status', 'published');

致：$this->db->where('post_status', 'publish');

问题解决了..。这一周很漫长..。