emprit

new

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