PHP Save array in database and miss data

Question

I need to save in database category like "a & b" but the model save in database just "a" miss the blank space and the &.

This is the array:

$data = array('avenvu'        => $_POST['avenvu'],
              'brand'         => $_POST['brand'],
              'category'      => $_POST['category'],
              'description'   => $_POST['description'],
              'man_women_shop'=> $_POST['man_women_shop'],
              'postdatetime'  => date("Y-m-d 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);
}

remove htmlspecialchars and try. and try to change column collasion to utf-8-bin. at the time of shoeing category htmlspecialchars will be needed. — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Apr 18, 2015 at 9:44

mantal · Accepted Answer · 2015-09-01 13:24:16Z

3

Change your 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);
}

edited Sep 1, 2015 at 13:24

mantal

1,2191 gold badge21 silver badges38 bronze badges

answered Apr 18, 2015 at 9:50

Sathya Baman

3,5348 gold badges48 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

PHP Save array in database and miss data

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