ขอตัวอย่าง json ajax post ด้วย CI ที่เป็น array หลายมิติหน่อยค่ะ

class Profile extends CI_Controller {
	public function gettype(){
		$rs=$this->db->query('select * from tb_type');
		echo json_encode($rs->result_array());
	}

$.ajax({ url: '/index.php/profile/gettype'})
.done(function(msg){
   var rs = $.parseJSON(msg);
   alert( rs.length()); 
}

public function msgbox_show(){

$sql= "SELECT*FROM chat_msgbox where msg_start ='".$this->session->userdata('UserName')."' and msg_dest = '".$this->input->Post('Dest')."'" or  msg_start ='".$this->input->Post('Dest')."' and msg_dest = '".$this->session->userdata('UserName')."' order by msg_no asc";
      
  $rs=$this->db->query($sql);
  echo json_encode($query->result_array());
 
}

                    
                 $.post("" + baseUrl +"/chatcontroller/msgbox_show",
                { 
                     Dest: id ,                    
                },
                  function(data){
                      var rs = $.parseJSON(data);
                      alert( rs.length()); 
                      for( var i=0; i<rs.length; i++){
                        alert(rs[i].msg_user)
                      }
                   }); 
                }

 public function msgbox_show(){
     $sql= "SELECT*FROM chat_msgbox where msg_start ='".$this->session->userdata('UserName')."' and msg_dest = '".$this->input->Post('Dest')."'"
             . "or  msg_start ='".$this->input->Post('Dest')."' and msg_dest = '".$this->session->userdata('UserName')."' order by msg_no asc";

     $array = array();
      $i = 0;
     $query = $this->db->query($sql);
  
   foreach($query->result_array()  as $row)
      {
          $array[$i][0]= $row["msg_user"];
          $array[$i][1]= $row["msg_message"];
      
          $i = $i+1;
      }

      echo json_encode($array);
  
     }
    

  $.post("" + baseUrl +"/chatcontroller/msgbox_show",
                { 
                     Dest: id ,                    
                },
                  function(data){
                      var rs = $.parseJSON(data);
                      for( var i=0; i<rs.length; i++){
                        alert(rs[i][0]);
                        alert(rs[i][1]);
                      }
                   }); 
                }