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
– Vinsens, Commented Feb 13, 2016 at 2:19

devpro · Accepted Answer · 2016-02-14 20:32:57Z

1

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;
}

answered Feb 14, 2016 at 20:32

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ravi Hirani · Accepted Answer · 2016-02-12 12:06:37Z

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, 2016 at 12:06

Ravi Hirani

6,5341 gold badge31 silver badges43 bronze badges

6 Comments

Vinsens Over a year ago

I got Error Number: 1064. SELECT COUNT(*) AS numrows WHERE kategori.url = 'baterai' AND produk.status_produk = '1'

Ravi Hirani Over a year ago

Your query should be :- SELECT COUNT(*) AS numrows FROM TableName WHERE kategori.url = 'baterai' AND produk.status_produk = '1' . You have missed TableName

Vinsens Over a year ago

I using array where codeigniter. And I got that produce

Ravi Hirani Over a year ago

Check my second portion of answer.

Vinsens Over a year ago

Thanks dude, but what I should fill 'table' while I have 2 tables here?

|

Praveen Kumar · Accepted Answer · 2016-02-12 12:56:13Z

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, 2016 at 12:56

answered Feb 12, 2016 at 11:30

Praveen Kumar

2,3981 gold badge14 silver badges21 bronze badges

3 Comments

Vinsens Over a year ago

The table name is: kategori and produk. I want count how much row I get from this where query

Praveen Kumar Over a year ago

How these 2 table's are connected to each other ?

Praveen Kumar Over a year ago

i mean is there any common column name ?

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

6 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

6 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related