<select name="tanggal">
<option value="0" selected>Pilih</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
<select name="bulan">
<option value="0" selected>Pilih Bulan</option>
<option value="januari">Januari</option>
<option value="februari">Februari</option>
<option value="maret">Maret</option>
</select>
<select name="tahun">
<option value="0" selected>Pilih Tahun</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
</select>
<select name="kategori">
<option value="0" selected>Pilih kategori</option>
<option value="news">News</option>
<option value="bandung_city">Bandung City</option>
<option value="hot_gossip">Hot Gossip</option>
<option value="kriminal">Kriminalitas</option>
<option value="persibnews">#PERSIBONTHENEWS</option>
</select>

function pencarian_indeks() {
$data['kategori'] = $this->input->post('kategori');
$data['tanggal'] = $this->input->post('tanggal');
//set session user data untuk pencarian, untuk paging pencarian
$this->session->set_userdata('sess_kategori', $data['kategori']);



$this->db->where('kategori', $data['kategori']);
$this->db->from('news');

//Pagination init
$pagination['base_url'] = base_url().'/pencarian/index/page/';
$pagination['total_rows'] = $this->db->count_all_results();
$pagination['full_tag_open'] = "<p><div class=\"pagination\">";
$pagination['full_tag_close'] = "</div></p>";
$pagination['cur_tag_open'] = "<span class=\"current\">";
$pagination['cur_tag_close'] = "</span>";
$pagination['num_tag_open'] = "<span class=\"disabled\">";
$pagination['num_tag_close'] = "</span>";
$pagination['per_page'] = "3";
$pagination['uri_segment'] = 4;
$pagination['num_links'] = 4;

$this->pagination->initialize($pagination);

$data['query'] = $this->news_model->indeks_berita($pagination['per_page'],$this->uri->segment(4,0),$data['kategori']);

$this->load->vars($data);
$data['hasil5'] = $this->news_model->tampil_populer(2);
$data = array_merge($data,admin_info());
$this->parser->parse('frontend/indeks/indeks',$data);
}

function indeks_berita($perPage, $uri, $kategori) {
$this->db->select('*');
$this->db->from('news');
$this->db->where('created_at = DAY(created_at)');
$this->db->where('created_at = MONTH(created_at)');
$this->db->where('created_at = YEAR(created_at)');
$this->db->where('kategori', $kategori);
$this->db->order_by('id', 'asc');
$getData = $this->db->get('', $perPage, $uri);

//echo $this->db->last_query();

if ($getData->num_rows() > 0)
return $getData->result_array();
else
return null;

}

SELECT * FROM (`news`) WHERE `created_at` = DAY(created_at) AND `created_at` = MONTH(created_at) AND `created_at` = YEAR(created_at) AND `kategori` = 0 ORDER BY `id` asc LIMIT 3