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 | + | } |