How to disable inline edit on cell CLICK in PHPmyadmin

Question

In phpmyadmin when I browse table content CLICKing on certain cell starts this cell data editor.

How to avoid that? I didn't find no config options for this!

Answer 1

As of phpMyAdmin 4.0.0, double-click is now the new default for cell editing. If you want, you can disable cell editing completely OR change it to single 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 on $cfg['GridEditing']

Update: You can also simply adjust GridEditing from within the phpMyAdmin user interface by navigating to "Settings > Main Panel > Browse Mode > Grid editing: trigger action"

Answer 2

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

Answer 3

Old post I know but still receiving visits. Simply goto your settings in phpmyadmin:

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

Uncheck the first box in the page (Enable Ajax) You want to disable this.

No need to edit javascript files, seems quite extreme. I can only assume this option is recent.

Answer 4

The relevant part is find("td.data").click(function(c), if you'd return false here the editing would be stopped. I'm posting here because I found this page in a quest to maintain this functionality but on doubleclick.

If you also want to enable this on doubleclick just replace: find("td.data").click(function(c) with find("td.data").dblclick(function(c)

in /js/makegrid.js.