Categories

  • Access & Security 95
  • Administration 171
  • Advertisement 92
  • Audio & Video 66
  • Author & Content 99
  • Comments 96
  • Communication 110
  • Communities & Forums 84
  • Development 47
  • E-Commerce 76
  • Email Management 53
  • Events & Calendars 80
  • Language 25
  • Map & Weather 44
  • Migration & Conversion 28
  • Miscellaneous 254
  • Mobile 15
  • Photos 143
  • Plugins 260
  • SEO & Site Speed 118
  • Social 186
  • Theme Enhancement 169



  • Add this plugin to a List

    You need to be logged in to add this plugin to your list.

    WP-DB-Table-Editor

    Add to List

    This is a WordPress plugin that allows direct excel-like editing of
    tables in your WordPress database. It’s goals are to provide useful,
    simple, flexible database table admin screens.

    It supports:

    • one table per admin screen, as many admin screens as desired
      • These are organized under a new “DB Table Editor” menu item
    • excel spreadsheet like interface using SlickGrid
    • Filter and Sort results
    • Add, Edit & Delete records
    • Custom buttons extensibility
    • Custom permissions per interface for viewing and editing
      (defaults to: edit_others_posts)

      • editing defaults to the same permission as viewing if not specified
    • CSV exports of filtered grid
    • Custom primary key names (but must be a single value / column)

    Adding an Interface on the fly

    If we go to look up a database table editor and we dont find it, but
    there is a function named dbte_create_$tbl that matches, we will call
    that function expecting it to return a dbte instance. This is useful
    in situations where we may not have the data for a table editor in all
    circumstances (EG: not every page has a member id, so only do it on
    that particular page).

    Adding an Interface from a plugin

    If you need to add an interface from a plugin, you should use the
    admin_menu action with a lower than default priority.

    eg: add_action( 'admin_menu', 'my_load_tables', -10 );

    Inside of the my_load_tables function you would include all the
    calls to add_db_table_editor

    Custom Buttons

    Buttons can be created by pushing functions into
    DBTableEditor.extraButtons. Each of these is a slick grid
    rowButtonFormatter and should return a string of html.

    eg:
    out += fn(row, cell, value, columnDef, dataContext);

    The button column width can be set by setting:
    DBTableEditor.buttonColumnWidth before the ready function is called

    Hooks / Actions

    • db-table-editor_enqueue_scripts is an action that will be called
      after enqueueing all plugin scripts and before enqueueing jsFile
      (if it exists)

      function dbTableEditorScripts(){
      wp_register_script('employee-table-extensions-js',
      get_stylesheet_directory_uri().'/employee-table.js',
      array('db-table-editor-js'));
      }
      add_action('db-table-editor_enqueue_scripts', 'dbTableEditorScripts');

    dbte_row_deleted, dbte_row_updated, dbte_row_inserted

    Called after a row is deleted, updated, or inserted passes

    `
    

    add_action(‘dbte_row_deleted’, ‘my_dbte_row_deleted’, 10, 2);

    function my_dbte_row_deleted($currentTable, $idRemoved){
    // do things
    }

    add_action(‘dbte_row_updated’, ‘my_dbte_row_upserted’, 10, 4);
    add_action(‘dbte_row_inserted’, ‘my_dbte_row_upserted’, 10, 4);

    function my_dbte_row_upserted($currentTable, $values, $columns, $indexedModified){
    // do things
    }

    `
    

    Shortcodes

    You can use a shortcode to include a dbte interface on a wordpress
    page. Please use with care.

    [dbte id=table-editor-id] – (id defaults to table)

    Caveats

    • Dont put an editable table editor on your public facing screens using the shortcode!

    Troubleshooting

    Feel free to ask support questions / open trouble tickets

    • https://wordpress.org/support/plugin/wp-db-table-editor
    • https://github.com/AccelerationNet/wp-db-table-editor/issues

    Advanced Examples

    Custom Javascript and Buttons on the table editor

    See: examples/custom-buttons-and-js.php
    examples/custom-buttons.js

    Shows how to add custom javascript to a report page and adds a custom
    load button on the grid

    CF7 DB Submit Plugin integration

    See: examples/cf7dbsubmit_integration.php

    This is not a fully runnable example, but should give good examples of

    • working cf7dbsubmit plugin
    • Custom save delete hooks
    • custom complex sql building with this plugin
    • sending notifications on edit of specific fields

    cf7dbsubmit stores its data in a “hashtable” format of:

    form, submit_time, field_name, field_value

    but we want to present this in a more excel fasion of each field being
    a column of our spreadsheet and each row being a different submission

    Contributers and Thanks

    • bobbysmith007 / Acceleration.net – Primary developer of plugin
    • nikomuse – i18n support
    Rate This Plugin

    Please Login to Rate this Plugin!

    Function

    Feature

    Support

    0 Votes
    Not Rated Yet

    Wordpress.org Stats

    Ratings4.2
    Votes15
    Downloads24,864
    Last Updated189 Days ago
    Published4 years ago

    Report Wrong Category!

    Do you think this Plugin belongs to another Category?

    What Category Should this Plugin belong to? *

    Reason *

    Create a Plugin List

    You need to be Logged in to Create a Plugin List.

    Submit A plugin

    You need to be logged in to submit a plugin.

    Help

    WPD is the unofficial online plugin directory of WordPress.

    An attempt has been made to list Only functional, active,efficient and up-to-date plugins.

    Categorized : Plugin are listed by category and subcategory based on functionality and uses. Here you can browse wordpress plugin from our neatly categorized plugin directory and sort the plugins by rating, votes, last updated and published and search plugins using tags.

    Search : Plugins can be searched by their functionality using multi-tag search and you can search plugins using their exact name although we are not ensuring Google like search accuracy.

    Create Plugin Lists : You will be able to create list of plugins and share them with Wordpress Community or you can keep them private and use them as a bookmarks.
    e.g. Plugins That I’ve Used on My Site, Best Event Management Plugins, Christmas Plugins etc.

    If you think certain awesome plugin is not in the directory then notify us through our Submit a Plugin page.

    Browsing the Plugin Directory

    Browse by Category

    In WPD, Plugins are categorized carefully. You can browse all the categories from the homepage or you can access the category lists from any page by clicking the button from the left of the website.


    Browse by Tags

    Each plugin listed in WPD is marked with useful tags. You can browse plugins by Tags from the All Tags page


    Searching in WPD

    Multi Tag Search

    You can search plugins using multiple tags. To perform a multi-tag search. Go to Homepage and then in the search field type any keywords or tags(comma separated) and then click on the search button. To search plugins from a selected category just select the category from the dropdown and type your tags.


    Searching a specific Plugin in WPD

    If you want to find a specific plugin in our directory, Go to Homepage and then select the "Search in Title" option. Then write the name of the plugin and click the search button to find the Plugin.


    Plugin Lists

    Whats a Plugin List

    Plugin Lists are user created lists of plugins. Any registered users can create Plugin Lists and share it with anyone or make it private.


    Why Create a plugin List?
    • Easy to keep track of your favourite and useful plugin.

    • Share list of plugins on blogs, social media or to a client.

    • Keep a track of what plugins you installed in which of your blogs by creating a list for each blog



    Creating a Plugin List

    To create a Plugin List, click the button from the left of the page; a popup box will appear. In the "List Name" field, put the name of the List. eg: Best Seo plugins for your site.
    In the Description field, put a few words describing the List.
    By default, lists are automatically published as public, which is visible to everyone. If you do not want others to see the List, select "Private" from the dropdown list. Then click the "Create List" button to create the list.


    Adding Plugins to your List

    To add a plugin to your List, go to a plugin page and click the "Add to List" button. A popup box will appear where you can select in which of your list you want to add this plugin. You can add a note if you want, this note will appear below the plugin in your list.
    P.S: You can only add plugins that are in our directory.

    Your Lists will appear in our "Plugin Lists" page when you set the list as "Public" and your list contains atleast 2 plugins.


    Editing your Lists

    When you are on your list page, notice there is a button on the top right corner of the page. Click it to edit the List Name and the List Description.


    Accessing All your Lists

    You can access all your Plugin lists by going to your profile and clicking the "Lists" tab.


    Removing your Lists

    You can remove your Plugin lists by going to your profile and clicking the "Lists" tab. on top right of each list click the button to remove the list completely.

    While tremendous effort has been put to keep this directory precise and complete, still errors and omissions are unavoidable and possible. We welcome any suggestions for corrections, deletions, and idea that might improve the overall experience.

    To submit a Feedback click the from the bottom right corner of the site.

    Register or log in to assess the record