Problem sending array from Controller to Model in Codeigniter

Question

Good evening. For learning purposes I am building a CRUD script with the possibility for drag and drop rows using ajax. While sending the data from the controller to the model, my model function is unable to treat the array so I am encountering a problem.

Controller function:

public function from_ajax() {
    $this->load->model('model');
    $ordem = $this->input->post('ordem');
    parse_str($ordem, $array_ordenado);
    var_dump($array_ordenado); //testing only
    $resultado = $this->model->reordem($array_ordenado);
    echo json_encode($resultado);           
}

var_dump on controller output:

array(1) { ["teste"]=> array(4) { [0]=> string(1) "1" [1]=> string(1) "3" [2]=> string(1) "2" [3]=> string(1) "4" } }

Here is my model function:

public function reordem($data) {
    $this->db->select('page_order');
    $this->db->from('tbl_posts');
    return $this->db->update('tbl_posts', $data);
}

How would I treat this array dump on my model function so I can get the value I want (the ones inside "")?

I'm also getting this error: php/database error Thank you for your time!

Possible duplicate of stackoverflow.com/questions/34656326/… — Roshan
– Roshan, Commented Jan 26, 2019 at 1:06

PHPDave · Accepted Answer · 2019-01-26 01:35:28Z

1

You need to convert the array to a string

$array_ordenado['teste'] = implode(",", $array_ordenado['teste']);

The database doesn't support the array datatype. The code above would covert the field "teste"'s value from an array to a string with commas as delimiter.

edited Jan 26, 2019 at 1:35

answered Jan 26, 2019 at 1:26

PHPDave

9081 gold badge7 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Problem sending array from Controller to Model in Codeigniter

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related