db = new Database(); } function create($assistant_id, $value) { $query = "INSERT INTO ".$this->db->assistant_table." VALUES('".$assistant_id."'"; for($i = 0; $i < count($value); $i++) $query .= ", '".$value[$i]."'"; $query .= ")"; $this->db->query($query); } function update($assistant_id, $value) { $query = "UPDATE ".$this->db->assistant_table." SET "; $query .= "prename='".$value[0]."', "; $query .= "postname='".$value[1]."', "; $query .= "street='".$value[2]."', "; $query .= "streetnumber='".$value[3]."', "; $query .= "plz='".$value[4]."', "; $query .= "city='".$value[5]."', "; $query .= "telephone='".$value[6]."', "; $query .= "telefax='".$value[7]."', "; $query .= "email='".$value[8]."', "; $query .= "tax_number='".$value[9]."', "; $query .= "blz='".$value[10]."', "; $query .= "bank_account='".$value[11]."', "; $query .= "additional='".$value[12]."', "; $query .= "utax_id='".$value[13]."', "; $query .= "bank_name='".$value[14]."', "; $query .= "bill_ext='".$value[15]."' "; $query .= "WHERE assistant_id='".$assistant_id."'"; $this->db->query($query); } function delete($assistant_id) { $query = "DELETE FROM ".$this->db->assistant_table." WHERE assistant_id='$assistant_id'"; $this->db->query($query); } function get($assistant_id = "", $row_names = array(), $search = "") { if($assistant_id == "") { if(count($row_names) == 0) $query = "SELECT * FROM ".$this->db->assistant_table; else { $query = "SELECT ".$row_names[0]; for($i = 1; $i < count($row_names); $i++) $query .= ", ".$row_names[$i]; $query .= " FROM ".$this->db->assistant_table; } if($search != "") $query .= " WHERE ".$search; $query .= " ORDER BY assistant_id ASC"; return $this->db->fetchRows($this->db->query($query)); } else { $query = "SELECT * FROM ".$this->db->assistant_table." WHERE assistant_id='".$assistant_id."'"; $query .= " ORDER BY assistant_id ASC"; return $this->db->fetchRows($this->db->query($query)); } } } ?>