You appear to be a bot. Output may be restricted
Description
Search the customers database via AJAX
Usage
$void = edd_ajax_customer_search();
Parameters
Returns
void
Source
File name: easy-digital-downloads/includes/ajax-functions.php
Lines:
1 to 43 of 43
function edd_ajax_customer_search() { global $wpdb; $search = esc_sql( sanitize_text_field( $_GET['s'] ) ); $results = array(); $customer_view_role = apply_filters( 'edd_view_customers_role', 'view_shop_reports' ); if ( ! current_user_can( $customer_view_role ) ) { $customers = array(); } else { $select = "SELECT id, name, email FROM {$wpdb->prefix}edd_customers "; if ( is_numeric( $search ) ) { $where = "WHERE `id` LIKE '%$search%' OR `user_id` LIKE '%$search%' "; } else { $where = "WHERE `name` LIKE '%$search%' OR `email` LIKE '%$search%' "; } $limit = "LIMIT 50"; $customers = $wpdb->get_results( $select . $where . $limit ); } if( $customers ) { foreach( $customers as $customer ) { $results[] = array( 'id' => $customer->id, 'name' => $customer->name . '(' . $customer->email . ')' ); } } else { $customers[] = array( 'id' => 0, 'name' => __( 'No results found', 'easy-digital-downloads' ) ); } echo json_encode( $results ); edd_die(); }