Javascript array to PHP to database

Question

How to pass an array from javascript to controller using codeigniter

Here is my code:

view:

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){
  }
  });
}

and in my controller:

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

trying to achieve something like this n database:

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

What happend when you ran this code? You don't report of any problem... — Nytrix
– Nytrix, Commented Jan 25, 2017 at 7:55
This tutorial might be able to help your: w3schools.com/php/php_ajax_database.asp — Emil S. Jørgensen
– Emil S. Jørgensen, Commented Jan 25, 2017 at 8:13

Nishant Nair · Accepted Answer · 2017-01-25 08:57:56Z

1

You should encode the data in json format and then send it to 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){
      }
      });
    }

In you 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);        
  }

in your model

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

answered Jan 25, 2017 at 8:57

Nishant Nair

1,9971 gold badge14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nishant Nair Over a year ago

@StornFrial My pleasure.

mith · Accepted Answer · 2017-01-25 07:56:13Z

0

Try the following controller code to insert data:

$arrayName = $this->input->post('arrayName');
$Serial = $this->input->post('arraySerial');
$data = array();
foreach($arrayName as $key=>$name){
    $data[] = array('Name'=>$name,'Serial'=>$Serial[$key]);
}

$this->db->insert_batch('test', $data);

answered Jan 25, 2017 at 7:56

mith

1,7001 gold badge10 silver badges13 bronze badges

Collectives™ on Stack Overflow

Javascript array to PHP to database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related