insert

$query1  = $this->db->query("SELECT * FROM form WHERE type != '0'");
$result = $query1->result();

      $i=0;
      $len=count($result);

        $emprit= "INSERT INTO penilaian (no_urut,";
        foreach($result as $row){
            if($i == $len - 1) {
                $emprit .= "".$row->nama."";
                }else{
                    $emprit .= "".$row->nama.",";
                    }
                    $i++;
      }
      $emprit .= ") VALUES ('".$_POST['no_urut']."',";

        $a=0;
        foreach($result as $row){
            if($a == $len - 1) {

                if($row->type == 'file'){
                    $emprit .= "'".$filename."'";
                }else{
                    $emprit .= "'".$_POST[$row->nama]."'";
                        }

                }else{

                    if($row->type == 'file'){
                    $emprit .= "'".$filename."',";
                }else{
                $emprit .= "'".$_POST[$row->nama]."',";
                    }
                }
                    $a++;
            }
        $emprit .= ");";
      $query = $this->db->query($emprit);
      return $query;
      }