id = $context['id']; $this->database = $context['database']; $this->db_name = $context['db_name']; $this->group_table = $context['group_table']; $this->group_table_add = $this->group_table."_add"; } public function form() { $id = $this->id; $database = $this->database; $db_name = $this->db_name; $group_table = $this->group_table; $group_table_add = $this->group_table_add; $groups_arr = array(); $get_current_groups = " SELECT group_add_id FROM $db_name$group_table_add WHERE group_id = '$id'"; $query = $database->getAll($get_current_groups); foreach($query AS $results_groups) $groups_arr[] = $results_groups['group_add_id']; ?>

User Types:

database; $id = $this->id; $db_name = $this->db_name; $group_table = $this->group_table; $group_table_add = $this->group_table_add; $insert_multiple = ""; $database->StartTrans(); $delete_groups = " DELETE FROM $db_name$group_table_add WHERE group_id = '$id'"; $database->query($delete_groups); if(isset($_POST['user_types'])) { foreach($_POST['user_types'] AS $user_types) $insert_multiple .= "('$id','$user_types'), "; $insert_multiple = substr($insert_multiple,0,strlen($insert_multiple)-2); $insert_multiple = " INSERT INTO $db_name$group_table_add (`group_id`,`group_add_id`) VALUES ".$insert_multiple; $database->query($insert_multiple); } $results = $database->CompleteTrans(); } } ?>