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

User Types:	getAll($get_groups); foreach($query AS $results_groups) { $group_id = $results_groups['id']; $name = $results_groups['name']; ?> selected="selected" >

db_name; $id = $this->id; $group_table = $this->group_table; $group_table_upgrade = $this->group_table_upgrade; $insert_multiple = ""; $database->StartTrans(); $delete_groups = " DELETE FROM $db_name$group_table_upgrade WHERE group_id = '$id'"; $database->query($delete_groups); if(isset($_POST['upgrade_groups'])) { foreach($_POST['upgrade_groups'] 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_upgrade (`group_id`,`group_add_id`) VALUES ".$insert_multiple; $database->query($insert_multiple); } $results = $database->CompleteTrans(); } } ?>