get_project($project_id); $users = explode(',',$project_data['users']); $users = array_unique($users); if(!empty($users)){ foreach($users as $user){ if(!empty($user)){ $user_role = sanitize_text_field(wp_unslash($_POST['wppm_select_user_role_'.$user])); $project_user = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wppm_project_users WHERE proj_id = %d AND user_id = %d", absint($project_id), absint($user) ) ); if(!empty($project_user)){ $project_user_id = absint($project_user->id); $values=array( 'role_id'=> absint($user_role), 'assigned_by'=>absint($current_user->ID) ); $wpdb->update($wpdb->prefix.'wppm_project_users', $values, array('id'=>$project_user_id)); }else{ $wpdb->insert( $wpdb->prefix . 'wppm_project_users', array( 'proj_id' => absint($project_id), 'user_id' => absint($user), 'role_id' => absint($user_role), 'assigned_by' =>absint($current_user->ID) ) ); } } } }