php - How to get JSON values? -
hello guys want ask if how can value of json using loop? did research code wont work. didn't know what's error. want json value , put in table. way using codeigniter
my model:
public function getallpurchaseorder(){ $array = array(); $sqlselectall = "select * po_order inner join po_supplier on po_order.poid = po_supplier.poid inner join po_account_details on po_supplier.poid = po_account_details.poid"; $resultselectall = $this->db->query($sqlselectall); foreach($resultselectall->result_array() $details){ $array[] = $details; } return "{\"data\":" .json_encode($array). "}"; } my controller:
public function index(){ $data['title'] = "welcome"; $data['copyright'] = date('y'); $data['purchased_comment'] = $this->po_model->fetch_purchased_refid(); $data['link'] = "po"; $data['itemlist'] = $this->po_model->getallpurchaseorder(); $this->load->view('common/header_common',$data); $this->load->view('common/navigation'); $this->load->view('purchase order/contents/index',$data); $this->load->view('common/footer_common',$data); } here's code:
echo "<pre>"; var_dump(json_decode($itemlist,true)); my json output using var_dump(json_encode)
array(1) { ["data"]=> array(1) { [0]=> array(25) { ["poid"]=> string(1) "1" ["itemid"]=> string(1) "3" ["item_desc"]=> string(6) "drinks" ["item_qty"]=> string(1) "4" ["item_price"]=> string(4) "5.00" ["total_amount"]=> string(5) "20.00" ["cash_on_delivery"]=> string(1) "y" ["is_check"]=> string(1) "y" ["bank_transfer"]=> string(1) "n" ["transaction_date"]=> string(19) "2013-08-15 15:44:30" ["posupid"]=> string(1) "1" ["spid"]=> string(1) "2" ["spname"]=> string(12) "milo company" ["spaddress"]=> string(6) "manila" ["contact_person"]=> string(4) "none" ["tin"]=> string(12) "1232-456-789" ["contact_number"]=> string(7) "0912151" ["poaccid"]=> string(1) "1" ["payee_name"]=> string(6) "larren" ["bank_details"]=> string(11) "bdo account" ["account_name"]=> string(7) "premium" ["account_number"]=> string(5) "54564" ["prepared"]=> string(5) "admin" ["checked"]=> string(5) "admin" ["approved"]=> string(5) "admin" } } my problem can't value of json. let's example want value of poid dont know how. tried array wont work
here's code:
$items = json_decode($itemlist,true); echo $items['poid'];
use code:
$arr = json_decode($itemlist,true); echo $arr['data'][0]['poid'];
Comments
Post a Comment