How to disable inline editing on CLICK cell in PHPmyadmin

Question

In phpmyadmin, when I look at the contents of a table, CLICKing in a specific cell launches this cell data editor.

How to avoid this? I did not find configuration options for this!

Answer 1

Change js / makegrid.js and replace $(c).is(".grid_edit") with $(c).is(".grid_edit**_no**")

Answer 2

Starting with phpMyAdmin 4.0.0, double-click now the new standard for cell editing. If you want, you can completely disable cell editing or change it by one click by adding a line to config.inc.php :

 $cfg['GridEditing'] = 'disabled'; //disabled cell/grid editing completely $cfg['GridEditing'] = 'click'; //single-click editing $cfg['GridEditing'] = 'double-click'; //default value. No need to specify this except for maybe readability purposes 

Source: phpMyAdmin Documentation at $ cfg ['GridEditing']

Update: You can also simply configure GridEditing from the phpMyAdmin user interface by going to "Settings"> "Main panel"> "Overview"> "Grid editing: trigger action"

Answer 3

The corresponding part is find("td.data").click(function(c) , if you return false, editing will stop. I am posting here because I found this page in the quest to support this functionality, but with a double click.

If you also want to enable this with a double click, simply replace: find("td.data").click(function(c) with find("td.data").dblclick(function(c)

in /js/makegrid.js.

Answer 4

An old post that I know, but still get visits. Just go to your settings in phpmyadmin:

 https://yoursite/3rdparty/phpMyAdmin/prefs_forms.php?form=Features 

Clear the first field on the page (Enable Ajax). You want to disable this.

No need to edit javascript files, it seems pretty extreme. I can only assume that this parameter is the last one.

Answer 5

Please note that the following is not the correct solution to the problem, but is a workaround.

although I don't consider it a flaw, but it may limit some other phpmyadmin functions

• go to js directory in your phpmyadmin directory
• rename makegrid.js to something like mmakegrid.js