Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*---------controller----*/
- public function cari_renungan()
- {
- $q=$this->input->post('q');
- $data['cari'] = $this->renungan_model->cari($q);
- $this->load->view('cari_renungan',$data);
- }
- /*---------model----*/
- function cari()
- {
- $q = $this->input->POST ('q');
- return $this->db->query("SELECT * FROM
- artikel a, rtulis b, rkater c
- where a.rt_id=b.rt_id and
- a.rk_id=c.rk_id and a.ar_section='RENUNGAN'
- and (a.ar_title
- like '%$q%' or b.rt_name like '%$q%' )
- group by a.ar_id");
- }
- /*---------view------*/
- <?php foreach ($cari->result() as $row)
- { ?>
- <h2><?php echo $row->ar_title ?></h2>
- <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement