Fatal error: $this->db->where()->join()->num_rows()

Question

I want to make codeigniter pagination with where db query.

My model: (update)

public function get_all_produk_row($url = ''){
  data = array();
  $this->db->where(array('kategori.url'=>$url,'produk.status_produk'=>'1'));
  $this->db->order_by('kategori_id');
  $this->db->join('kategori','kategori.id_kategori=produk.kategori_id');
  $this->db->num_rows();
  return $data;
}

But I got Fatal error: Call to undefined method CI_DB_mysql_driver::num_rows().

How can I solve it?

My database

Kategori:

id_kategori
kode_kategori
url

Produk:

id_produk
kategori_id
kode_produk
status_produk

produce: `SELECT * FROM (produk) JOIN kategori ON kategori.id_kategori=produk.kategori_id WHERE kategori.url = '$url' AND produk.status_produk = '1' ORDER BY kategori_id`. Where I must put `num_rows()` code? — Vinsens, Feb 13 '16 at 02:19

score 1 · Accepted Answer · answered Feb 14 '16 at 20:32

You can get no of rows after calling get() function as:

public function get_all_produk_row($url = '')
{ 
    $data = array(); 
    $this->db->where(array('kategori.url'=>$url,'produk.status_produk'=>'1')); 
    $this->db->join('kategori','kategori.id_kategori=produk.kategori_id'); 
    $this->db->order_by('kategori_id'); 
    $query = $this->db->get();

    if ($query->num_rows() > 0)
    {
         $data = $query->result_array();
    }
    return $data;
}

Praveen Kumar · Answer 2 · 2016-02-12T12:56:13.170

0

You are missing table name here

public function get_all_produk_row($url = '')
{     
  $data = $this->db->get_where("kategori",array('kategori.url'=>$url,'produk.status_produk'=>'1'))->num_rows(); 
 //or one method can be if you can write query 
 //$data = $this->db->query("select count(*) as total tbl_name")->row()->total; 
  return $data;
}

edited Feb 12 '16 at 12:56

answered Feb 12 '16 at 11:30

Praveen Kumar

2,408
1
12
20

The table name is: **kategori** and **produk**. I want count how much row I get from this **where** query – Vinsens Feb 12 '16 at 11:43
How these 2 table's are connected to each other ? – Praveen Kumar Feb 12 '16 at 12:38
i mean is there any common column name ? – Praveen Kumar Feb 12 '16 at 12:44

score 0 · Answer 3 · answered Feb 12 '16 at 12:06

0

Your query should be as below:-

$this->db->select('*');
$this->db->from('table');
$this->db->where($your_conditions);
$num_results = $this->db->count_all_results();

OR

$this->db->select('*');
$this->db->where('whatever');
$query = $this->db->get('table');
$num = $query->num_rows();

answered Feb 12 '16 at 12:06

Ravi Hirani

6,511
1
27
42

I got Error Number: 1064. _SELECT COUNT(*) AS `numrows` WHERE `kategori`.`url` = 'baterai' AND `produk`.`status_produk` = '1'_ – Vinsens Feb 12 '16 at 12:20
Your query should be :- SELECT COUNT(*) AS numrows FROM TableName WHERE kategori.url = 'baterai' AND produk.status_produk = '1' . You have missed TableName – Ravi Hirani Feb 12 '16 at 12:23
I using array where codeigniter. And I got that produce – Vinsens Feb 12 '16 at 12:24
Check my second portion of answer. – Ravi Hirani Feb 12 '16 at 12:32
Thanks dude, but what I should fill 'table' while I have 2 tables here? – Vinsens Feb 12 '16 at 12:38
Post your both tables in your question. – Ravi Hirani Feb 12 '16 at 12:42

Fatal error: $this->db->where()->join()->num_rows()

3 Answers3