File: /var/www/selfanalyse/counselor/search_user_api.php
<?php
include("../wp-config.php");
global $wpdb;
$PSY_USERS = $wpdb->prefix . PSY_USERS;
$PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
$searchTerm = $_GET['term'];
$userQuery = "select ID, user_login, user_email from $PSY_USERS where user_login LIKE '%".$searchTerm."%' OR user_email LIKE '%".$searchTerm."%' OR ID LIKE '%".$searchTerm."%' ";
$getUser = $wpdb->get_results($userQuery);
foreach($getUser as $usr)
{
$data[] = $usr->user_login;
}
if(!empty($data))
{
echo json_encode($data);
}
else
{
$data[] = "no user found";
echo json_encode($data);
}
?>