Welcome Guest, Not a member yet? Register   Sign In
NEED HELP ABOUT count_all_results()
#1

[eluser]erviando[/eluser]
i want show result of count from model to view

but there is a notice "Message: Array to string conversion"

please help me...

thanks before...


Model:
function get_all_topikdo_jumlah()
{
$this->db->select('topik_pembimbing1');
$this->db->select('topik_pembimbing2');
$this->db->count_all_results('topik');


$this->db->from('topik');
$this->db->from('dosen');
$this->db->where('dosen_id','topik_pembimbing1');
$this->db->or_where('dosen_id','topik_pembimbing2');
$data=$this->db->get();
return $data->result();
}


Controller:
$data['jumlah'] = $this->topikdo_model->get_all_topikdo_jumlah();


View:
<?php

$no=1;
foreach($daftardosen as $row)
{
?>
<tr>
<td>&lt;?php echo $row->dosen_id;?&gt;</td>
<td>&lt;?php echo $row->dosen_nama;?&gt;</td>
<td>&lt;?php echo $jumlah;?&gt;</td>
</tr>
&lt;?php $no++;
}
?&gt;
#2

[eluser]TheFuzzy0ne[/eluser]
Code:
if ( ! $code_tags)
{
    echo 'Behold the power of the [code] tags!';
}

First of all, how about (Ooh look! Code tags! Big Grin):

Model:
Code:
function get_all_topikdo_jumlah()
{
  $this->db->select(‘topik_pembimbing1’);
  $this->db->select(‘topik_pembimbing2’);
   // No point doing this unless we're assigning the number of results to a variable.
  $data['total_rows'] = $this->db->count_all_results(‘topik’);
  

  $this->db->from(‘topik’);
  $this->db->from(‘dosen’);
  $this->db->where(‘dosen_id’,‘topik_pembimbing1’);
  $this->db->or_where(‘dosen_id’,‘topik_pembimbing2’);
  $data['results'] = $this->db->get()->result();

  return $data;
}

$data['jumlah'] is an array of objects, which is why echoing that is causing an error. What is this variable for? I don't understand. If you're expecting it to contain a string, you need to extract that from the database result.

Also, if you're only expecting a single row, it would make sense to limit your query to a single result, and use result_row() instead of result()




Theme © iAndrew 2016 - Forum software by © MyBB