Group.php 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. <?php
  2. require_once("DataBase/database.php");
  3. class Group
  4. {
  5. function Group()
  6. {
  7. $this->db = new Database();
  8. }
  9. function create($group_id, $value)
  10. {
  11. $query = "INSERT INTO ".$this->db->group_table." VALUES('".$group_id."'";
  12. for($i = 0; $i < count($value); $i++)
  13. $query .= ", '".$value[$i]."'";
  14. $query .= ")";
  15. $this->db->query($query);
  16. }
  17. function update($group_id, $value)
  18. {
  19. $query = "UPDATE ".$this->db->group_table." SET ";
  20. $query .= "name='".$value[0]."' ";
  21. $query .= "WHERE group_id='".$group_id."'";
  22. $this->db->query($query);
  23. }
  24. function delete($group_id)
  25. {
  26. $query = "DELETE FROM ".$this->db->group_table." WHERE group_id='$group_id'";
  27. $this->db->query($query);
  28. }
  29. function get($group_id = "", $row_names = array(), $search = "")
  30. {
  31. if($group_id == "")
  32. {
  33. if(count($row_names) == 0)
  34. $query = "SELECT * FROM ".$this->db->group_table;
  35. else
  36. {
  37. $query = "SELECT ".$row_names[0];
  38. for($i = 1; $i < count($row_names); $i++)
  39. $query .= ", ".$row_names[$i];
  40. $query .= " FROM ".$this->db->group_table;
  41. }
  42. if($search != "")
  43. $query .= " WHERE ".$search;
  44. $query .= " ORDER BY group_id ASC";
  45. return $this->db->fetchRows($this->db->query($query));
  46. }
  47. else
  48. {
  49. $query = "SELECT * FROM ".$this->db->group_table." WHERE group_id='".$group_id."' ORDER BY group_id ASC";
  50. return $this->db->fetchRows($this->db->query($query));
  51. }
  52. }
  53. }
  54. ?>