stuck upload file to mysql and folder path

[eluser]Unknown[/eluser]
Textfield entered into the database, but the name of the uploaded file is not entered into the database and upload paths, please enlighten

controller

Code:

function tambah(){
  

if($this->input->post('submit'))
{
  $config['upload_path'] = 'upload';
  $config['allowed_types'] = 'gif|jpg|png';
  
  $this->load->library('upload', $config);

  if ( ! $this->upload->do_upload() and !$this->session->userdata('user_name'))
  {
   $data["msg"] = "<b>No session!</b>";
   $error = array('error' => $this->upload->display_errors());
  }
  else
  {
   $userinput = $this->session->userdata('user_name');
   $data["msg"] = $userinput;
   // uploaded data
         $nama = $this->upload->data();
        //var_dump($nama);
      
        // pass argument into model and insert data
         $file_name = $nama['file_name'];
         $this->m_iklan->insertdata($file_name);
  
  }

    $this->load->view('iklan',$data);
  }
  }
  }

models

Code:

<?php
class M_iklan extends CI_Model
{
  function insertdata($file_name)
  {
$tipeiklan=$this->input->post ('pilih');
$judul=$this->input->post('judul');
$kategori=$this->input->post('kategori');
$harga=$this->input->post('harga');
$deskripsi=$this->input->post('deskripsi');
$nama=$this->upload->data();
$namafile=$file_name;
echo 'namafile='.$namafile.'<br>';
$postby=$this->input->post('postby');
$query=$this->db->query("INSERT INTO pasangiklan(tipe_iklan, judul, kategori,harga,deskripsi,filename,postby)VALUES('$tipeiklan','$judul','$kategori','$harga','$deskripsi','$namafile','$postby')");
  
  
  }
  
}
?&gt;

view

Code:

<?php
echo form_open_multipart('iklan/tambah');
?>
<td colspan="2">Upload Foto</td>
  <td class="medium info btn icon-left entypo icon-mail">&lt;input type="file" name="userfile"/&gt;&lt;/td>
&lt;?php echo form_close(); ?&gt;

[eluser]CroNiX[/eluser]
I believe the problem is the single quotes around your variable names here:

Code:

$query=$this->db->query("INSERT INTO pasangiklan(tipe_iklan, judul, kategori,harga,deskripsi,filename,postby)VALUES('$tipeiklan','$judul','$kategori','$harga','$deskripsi','$namafile','$postby')");

Try:

Code:

$data = array(
  'tipe_iklan' => $tipeilkan,
  'judul' => $judul,
  'kategori' => $kategori,
  'harga' => $harga,
  'desktipsi' => $deskripsi,
  'filename' => $namafile,
  'postby' => $postby
);
$this->db->insert('pasangiklan', $data);