last_error) {
echo ‘Error connecting to external database: ‘ . $external_db->last_error;
wp_die();
}

$search_name = sanitize_text_field($_POST[‘search_name’]);
$table_name = ‘members’; // Replace with your external table name

$results = $external_db->get_results(
$external_db->prepare(
“SELECT * FROM $table_name WHERE name LIKE %s”,
‘%’ . $external_db->esc_like($search_name) . ‘%’
),
ARRAY_A
);

if ($results) {
echo ‘

‘;
echo ‘

‘;
foreach ($results as $row) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
echo ‘

ID	Name	Email
‘ . $row[‘title’] . ‘	‘ . $row[‘first_name’] . ‘	‘ . $row[’email’] . ‘

‘;
} else {
echo ‘No data found.’;
}

wp_die();
}
?>