input

<?php
class  Input_nilai_model extends  CI_Model{
        function input_nilai() {
            //hitung value menurut kriteria penilaian
            $q = mysql_query("SELECT * FROM sub_kriteria");
            foreach ($q->result() as $row)
            {
                    $val = $this->input->post($row->nama);
            }
            echo "$val";
            //insert
            $kriteria = mysql_query("SELECT * FROM kriteria");
            $jk = mysql_num_rows($kriteria);
            foreach ($kriteria->result() as $row1){
                $input = "INSERT into nilai_gap_".$row1->id_kriteria." ( ";

                $sub = mysql_query("SELECT * FROM sub_kriteria where id_kriteria = '".$wk['id_kriteria']."'");
                foreach ($sub->result() as $row){
                    $i = 0;
                    $len = count($sub);
                            for($i == $len - 1) {
                                $input .= $row->nama;
                                }else {
                                    $input .= $ws['nama'].",";
                                    }
                                    $i++;
                }
                $input .= ") VALUES ( ";
                    $i = 0;
                    for($i == $len - 1) {
                        $input .= "'".$this->input->post($row->nama)."'";
                        }else {
                            $input .= " '".$this->input->post($row->nama)."',";
                        }
                        $i++;
                    $input .= ");";
                        }
                echo "<pre>$input</pre>";

            }
}
?>