Guest User

Untitled

a guest
Dec 7th, 2012
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. function buat_tabel()
  2. {
  3. $query = $this->db->query("SELECT * FROM form WHERE type != '0'");
  4. $result = $query->result();
  5. $q = "CREATE TABLE penilaian (";
  6. $q .= "no_urut varchar(100), ";
  7.  
  8. $i = 0;
  9. foreach ($result as $row)
  10. {
  11. if(++$i === $numItems) {
  12. $q .= $row->id_form . " " . "varchar(2550))";
  13. }
  14. else{
  15. $q .= $row->id_form . " " . "varchar(2550), ";
  16. }
  17. }
  18.  
  19. echo "<pre>";
  20. print_r($q);
  21. echo "</pre>";
  22.  
  23. //return $query;
  24. }
Advertisement
Add Comment
Please, Sign In to add comment