Saturday 15 June 2013

Search is not working in codeigniter -



Search is not working in codeigniter -

i did search not taking passed value in text box,can 1 help me solve issue..thanks in advances........my model query right or error there......

if come in in search term redirecting search results page showing blank results.......and saying invalid argument supplied foreach()

if print last_query() in showing below.....

select * (`clients`) `clientname` '%%'

this controller:

class client extends ci_controller{ public function __construct(){ parent::__construct(); $this->load->model("client_model"); $this->load->model("interview_model"); $this->load->model("candidate_model"); $this->load->model("requirement_model"); } function search() { $search_term = $this->input->post('search'); $data['query'] = $this->client_model->search_client($search_term); echo "<pre>"; print_r($this->db->last_query()); exit; $data['page_title'] = "search results"; $this->layout->view("client/search",$data); } }

model:

function search_client($search_term) { $this->db->select('*'); $this->db->from('clients'); $this->db->like('clientname',$search_term); // execute query. $query = $this->db->get(); // homecoming results. homecoming $query->result_array(); }

this form in index.php(view):

<form action="<?php base_url();?>client/search"> <input type="text" name="search" id="search" style="width:180px" placeholder="search here..." />&nbsp; <input type="submit" value="search" name="submit" class="btn btn-primary btn-sm" /></form>

this search.php(view):

<?php foreach($query $client){ ?> <tr> <td><?php echo $client->clientname;?></td> <td><?php echo $client->clientsname; ?></td></td> <td> <?php } ?>

change line:

<form method="post" action="<?php base_url();?>client/search">

to this:

<form action="<?php echo base_url();?>client/search">

and seek next approch:

function search_client($search_term){ $this->db->select('*'); $this->db->from('clients'); $this->db->like('clientname',$search_term); // execute query. $query = $this->db->get(); if($query->num_rows()>0) homecoming $query->result(); else homecoming false; }

codeigniter

No comments:

Post a Comment