result_array codeigniter code example
Example 1: codeigniter get num_rows
$this->db->select('*');
$this->db->where('whatever');
$query = $this->db->get('table');
$num = $query->num_rows();
Example 2: get result count codeigniter
public function record_count() {
return $this->db->count_all("tablename");
}
Example 3: get results from db and put in javascript array codeigniter
$query = $this->db->query("YOUR QUERY");
foreach ($query->result_array() as $row)
{
echo $row['title'];
echo $row['name'];
echo $row['body'];
}