derererer

$query = "SELECT `id_barang`, `nama_barang`,  `jumlah_all`  FROM `tabel_barang` where UPPER($type) LIKE '".strtoupper($name)."%'";
$result = $this->db->query($query)->result_array();


//bagaimana buat kalau seumpama jumlah_all itu kosong
$data = array();
foreach ($result as $row) {
$name = $row['id_barang'].'|'.$row['nama_barang'].'|'.$row['jumlah_all'];
array_push($data, $name);
}
echo json_encode($data);