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

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

Java, LWJGL, OpenGL 1.1, decoding BufferedImage to Bytebuffer and binding to OpenGL across classes -

javascript - addthis share facebook and google+ url -