Module query keeps returning CI

ancarius · August 2011

So as the title says I'm trying to return all the people in my DB table and instead of getting a clean results object I get the CI instance. For full detail:

My module's named "Bio" and it's partly modeled on the "Blog" module.

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

require_once(MODULES_PATH.'/bio/config/bio_constants.php');
class Bio_core {
	var $_CI;
	
	function __construct() {
		$this->_CI =& get_instance();
	}
	
	function sidebar( $query = FALSE ) {
		$this->_CI->load->module_library(FUEL_FOLDER, 'fuel_pagevars');
		
		$vars['people'] = $this->_get_people( $query );
		
		$output = $this->_render(BIO_FOLDER, '_blocks/sidebar', $vars);
		
		return $output;
	}
	
	function _render( $view, $vars = array(), $return=TRUE ) {
		$output = $this->_CI->load->module_view($view, $vars, $return);
		$output = $this->_CI->fuel_page->fuelify($output);
		
		return $output;
	}
	
	function _get_people( $where = array(), $order_by = NULL, $limit = NULL, $offset = NULL, $return_method = NULL, $assoc_key = NULL ) {
		$this->_CI->load->module_model(BIO_FOLDER, 'bio_people_model');
		$this->_CI->module_model->readonly = TRUE;
		$people = $this->_CI->bio_people_model->find_all($where, $order_by, $limit, $offset, $return_method, $assoc_key);
		
		var_dump($people);
		
		
		return $people;
	}
	
}

/* End of file bio_core.php */
/* Location: ./modules/libraries/bio_core.php */

The query gets called from the _get_people() function and my model for it looks like this:

<?php  if (!defined('BASEPATH')) exit('No direct script access allowed');
require_once(FUEL_PATH.'models/base_module_model.php');

class Bio_people_model extends Base_module_model {
    public $record_class = 'Bio_person';
    public $foreign_keys = array('category_id' => array( 'bio' => 'bio_categories_model'));
	
	function __construct() {
		parent::__construct('bio_people', BIO_FOLDER); // table name
	}
	
	function list_items() {
		$result = parent::list_items();
		
		return $result;
	}
	
	function find_all($where = array(), $order_by = NULL, $limit = NULL, $offset = NULL, $return_method = NULL, $assoc_key = NULL) {
		$this->db->select('bio_people.*');
		$return = parent::find_all($where = array(), $order_by = NULL, $limit = NULL, $offset = NULL, $return_method = NULL, $assoc_key = NULL);
		
		return $return;
	}
	
	function _common_query() {
		$this->db->join('bio_categories', 'bio_categories.id=bio_people.category_id');
		$this->db->select('bio_people.id, bio_people.name, bio_categories.name as category, bio_people.published, bio_people.active');
		$result = parent::_common_query();
		
		return $result;
	}
	
}

class Bio_person_model extends Base_module_record {


}

Could anybody explain what I'm doing wrong? I really need to get this thing moving. Thanks.

admin · August 2011

Are you sure it's the $CI object and not an array of "Bio_person_model" objects? What happens when you do the following:

foreach($people as $person){
print_r($person->values());
}

ancarius · August 2011

That actually worked. Thanks. But shouldn't find_all() already return a result set?

admin · August 2011

it returns an array of Bio_person_model objects. If you use the "get" method, it will return a "Data_set" object

ancarius · August 2011

So...using the same method I tried implementing it on a "find_one" command but as of yet with no luck. When I try $this->db->last_query() it returns false.

ancarius · August 2011

Nevermind. Realized my mistake. "find_one" items are already returned.

Howdy, Stranger!

Categories

Module query keeps returning CI

Comments