controller

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Welcome extends CI_Controller {


	public function index()
	{

		$this->load->view('welcome_message');
	}

	public function search()
	{
		// tangkap variabel keyword dari URL
		$keyword = $this->uri->segment(3);
		// cari di database
		$data = $this->db->query("SELECT * FROM `tabel_suplier` WHERE id_suplier like '%$keyword%' ");

		// format keluaran di dalam array
		foreach($data->result() as $row)
		{
			$arr['query'] = $keyword;
			$arr['suggestions'][] = array(
				'value'	=>$row->id_suplier,
				'data'	=>$row->nama
			);
		}
		// minimal PHP 5.2
		echo json_encode($arr);
	}


	public function barang()
	{
		// tangkap variabel keyword dari URL
		$keyword = $this->uri->segment(3);
		// cari di database
		$data = $this->db->query("SELECT * FROM `tabel_barang` WHERE id_barang like '%$keyword%' ");

		// format keluaran di dalam array
		foreach($data->result() as $row)
		{
			$arr['query'] = $keyword;
			$arr['suggestions'][] = array(
				'value'	=>$row->id_barang,
				'data'	=>$row->nama_barang,
				'harga'	=>$row->harga,
				'jumlah_all'	=>$row->jumlah_all,
			);
		}
		// minimal PHP 5.2
		echo json_encode($arr);
	}

	public function kategori()
	{
		// tangkap variabel keyword dari URL
		$keyword = $this->uri->segment(3);
		// cari di database
		$data = $this->db->query("SELECT * FROM `tabel_kategori` WHERE id_kategori like '%$keyword%' ");

		// format keluaran di dalam array
		foreach($data->result() as $row)
		{
			$arr['query'] = $keyword;
			$arr['suggestions'][] = array(
				'value'	=>$row->id_kategori,
				'data'	=>$row->kategori,
			);
		}
		// minimal PHP 5.2
		echo json_encode($arr);
	}


	public function brand()
	{
		// tangkap variabel keyword dari URL
		$keyword = $this->uri->segment(3);
		// cari di database
		$data = $this->db->query("SELECT * FROM  `tabel_brand`  WHERE id_brand '%$keyword%' ");

		// format keluaran di dalam array
		foreach($data->result() as $row)
		{
			$arr['query'] = $keyword;
			$arr['suggestions'][] = array(
				'value'	=>$row->id_brand,
				'data'	=>$row->brand,
			);
		}
		// minimal PHP 5.2
		echo json_encode($arr);
	}

}