Cevaplar
Hiç cevap bulunamadı.
İlk cevabı siz yazın.
$data['yazilar'] = $this->Model->yazilar($this->uri->segment(3,0),10);
public function index() { $this->load->Model('sayfalama_model', 'Model'); $this->load->library('pagination'); $data['sayfalama_linkleri'] = $this->sayfalama_linkleri($this->Model->yazilar_adet()); $data['yazilar'] = $this->Model->yazilar($this->uri->segment(3,0),10); $this->load->view('index_ana', $data); } function sayfalama_linkleri($toplam) { $config = array( 'base_url' => site_url('kontrol/index'), 'total_rows' => $toplam, 'per_page' => 10, 'num_links' => 2, 'page_query_string' => FALSE, 'uri_segment' => 3, 'full_tag_open' => '<div class="pagination">', 'full_tag_close' => '</div>', 'first_link' => 'İlk Sayfa', 'first_tag_open' => '', 'first_tag_close' => '', 'last_link' => 'Son Sayfa', 'last_tag_open' => '', 'last_tag_close' => '', 'next_link' => 'Sonraki', 'next_tag_open' => '', 'next_tag_close' => '', 'prev_link' => 'Önceki', 'prev_tag_open' => '', 'prev_tag_close' => '', 'cur_tag_open' => '<span class="current">', 'cur_tag_close' => '</span>', 'num_tag_open' => '', 'num_tag_close' => '' ); $this->pagination->initialize($config); return $this->pagination->create_links(); }
function yazilar($baslangic, $limit) { $sql = "SELECT * FROM t_baslik ORDER BY b_id DESC LIMIT $baslangic,$limit"; $query = $this->db->query($sql); if( $query->num_rows() > 0 ) { return $query->result_array(); } else { return FALSE; } } function yazilar_adet() { $sql = "SELECT COUNT(*) as adet FROM t_baslik"; $query = $this->db->query($sql); return (int)$query->row()->adet; }
<?php if( $yazilar ) : ?> <table id="s_table"> <tr> <th>ID</th> <th>Başlık</th> </tr> <?php foreach( $yazilar as $dizi ) : ?> <tr> <td style="width: 20;"><?php echo $dizi['b_id']; ?></td> <td><a href=" <?php echo ''.base_url().'index.php/view/index/'.$dizi['b_id'].''; ?>"><?php echo $dizi['b_baslik']; ?></a></td> </tr> <?php endforeach; ?> </table> <?php echo $sayfalama_linkleri; ?> <?php endif; ?>