How do I auto-refresh database data in PHPMyAdmin? Because if we want to display updated database we have to refresh it manually.
Question posted in PhpMyAdmin
The official documentation can be found here.
The official documentation can be found here.
3
Answers
You can do something similar to the accepted solution of this question: How do I refresh a DIV content?
or this: PhpMyAdmin auto refresh MySQL table
I apologize if it still isnt what you require.
For MySql Table
Create a bookmark with this "admin":
1.Open phpMyAdmin,
2.Click on this bookmark (or run this snippet directly from URL bar)
3.Tables will be auto-refreshed every 10 seconds.
phpMyAdmin is not meant to automatically refresh the results page (imagine a situation of trying to read or edit a Browse page where new results are being inserted every few seconds, this would be quite frustrating or completely unusable). The solution linked to by virtualpanda (and copied here from there by sai) might be the best you can do for phpMyAdmin.
For refreshing a query presented in phpMyAdmin, look for the
Refresh
text under the SQL command, above the results page. This is the provided way of updating even a complex query.Remember that phpMyAdmin is meant as an administrative interface; if you’re displaying data to the end user you should write some custom solution where you can refresh the data if you prefer.