View difference between Paste ID: wxxX6U6P and DQQgXs9b
SHOW: | | - or go back to the newest paste.
1
function buat_tabel()
2-
{
2+
3-
	$query  = $this->db->query("SELECT * FROM form WHERE type != '0'");
3+
            $query1  = $this->db->query("SELECT * FROM form WHERE type != '0'");
4-
	$result = $query->result();
4+
            $result = $query1->result();
5-
	$q		= "CREATE TABLE penilaian (";
5+
            $q              = "CREATE TABLE penilaian (";
6-
	$q		.= "no_urut varchar(100), ";
6+
            $q         .= "no_urut varchar(100), ";
7-
 
7+
			
8-
	$i = 0;
8+
			$i = 0;
9-
	foreach ($result as $row)
9+
			$len = count($result);
10
            foreach ($result as $row)
11-
    	if(++$i === $numItems) {
11+
            {
12-
			$q .= $row->id_form . " " . "varchar(2550))";
12+
				if($i == $len - 1) {
13-
			}
13+
                    $q .= $row->id_form . " " . "varchar(2550)";
14-
		else{
14+
                }else{
15-
			$q .= $row->id_form . " " . "varchar(2550), ";
15+
					$q .= $row->id_form . " " . "varchar(2550), ";	
16-
		}
16+
                }
17-
    }
17+
				
18-
18+
				$i++;
19-
    echo "<pre>";
19+
            }
20-
    print_r($q);
20+
			$q .= ");";
21-
    echo "</pre>";
21+
			$query = $this->db->query($q);
22-
22+
            return $query;
23-
	//return $query;
23+
    }