prefix . 'rbrurls_redirect'; $role_type=sanitize_text_field($_POST['role_userrole']); $url_login_dropdown=sanitize_text_field($_POST['url_login_dropdown']); $url_login_textbox=sanitize_text_field($_POST['url_login_textbox']); $url_logout_dropdown=sanitize_text_field($_POST['url_logout_dropdown']); $url_logout_textbox=sanitize_text_field($_POST['url_logout_textbox']); $adminbar=isset($_POST['adminbar']); if ($adminbar == null ) { $adminbar = "no"; } else { $adminbar=sanitize_text_field($_POST['adminbar']); } $restrictdash=isset($_POST['restrictdash']); if ($restrictdash == null ) { $restrictdash = "no"; } else { $restrictdash=sanitize_text_field($_POST['restrictdash']); } if (!empty($url_login_dropdown)||!empty($url_login_textbox)) { $result= $wpdb->insert( $rbrurls_redirect, array( 'role_type' => $role_type, 'url_login_dropdown' => $url_login_dropdown, 'url_login_textbox'=> $url_login_textbox, 'url_logout_dropdown' => $url_logout_dropdown, 'url_logout_textbox'=> $url_logout_textbox, 'adminbar' => $adminbar, 'restrict_dashboard'=> $restrictdash ), array( '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ); } else { echo ""; } } } if( isset( $_POST['role_url_update'] ) ) { if (isset( $_POST['url_redirect'] ) && wp_verify_nonce($_POST['url_redirect'], 'add-urls') ) { $rbrurls_redirect = $wpdb->prefix . 'rbrurls_redirect'; $role_type=sanitize_text_field($_POST['role_userrole']); $url_login_dropdown=sanitize_text_field($_POST['url_login_dropdown']); $url_login_textbox=sanitize_text_field($_POST['url_login_textbox']); $url_logout_dropdown=sanitize_text_field($_POST['url_logout_dropdown']); $url_logout_textbox=sanitize_text_field($_POST['url_logout_textbox']); $adminbar=isset($_POST['adminbar']); if ($adminbar == null ) { $adminbar = "no"; } else { $adminbar=sanitize_text_field($_POST['adminbar']); } $restrictdash=isset($_POST['restrictdash']); if ($restrictdash == null ) { $restrictdash = "no"; } else { $restrictdash=sanitize_text_field($_POST['restrictdash']); } //if (!empty($url_login_dropdown)||!empty($url_login_textbox)) //{ $wpdb->update( $rbrurls_redirect, array( 'url_login_dropdown' => $url_login_dropdown, 'url_login_textbox'=> $url_login_textbox, 'url_logout_dropdown' => $url_logout_dropdown, 'url_logout_textbox'=> $url_logout_textbox, 'adminbar' => $adminbar, 'restrict_dashboard'=> $restrictdash ), array( 'role_type' => $role_type ) ); //} //else { // echo ""; //} } } global $wp_roles; $results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}rbrurls_redirect" ); $arr = array(); foreach ( $results as $result) { //$array = [$result->role_type]; array_push($arr, $result->role_type); } ?>

roles as $key=>$value ): $urls = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}rbrurls_redirect WHERE `role_type` = '$key'" ); if( !empty( $urls[0]) ){ $fetchlogindrop = $urls[0]->url_login_dropdown; $fetchlogintext = $urls[0]->url_login_textbox; $fetchlogoutdrop = $urls[0]->url_logout_dropdown; $fetchlogouttext = $urls[0]->url_logout_textbox; $fetchadminbar = $urls[0]->adminbar; $fetchrestrict_dashboard = $urls[0]->restrict_dashboard; $fetchrole_type= $urls[0]->role_type; } ?>