Robin S Posted October 28, 2018 Share Posted October 28, 2018 This is something that has been bugging me for ages and I'm hoping somebody knows a simple trick I'm missing. I am viewing a table in phpMyAdmin - in this case the "fields" table: I want to take a closer look at the data column in the link_url row, so I open the row for editing via the "Edit" link: Now in the PW admin I make some changes to the link_url field settings, and want to check the results in the table row. So I want to reload the edit row view to see the changes... but the URL that phpMyAdmin uses for this view is http://localhost/phpmyadmin/tbl_row_action.php - there's nothing specific to the currently edited row in the URL, and when I refresh the page I am sent back to the phpMyAdmin landing page. I figure there has got to be some way to refresh the edit row view without this happening - isn't refreshing a view like this a really common need? Maybe there is some button in the interface that reloads the edit view that I am missing? Any tips much appreciated. P.S. I know I can show non-truncated column values in the table view and also edit column values in the table view, but the interface is much more crowded and busy here than it is in the edit row view, so it's not a great substitute. Link to comment Share on other sites More sharing options...
Jonathan Lahijani Posted October 28, 2018 Share Posted October 28, 2018 Try Adminer instead:https://www.adminer.org/ It's only one file. phpmyadmin feels bloated compared to it. 2 Link to comment Share on other sites More sharing options...
Robin S Posted October 29, 2018 Author Share Posted October 29, 2018 3 minutes ago, Jonathan Lahijani said: Try Adminer instead I've just been looking at that, thanks. Bummer that it can no longer be easily loaded as a PW page or Process module though: Link to comment Share on other sites More sharing options...
kongondo Posted October 29, 2018 Share Posted October 29, 2018 (edited) Use either of the the Go buttons at the bottom in conjunction with the dropdown and then, selecting 'Go back to this page'. This will reload the edit screen BUT not save the data as long as you haven't made any changes directly in phpMyAdmin. Unfortunately, the 'Go back to this page' does not seem to stick if you leave and come back to the edit page. PS: You can also resize columns :-). PS2: For connecting to remote DB, I've not come across anything that beats HeidiSQL. Locally I use phpMyAdmin, but Heidi for all remote connections. Edited October 29, 2018 by kongondo 1 Link to comment Share on other sites More sharing options...
Robin S Posted October 29, 2018 Author Share Posted October 29, 2018 7 hours ago, kongondo said: This will reload the edit screen BUT not save the data as long as you haven't made any changes directly in phpMyAdmin. It's a bit scary submitting an edit form with data you know is out of date, but you're right that it doesn't save the data if it's unchanged. So that's a good solution, thanks! Link to comment Share on other sites More sharing options...
kongondo Posted October 29, 2018 Share Posted October 29, 2018 1 hour ago, Robin S said: It's a bit scary submitting an edit form with data you know is out of date True. Did you manage to check their docs? Are they silent on the issue? Link to comment Share on other sites More sharing options...
Robin S Posted October 31, 2018 Author Share Posted October 31, 2018 On 10/29/2018 at 11:18 PM, kongondo said: Did you manage to check their docs? Are they silent on the issue? Am going to ditch phpMyAdmin in favour of Adminer. It's a great tool, especially when used in the Adminer Custom theme/plugin bundle: https://github.com/pematon/adminer-custom The JSON preview plugin rules: No problems with refeshing row edit views in Adminer. Was working on my own PW integration but I think @adrian might have something exciting for us all soon... ? 1 1 Link to comment Share on other sites More sharing options...
kongondo Posted October 31, 2018 Share Posted October 31, 2018 1 minute ago, Robin S said: Am going to ditch phpMyAdmin in favour of Adminer. I can't recall atm, but I tried Adminer in the past and something didn't work so I ditched it. 3 minutes ago, Robin S said: Was working on my own PW integration but I think @adrian might have something exciting for us all soon... ? Aha. Keenly watching this...? 1 1 Link to comment Share on other sites More sharing options...
adrian Posted October 31, 2018 Share Posted October 31, 2018 Here's a teaser - no prizes for guessing what the panel wrapping the interface is from ? 1 Link to comment Share on other sites More sharing options...
adrian Posted November 1, 2018 Share Posted November 1, 2018 Just released the new Tracy Adminer panel: https://processwire.com/talk/topic/12208-tracy-debugger/?do=findComment&comment=175420 1 Link to comment Share on other sites More sharing options...
Recommended Posts