Member List'; // Check if search string is in address if ( !empty( $_POST['searchbt'] ) ) { $search_string = sanitize_text_field($_POST['searchbt']); $search_mode = true; } else { $search_string = 'Search...'; $search_mode = false; } // Prepare output to be returned to replace shortcode $output .= '
'; $valid = false; if( isset( $_POST['ammp_renewal_captcha'] ) ) { $_POST['ammp_renewal_captcha'] = sanitize_text_field($_POST['ammp_renewal_captcha']) ; // Variable used to determine if submission is valid // Check if captcha text was entered if (empty($_POST['ammp_renewal_captcha'])) { $abortmessage = 'Captcha code is missing. Try again and '; $abortmessage .= 'provide the code.'; //wp_die($abortmessage); //exit; } else { // Check if captcha cookie is set if (isset($_COOKIE['Captcha'])) { list( $hash, $time ) = explode('.', $_COOKIE['Captcha']); // The code under the md5's first section needs to match // the code entered in easycaptcha.php if (md5('SDUVOIAUBDVOBODFBY' . $_REQUEST['ammp_renewal_captcha'] . $_SERVER['REMOTE_ADDR'] . $time) != $hash) { $abortmessage = ' Captcha code is wrong. '; $abortmessage .= 'try to get it right or reload '; $abortmessage .= 'to get a new captcha code.'; //wp_die($abortmessage); //exit; } elseif (( time() - 5 * 60) > $time) { $abortmessage = 'Captcha timed out. Please try again '; $abortmessage .= '(reload the page and submit again)'; //wp_die($abortmessage); //exit; } else { // Set flag to accept and store user input $valid = true; } } else { $abortmessage = 'No captcha cookie given. Make sure '; $abortmessage .= 'cookies are enabled.'; //wp_die($abortmessage); //exit; } } } // Prepare query to retrieve members from database $member_query = 'select * from ' . $wpdb->get_blog_prefix(); $member_query .= 'amms_members where'; // Add search string in query if present if ( $search_mode && $valid) { $search_term = '%' . $search_string . '%'; $member_query .= " (name like '%s' "; $member_query .= "or memberid like '%s' "; $member_query .= "or institution like '%s' "; $member_query .= "or department like '%s' "; $member_query .= "or city like '%s' "; $member_query .= "or province like '%s' "; $member_query .= "or researchfocus like '%s' ) and "; } elseif ( $search_mode && !$valid) { $output .= '

'.esc_html($abortmessage).'

'; $search_term = ''; } else { $search_term = ''; } $member_query .= " (active = '1') ORDER BY DATEDIFF(`expirationdate`, CURDATE() ) ASC"; $members_data = $wpdb->get_results( $wpdb->prepare( $member_query, $search_term, $search_term, $search_term, $search_term, $search_term, $search_term, $search_term ), ARRAY_A ); $output .= '

ACTIVE Member

'; $output .= ''; // Check if any members were found if ( $members_data ) { $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; // Create row in table for each member foreach ( $members_data as $member_data ) { $output .= ''; $output .= ''; $output .= ''; if($member_data['active'] == 1) $output .= ''; } } else { // Message displayed if no members are found $output .= ''; $output .= ''; } $output .= '

Name	Institution \| Department \| City \| Province \| Research Focus	Status
' . esc_html($member_data['name']) . ' '; if( $member_data['photo'] != '') { $output .= ''; $output .= 'Member Since: ' . esc_html($member_data['membersince']) . '	' . esc_html($member_data['institution']) . ' , ' . esc_html($member_data['department']) . ' ' . esc_html($member_data['city']) . ' , ' . esc_html($member_data['province']) . ' ' . esc_html($member_data['researchfocus']) . '	Active Member '; else $output .= '	EXPIRED '; $output .= 'Expiration Date: ' . esc_html($member_data['expirationdate']) . '
No Members to Display

'; // Prepare query to retrieve members from database $member_query = 'select * from ' . $wpdb->get_blog_prefix(); $member_query .= 'amms_members where'; // Add search string in query if present if ( $search_mode && $valid) { $search_term = '%' . $search_string . '%'; $member_query .= " (name like '%s' "; $member_query .= "or memberid like '%s' "; $member_query .= "or institution like '%s' "; $member_query .= "or department like '%s' "; $member_query .= "or city like '%s' "; $member_query .= "or province like '%s' "; $member_query .= "or researchfocus like '%s' ) and "; } elseif ( $search_mode && !$valid) { $output .= '

'.esc_html($abortmessage).'

'; $search_term = ''; } else { $search_term = ''; } $member_query .= " (active = '0') ORDER BY DATEDIFF(`expirationdate`, CURDATE() ) DESC"; $members_data = $wpdb->get_results( $wpdb->prepare( $member_query, $search_term, $search_term, $search_term, $search_term, $search_term, $search_term, $search_term ), ARRAY_A ); $output .= '

EXPIRED Member

Name	Institution \| Department \| City \| Province \| Research Focus	Status
' . esc_html($member_data['name']) . ' '; if( $member_data['photo'] != '') { $output .= ''; $output .= 'Member Since: ' . esc_html($member_data['membersince']) . '	' . esc_html($member_data['institution']) . ' , ' . esc_html($member_data['department']) . ' ' . esc_html($member_data['city']) . ' , ' . esc_html($member_data['province']) . ' ' . esc_html($member_data['researchfocus']) . '	Active Member '; else $output .= '	EXPIRED '; $output .= 'Expiration Date: ' . esc_html($member_data['expirationdate']) . '
No Members to Display

'; // Return data prepared to replace shortcode on page/post return $output; }

Search Member:
Re-type the following text '; $output .= ''; $output .= '