How to save data in JSON format using CodeIgniter?

Question

I have a value and the second one is the model part which is used for storing the data in JSON format. Here spam_management is the column in the table in that I have to store like [{delete:30}]. 30 is the value taken from the selected option. How can I do that?

public function update_selectedspmlds()
{
  $value = $this->input->post("value");
  $this->approval_model->update_selectedspmlds($value);
}

public function update_selectedspmlds($value)
{   
  $myJson = '{
    "delete": [{
      "lastName": '.$value.'
    }]
  }'; 
  $this->db->insert('pm1cti_details', ['spam_management' => $myJson]); 
}

Do it like this json_encode($myJson)

Grumpy
– Grumpy

2020-03-19 09:58:42 +00:00
Commented Mar 19, 2020 at 9:58 — Grumpy
– Grumpy, Commented Mar 19, 2020 at 9:58

Alok Mali · Accepted Answer · 2020-03-19 11:24:17Z

1

In order to create a JSON and store like [{delete:30}]. You need to save the value in a nested array and create a JSON by json_encode before saving it to the DB.

public function update_selectedspmlds($value) {   
  $myArray = array(
               array(
                'delete' => 30
              )
            );
  $myJson = json_encode($myJson);
  $this->db->insert('pm1cti_details', ['spam_management' => $myJson]); 
}

answered Mar 19, 2020 at 11:24

Alok Mali

2,8913 gold badges20 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

How to save data in JSON format using CodeIgniter?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related