Getting id as Array in update_batch in codeigniter

Question

I am getting Id as Array when doing batch update. Not able to update data to my existing data table . Please help me

My Error Message is shown below Error Message as Image Format

Controller

public function update() 
{

$sID   = $this->input->post('test_id[]');
$sAmt  = $this->input->post('test_priceUpdt[]');
$sOfficeId = $this->input->post('fran_office_id');
$edited_test = array();
for ($i=0; $i < sizeof($sID); $i++)
		{
			if(!empty($sID[$i])) 
			$edited_test[$i] = array(
				'test_id' => $sID[$i],
				'test_priceUpdt' => $sAmt[$i],
				'fran_office_id' => $sOfficeId
			);
}

$edited_test = json_encode($edited_test); 
$data['franchise_tst_pkg'] = (object)$postData = array (
				array(
					'test_id' => $sID,
					't_franchise_price' => $edited_test
				)
			
 ); 
 if ($this->form_validation->run() === true) {
 $this->franchise_price_model->batchTestupdate($postData))
 }

}

View

<tr>
  <td>
    <input type="text" name="test_name[]" class="form-control" placeholder="" value="<?php echo $subject->test_name; ?>" disabled>
    <input type="hidden" name="test_id[]" class="form-control" placeholder="" value="<?php echo $subject->test_id; ?>">
  </td>
  <td>
    <input type="text" name="test_price[]" class="form-control" placeholder="" value="<?php echo $subject->test_price; ?>" disabled>
  </td>
  <td>
    <input type="text" name="test_priceUpdt[]" class="form-control" placeholder="" value="<?php echo $subject->test_price; ?>" id="test_priceEdt">
  </td>
</tr>

Modal

public function batchTestupdate($data = []) 
{ $this->db
        ->update_batch($this->table_test, $data , 'test_id');
}

Karlo Kokkak · Accepted Answer · 2018-05-29 07:28:28Z

1

The second parameter in your update_batch(..) function is structured wrongly.

Change:

$data['franchise_tst_pkg'] = (object)$postData = array (
                array(
                    'test_id' => $sID,
                    't_franchise_price' => $edited_test
                )

To:

$postData = array();
if(is_array($sID)){
    foreach($sID as $k=>$v){
        $postData[] = array(
            'test_id' => $v,
            't_franchise_price' => $edited_test
        );
    }
}
$data['franchise_tst_pkg'] = (object)$postData;

edited May 29, 2018 at 7:28

answered May 29, 2018 at 5:52

Karlo Kokkak

3,7344 gold badges21 silver badges35 bronze badges

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

12 Comments

Biswajit17 Over a year ago

Sir I am getting error message like this , after changed the code as your suggest -- A PHP Error was encountered Severity: Warning Message: Invalid argument supplied for foreach() Filename: branch/Franchise_price.php Line Number: 97

Karlo Kokkak Over a year ago

Updated my answer.

Biswajit17 Over a year ago

Sir , I done with this code and it working - if(!empty($sID)){ foreach($sID as $k=>$v ){ $postData[] = array( 'test_id' => $v, 't_franchise_price' => $edited_test ); } $data['franchise_tst_pkg'] = (object)$postData; }

Biswajit17 Over a year ago

Thank u sir for your kind support

Biswajit17 Over a year ago

Sir, 1 problem is occur. As for batch update we are expecting for one row one value will insert to the field but , here all values is updated to a single filed.For example, I have one row Id-17 , expecting only -- {"test_id":"17","test_priceUpdt":"1221","fran_office_id":"12"} for row id 17 . But receiving like this to one column(named-t_franchise_price) of the row ----- (shown in next comment )

|

Sambhaji Katrajkar · Accepted Answer · 2018-05-29 05:31:02Z

0

You can change model as:

public function batchTestupdate($data = []) 
{ $this->db
        ->update_batch($this->table_test, explode(',', $data) , 'test_id');
}

answered May 29, 2018 at 5:31

Sambhaji Katrajkar

4072 silver badges10 bronze badges

2 Comments

Biswajit17 Over a year ago

Not run the code . getting error like --- A Database Error Occurred You must use the "set" method to update an entry. Filename: models/branch/Franchise_price_model.php

Sambhaji Katrajkar Over a year ago

Try using var_dump($data) before the query. May be $data is coming insider array in array form

Collectives™ on Stack Overflow

Getting id as Array in update_batch in codeigniter

2 Answers 2

12 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related