Modify of cellwidth, totally disable showing of columns

[md-20]

Hello!
I like your plugin a lot! It is the only one I found that can edit database tables and show them nicely as well as hide some columns 🙂

• I would like to change the width of each of the shown cells. How can I do that? Does it work with Slickgrid? Here width is implemented, but not from the database: SlickGrid Example.

• Also the auto edit function seems to be great. How can I implement it to this plugin?

• Most important: I would like to totally disable the view of some of the columns. The hidden columns still show, but shrinked.
  Thank you!

[bobbysmith007]

• This example shows how to resize columns: https://github.com/AccelerationNet/wp-db-table-editor/blob/master/examples/custom-buttons.js
• Adding auto_edit as an option would take some coding on the plugin, but you can probably set that after the fact in your own javascript using the DBTableEditor.grid variable.
• The easiest way to not show a column is to not select it. (That is use "select"=>"SELECT not, all, the, columns FROM table")

[md-20]

Wow, thank you for the quick answer! I managed to select my wanted columns, great!
The auto edit ist not that important.
But that resizing - im not familiar with writing scripts by myself. Do i just copy this in the functions.php after the table editor array?
Thank you so much :)
`<script>
if(typeof(NS) == 'undefined') NS={};
(function(){ "use strict";
var $ = jQuery;

NS._doUpdateWidths = function(){
// not sure why this was required, but I was getting infinite loops without its, so whatever
if(NS._widthUpdateDone) return;
NS._widthUpdateDone = true;
NS._widthTimeout = null;
var cs = DBTableEditor.grid.getColumns();
cs[0].width = 175;
DBTableEditor.grid.setColumns(cs);
};
</script>`