mvc search data ci

//**** VIEW FORM SEARCH ***/

<div id="body">
<h1 align="center">MASUKAN DATA</h1>
<form method="get" action="<?php echo base_url().'pembeli/cariData' ?>">
<table>
<tr><td>Barang</td><td><input type="text" name="barang"></td>
</tr>
<tr>
<td>Pembeli</td><td><input type="text" name="pembeli"></td>
</tr>
<tr>
<td></td><td><input type="submit" value="submit"></td>
</tr>
</table>
</form>
</div>


//**** CONTROLLER ***/
<?php
function cariData(){
  $data=array();
  $data['barang']=$this->input->get('barang');
  $data['pembeli']=$this->input->get('pembeli');
  $data['data']=$this->m_pembeli->cariData($data);
  $this->load->view('head');
  $this->load->view('user/pemesanan/v_pembeli',$data);
  $this->load->view('footer');
}
?>


//**** MODEL ***/
<?php
public function cariData($data)
{
  $data=array();
  $sql="SELECT * FROM pembeli WHERE 1 ")
      .(isset($data['pembeli']) && !empty($data['pembeli']))?" AND password LIKE '%{$data['pembeli']}%' ":"";
  $pembeli=$this->db->query($sql);
  $data['pembeli']=$pembeli->result();
  $sql="SELECT * FROM data_galon WHERE 1 ")
      .(isset($data['pembeli']) && !empty($data['pembeli']))?" AND username LIKE '%{$data['barang']}%' ":""
  $barang=$this->db->query($sql);
  $data['barang']=$barang->result();
  return $data;
}
?>


//**** VIEW v_pembeli ***/
<div id="body">
<center>
<h1 align="center">DAFTAR PESANAN</h1>
<h4 align="center">Data Identitas</h4>
<table width="80%" border="1" align="center">
  <tr>
     <td>No</td>
     <td>Nama</td>
     <td>Tempat</td>
     <td>Alamat</td>
     <td>Handphone</td>
     <td>Username</td>
     <td>Keterangan</td>
  </tr>
<?php
$i=0;
foreach ($pembeli as $p): ?>
<tr>
  <td><?php echo ++$i;?></td>
  <td><?php echo $p->nama; ?></td>
  <td><?php echo $p->tempat; ?></td>
  <td><?php echo $p->alamat; ?></td>
  <td><?php echo $p->hp; ?></td>
  <td><?php echo $p->username;?></td>
  <td>
   <a href="<?php echo site_url('pembeli/ubah?id='.$p->id)?>">Ubah</a> ||
   <a href="<?php echo site_url('pembeli/hapus?id='.$p->id)?>">Hapus</a>
  </td>
</tr>
<?php enforeach;?>
</table></br>
<h4 align="center">Data Barang</h4>
<table width="80%" border="1" align="center">
  <tr>
    <td>No</td>
    <td>Nama Barang</td>
    <td>pembelian</td>
    <td>Harga</td>
    <td>Keterangan</td>
  </tr>
<?php
$i=0;
foreach ($barang as $b): ?>
<tr>
  <td><?php echo ++$i;?></td>
  <td><?php echo $b->nama_barang; ?></td>
  <td><?php echo $b->pembelian; ?></td>
  <td><?php echo $b->harga; ?></td>
  <td>
    <a href="<?php echo site_url('pembeli/ubah?id='.$b->id_barang)?>">Ubah</a> ||
    <a href="<?php echo site_url('pembeli/hapus?id='.$b->id_barang)?>">Hapus</a>
  </td>
</tr>
<?php endforeach; ?>
</table>
</center>
</div>