saving json value to mysql

Question

i have json file, and the content is list country but when i save to my database, just the first sentence example if i save "united states", in the database just "united" i hope to save all, but i can't

var url_country="<?=base_url()?>country.json";
var negara_list ="<option value=''></option>";
    $.getJSON(url_country, function(data) {
      $.each(data,function(key,val){
         negara_list += "<option value="+val+">"+val+"</option>";
      });
      $(".negara").html(negara_list);
  });

this is the structur database

and this is function to save in database

$form=$this->input->post('form');
    $data=array(
        'NIS'                 =>$form['nis'],
        'NISN'                =>$form['nisn'],
        'NAMA_LENGKAP'        =>$form['nama_lengkap'],
        'KEWARGANEGARAAN'     =>$form['kewarganegaraan'],
        'BAHASA'              =>$form['bahasa']
    );
    if($this->model->cekNis($form['nis'])->num_rows()==0 && $form['nisn']!=''){
        $this->db->insert('m_siswa',$data);
        $d['status']=1;
        $d['keterangan']='data berhasil dimasukan';
    }else{
        $d['status']=0;
        $d['keterangan']="data sudah pernah di tambahkan sebelumnya";
    }
    $d['data']=$data;
    $this->json($d);

show us your DB structure it might be size issue or something else — M.Hemant
– M.Hemant, Commented Apr 6, 2019 at 3:30
show me your $_POST data in var_dump($_POST); before the insert it to database — M.Hemant
– M.Hemant, Commented Apr 6, 2019 at 4:29

Hasta Dhana · Accepted Answer · 2019-04-06 10:16:30Z

1

You might want to encapsulate the val input value with quotes so it's sending the whole string :

negara_list += "<option value='"+val+"'>"+val+"</option>";

answered Apr 6, 2019 at 10:16

Hasta Dhana

4,6947 gold badges21 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

saving json value to mysql

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