Javascript 数组到 PHP 到数据库

Question

如何使用 codeigniter 将数组从 javascript 传递到 Controller

这是我的代码:

查看:

function submitFunc(){
  var arrayName = ['John ' , 'Josh' , 'Steph'];
  var arraySerial = [ 123, 456 , 789];

$.ajax({
  type: 'post',
  data: {arrayName:arrayName, arraySerial: arraySerial }, //not sure of this code
  url: '<?= base_url()."mycontroller/insertData"?>',
  success: function(data){
  }
  });
}

在我的 Controller 中:

    public function insertData()
      {
          $data = array(
              'Name' =>$this->input->post('arrayName'),
              'Serial' =>$this->input->post('arraySerial '),
          );
          $this->db->insert('test',$data);
      }

尝试在数据库中实现类似的目标:

| Name  | Serial|| John  |   1   || Josh  |   2   || Steph |   3   |

Answer 1

您应该将数据编码为json格式，然后将其发送到 Controller

     function submitFunc(){
      var arrayName = ['John ' , 'Josh' , 'Steph'];
      var jsonName = JSON.stringify(arrayName);
      var arraySerial = [ 123, 456 , 789];
      var jsonSerial = JSON.stringify(arraySerial);

    $.ajax({
      type: 'post',
      data: {arrayName:jsonName, arraySerial: jsonSerial }, //not sure of this code
      url: '<?= base_url()."mycontroller/insertData"?>',
      success: function(data){
      }
      });
    }

在你的 Controller 中

  public function insertData()
  {
      $arrayName = $this->input->post('arrayName');
      $decodeName= json_decode($arrayName,true); // will return an array
      $arraySerial = $this->input->post('arraySerial ');
      $decodeSerial =  json_decode($arraySerial ,true); // will return an array
      for($i=0;$i<=count($decodeName);$i++){
      $data[] = array('Name'=>$decodeName[$i],'Serial'=>$decodeSerial[$i]);
      }

      $this->load->modelName($data);        
  }

在你的模型中

 public function modelName($data){
  $this->db->insert_batch('tablename', $data);
 }