[Feat]: Update table name filter to filter all pages of table names, not just page 1. #20556

phpMyAdmin version

5.2.3

Describe the feature

When searching for a table name, such as user; PMA will only search the active page of table names. Also, PMA only displays the pagination options and which page number I'm on (i.e. 1) when 0 characters are in the filter.

So, the current view is quite confusing and leads people to believe the table might've been deleted.

The only way PMA will find the user table with the filtering functionality is to click page 2, and there's no option to click page 2 in the event where I've already typed out "user" in the filter input element.

Describe the solution

Change the filter to search table names on all table name pages (both page 1 and page 2)

Describe the alternatives

Or show the page number when the filter is typed in, not just when the filter is empty and placeholder of HTML input element is showing.

Additional context

No response