PHP Save array in database and skip data

Question

I need to save in the database category, for example, “a and b”, but to save the model in the database just “a”, skip the empty space and &.

This is an array:

$data = array('avenvu' => $_POST['avenvu'], 'brand' => $_POST['brand'], 'category' => $_POST['category'], 'description' => $_POST['description'], 'man_women_shop'=> $_POST['man_women_shop'], 'postdatetime' => date("Ymd H:i:s",time()), 'publish' => 1, 'user_id' => $this->session->userdata('user_id')); $result = $this->personal_closest->insertCloset($data); 

And this is the model:

 function insertCloset($data) { $this->db->insert('personal_closest',$data); } 

Answer 1

Change the insertCloset function:

 function insertCloset($data) { $personal['avenvu'] = $data['avenvu']; $personal['brand'] = $data['brand']; $personal['category'] = $data['category']; $personal['description'] = $data['description']; $personal['man_women_shop'] = $data['man_women_shop']; $personal['postdatetime'] = $data['postdatetime']; $personal['publish'] = $data['publish']; $personal['user_id'] = $data['user_id']; $this->db->insert('personal_closest',$personal); }