[eluser]Unknown[/eluser]
this my code
model:
Code:
<?php
class Artikel_Model extends Model {
var $table = 't_artikel';
function Artikel_Model(){
parent::Model();
}
function get_data(){
/*
$this->db->select('*');
$this->db->from($this->table);
*/
$this->db->select('t_artikel.id,
t_artikel.judul,
t_artikel.alias,
t_artikel.isi,
t_artikel.isi_kutipan,
t_artikel.create_username,
t_artikel.update_username,
t_artikel.`status`,
t_artikel.baktif,
t_artikel.idkategori,
t_artikel.tgl_create,
t_artikel.tgl_publish,
t_artikel.tgl_update,
t_artikel.totview,
t_artikel.bkomentar,
t_artikel_kategori.nmkel');
$this->db->from('t_artikel Left Join t_artikel_kategori ON t_artikel_kategori.id = t_artikel.idkategori');
$this->db->order_by('t_artikel.tgl_create', 'desc');
//$this->db->limit($limit, $offset);
return $this->db->get();
}
function get_count_all_raws(){
return $this->db->count_all($this->table);
}
}
?>
controller:
Code:
<?php
class Artikel extends Controller {
function Artikel(){
parent::Controller();
$this->load->model('Artikel_Model');
}
function index(){
// cek sudah login apa belum
if($this->session->userdata('login')==TRUE){
$this->get_artikel();
}else{
redirect('login');
}
}
function get_artikel(){
// tampilkan hasil ke view
$data['title'] = 'Artikel';
$data['main_view'] = 'admin/artikel';
$artikels = $this->Artikel_Model->get_data();
$trows = $this->Artikel_Model->get_count_all_raws();
if($trows>0){
$srow='
<table width="200" border="1">
<tr>
<td width="39">No.</td>
<td width="79">Judul</td>
<td width="26">Isi</td>
<td width="28"> </td>
</tr>';
$i = 0;
foreach($artikels as $artikel){
$i++;
$srow .='
<tr>
<td>'.$i.'</td>
<td>'.$artikel["judul"].'</td>
<td> </td>
<td> </td>
</tr>';
echo $artikel[0];
}
$srow .='</table>';
$data['table'] = $srow;
}
$this->load->view('admin/admin_template', $data);
}
}
?>
View:
<p>Show Data</p>
<?php echo $tabel ?>
and then get error:
[code]
A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Filename: admin/artikel.php
Line Number: 49
A PHP Error was encountered
Severity: Notice
Message: Undefined index: judul
Filename: admin/artikel.php
Line Number: 44
[/code]