Skip to Content
PHPCODE
CodeIgniter Search Articles
codeigniter code / August 5, 2018

Serach Articles in Codeigniter

step 1:- Created model search function
public function search($query)
{
$q=$this->db->from(‘articles’)
->like(‘title’,$query)
->get();
return $q->result();
}
step 2: – created search function in controller
public function search()
{
$this->load->library(‘form_validation’);
$this->form_validation->set_rules(‘query’,’Query’,’required’);

if(! $this->form_validation->run())
$this->index();

$query=$this->input->post(‘query’);
$this->load->model(‘articlesmodel’,’articles’);
$articles=$this->articles->search($query);

$this->load->view(‘public/search_results’,compact(‘articles’));
}

step 3: created search_results in view

<?php include (‘public_header.php’);?>
<div class=”container”>
<h1>Serach Results</h1>
<table class=”table”>
<thead>
<tr>
<td>Sr No.</td>
<td>Article Title</td>
<td>Published On</td>
</tr>
</thead>
<tbody>
<tr>
<?php if(count($articles)):?>
<?php $count=$this->uri->segment(3,0);?>
<?php foreach($articles as $article ):?>
<td><?= ++$count?></td>
<td><?= $article->title?></td>
<td><?= “Date” ?></td>
</tr>
<?php endforeach;?>

<?php else: ?>
<tr>
<td colspan=”3″> No Records Found.</td>
</tr>
<?php endif;?>
</tbody>
</table>
</div>

<?php include (‘public_footer.php’);?>s

PHPCODE © 2024