How To Create Custom Table List In WordPress Admin Page

Introduction

  1. In this tutorial, you will learn how to add an admin table which is similar to admin posts or pages or comments table list
  2. Our table list is a merged list of all searchable post types post which are in draft mode i.e. not yet published or still work in progress posts
  3. Based on this tutorial you will learn how to implement the following features
    1. Search box
    2. Filter dropdown (Post type)
    3. Bulk action (Trash multiple posts at a time)
    4. Action quick links (Each post have edit, trash & view)
    5. Pagination
  4. Our custom table is a child class of the official table class: WP_List_Table
  5. We will explore each and every method in its individual section
  6. GitHub link to directly activate as a plugin while learn/play with the source
Sample Admin Table

Complete Source Code

Include Base Class

  1. In the complete source code gist (from now onwards we call it as main gist/file), you can find that we included our base class at line no: 24 though most of the time the class Drafts_List_Table directly extend the class WP_List_Table without the include once but WordPress functioning based on hooking process so sometimes our class may be called before hooked and globally included the WP_List_Table therefore it’s always better to check if it’s included or not and included the class file
  2. Also instead of hopping here and there, we can add the snippet which is related to the current context so we include partial code gist like this

Extend Base Class

  1. We extend our table class Drafts_List_Table from core WordPress class WP_List_Table at line no: 35 like this

Class Constant & Property

  1. The class Drafts_List_Table have one constant POSTS_PER_PAGE and one private property $allowed_post_types (main source code line no: 40)
  2. The POSTS_PER_PAGE is to stores an integer value which is the number of maximum posts to be shown in the table per page
  3. The property $allowed_post_types have an array of post types that can be queried and used to list out all posts that come under these post types

Constructor

  1. Our constructor (main source code line no: 52) is not that much fancy it has two simple statement one is a parent constructor call with three arguments singular, plural both for labeling purpose and ajax accepts boolean to decide whether HTTP calls are ajax based or not
  2. The other one calls the class method allowed_post_types() and stores the return value in the private property allowed_post_types

Get Allowed Post Types

  1. This method is placed inside this class is for tutorial purpose only (but for the real-life project, my suggestion is to create a utility or helper module which may have more helper classes like one for UI works, another API services, and other for wrapping commonly used DB queries likewise we can build n-number of classes for different common purposes)
  1. Let’s place the architectural suggestions aside and focus on this tutorial, the method allowed_post_types ( main source code line no: 71 ) will return the post types in the array
  2. Line no 9: by using WP core function get_post_types we fetch the post types in our web application here we pass an argument public with the boolean value true therefore it returns only publicly accessible post types
  3. Visit documentation for more details about the function get_post_types
  4. We unset the attachment post type to exclude that kind of posts from the table list and finally returned the remaining post type as an array

Convert Slug String To Human Readable

  1. Yes, this method (main source code line no: 85) also another good candidate for the utility method
  2. This method converts the slug to readable format i.e. it replaces all underscore symbol with white space and title cased the words

Convert Post Types Human Readable

  1. The method allowed_post_types_readable (main source code line no: 94) is iterate on all allowed post type and convert the post type’s slug into human-readable
  2. The inner working of this method is using the PHP function array_map we pass our human_readable as a callback that applies on each value of the private array property allowed_post_types
  3. The newly generated array is assigned to the variable $formatted and the same is returned

Create Custom WP_Query Object

  1. This method get_posts_object (main source code line no: 108) is the data fetching method of this custom admin table class
  1. As this method is a little lengthier let’s try to refer to each statement using its gist line number for easier understanding, here all the line numbers pointing to the gist get_posts_object.php
  2. Line no 9: fetching private array property allowed_post_types then assign it to the method’s local variable $post_types
  3. Line no 11: we declare a local variable $post_args which holds initial argument we pass to the WP_Query instance constructor call
  4. The $post_args is an associative array with the following key-value pair
    1. The key post_type holds the array of post types
    2. The key post_status holds the array of statuses to fetch here we pass only one value i.e. draft
    3. The key posts_per_page holds the integer value which controls how many posts to show on the page
  5. Line no 17: the local variable $paged is fetch page number from query string by using the PHP function filter_input to validate if it’s an integer or not using the filter id FILTER_VALIDATE_INT
  6. Line no 19: if the variable $paged having truth value then assign the value stored in $paged to $post_args array key paged
  7. Line no 23: the local variable $post_type is fetching post type (which we can use to filter the table to show only specific post type posts only) from query string by using the PHP function filter_input, sanitized the incoming string using the id FILTER_SANITIZE_STRING
  8. Line no 25: if the variable $post_type having truth value then assign the value stored in $post_type to $post_args array key post_type
  9. Line no 29: the variable $orderby accepts the table column name, as the value get from the query string it’s good to sanitize it
  10. WordPress provided a sanitize function sanitize_sql_orderby which is specifically deal with the order by clause with or without sort order
  11. Using the sanitize_sql_orderby function we sanitized the column name
  12. Line no 30: the filtered query string order’s value is passed to WordPress function esc_sql for escaping if any SQL injection character present
  13. Don’t accept user’s data blankly always do escaping, sanitization, and validation (skip sub-points if you need)
    1. Four years back got a chance to audit a project, the theme is adding a music file name and it’s CDN path to DB in the insert query without escaping or doing some other alternative like a prepared statement or PDO the source code inserts the file name
    2. When sending back the review to the concerned team they asked “why we need to escape? it’s just a filename of an MP3 file”
    3. I replied that we need to escape the filename because various bands have an apostrophe in their band name like Guns N' Roses therefore please escape the user input
    4. Thank god the application is Indian based music and running happily without unintentional SQL injection by the web application user because most of the Indian name or band name doesn’t have an apostrophe
    5. But the piece of advice is, in order to break your web application no need to hire a hacker just make it famous, and more user using it you will get to know why I’m insisting this
  14. Line no 32: if the variable $orderby is empty then set a default value date, then our posts are sorted by the date column
  15. Line no 36: if the variable $order is empty then set a default value desc, then our posts are sorted in descending order i.e. reverse chronological order
  16. Line no 40: assigning the order by value into the variable $post_args associative index orderby which we pass an argument to the WP_Query class first parameter
  17. Line no 41: this statement also similar to the previous one at line no 40
  18. Line no 43: in the variable $search fetching the query string s and passed it to the esc_sql function, this query string s only available when the user did a search
  19. Line no 44: as said in the previous point the s available only on search therefore before assigning we doing a conditional check to verify it’s not empty
  20. Line no 45: once the not empty condition passed we assign the search value into the associative index s of the variable $post_args
  21. Line no 48: finally we pass the $post_orgs to the class WP_Query and return the query class object

No Items Text Display

  1. The method no_items is overridden method of the base class WP_List_Table
  2. The purpose of this method is to display the information when no posts are available
  3. Line no 7: displaying the message about no posts which properly escaped for HTML and can be translated by using the WordPress function esc_html_e

Display Default Column

  1. Line no 10: the overridden method column_default is used to handle the column output
  2. Internally this method is called for each column this method accepts two parameters
    1. $item have all the current row’s columns values in associative key-value pair
    2. $column_name current column name
  3. Line no 11: declared and initialized the variable $result with empty string which we use to assign the column data to be shown
  4. Line no 12: switch statement will switch and create the column value based on the passed column name
    1. Line no 13: the date case is used to display date in two variant either by date if the post created date is more than one day else returns how human saying the date for e.g. 10 minutes ago
    2. Line no 14: using the WordPress template function get_the_time retrieve the post created time with formatting, get_the_time to learn more
    3. Line no 15: the function get_post_timestamp is used to retrieve the draft post published time in unix timestamp format, get_post_timestamp to learn more
    4. Line no 16: took the seconds difference of current unix timestamp (using PHP function time) and post created time and assign it to the variable $time_diff
    5. Line no 18: we’re checking the time is less than a day if so then display the time in human readable format using the WordPress formatting function human_time_diff
    6. Line no 22: else will show the date in the format Y/m/d
    7. The remaining cases ( author and type) are self explanatory
  5. Line no 37: return the variable $result which have the value to show in the specific column

Display Table Header

  1. The method get_columns ( main source code line no: 200 ) is an inherited must overridden method which is responsible for displaying the table headers
  2. For a quick view please see the snippet of the main source below
  1. This method simply returns the array of key-value pair of columns which have a set of an internal name as key and it’s display value as the value

Title Column Callback

  1. The method column_title (main source code Line no: 216) is used to display the HTML in the table column Title
  2. Internally this method is called by the parent method single_row_columns elseif is called the column_title method dynamically using the callback logic
  1. Line no 10: using the WordPress function get_edit_post_link we fetch the edit link for the current post in the table row looping flow
  2. Line no 11: get_permalink is used to fetch the current post permalink
  3. Line no 12: get_delete_post_link is used to fetch the delete link of the current post
  4. Line no 14 – 36: is simple HTML generation to display in the Title column by returning the variable $output, in these statements, the only thing we need to focus on is a template function _post_states
  5. The function _post_states is used to display post states as HTML for e.g. in the Introduction section if you see the sample image there are two things displayed in post states Draft, Elementor
  6. The state Draft is fetched by core WordPress whereas Elementor fetched by Elementor plugin to notate this post is formed by Elementor page builder

Column Checkbox

  1. The method column_cb (main source code line no: 251) is a simple method to display a checkbox in each row to select the post for bulk action like trashing an unneeded post

Build Table Data

  1. The method prepare_items (main source code line no: 264) is the core part to create the data for the table note here I’m saying about an array of information to show on the table, not the HTML design part
  1. Line no 9: called the method get_columns to fetch an array of column names to be shown in the header of the table
  2. Line no 10: called the method get_sortable_columns to fetch an array of sortable data in the format of an internal name as key and sorting option as a value such as array( column_internal_name, sorting_type) and assign it to the variable $sortable (don’t worry we will see more detail when we explain this method we will see the detailed way)
  3. Line no 13: the parent class property _column_headers accepts an array of arrays as in this order first array of columns to be shown in the table, second an array of columns which are hidden one, third array of sortable columns, fourth a string denote which column is primary one
  4. Line no 16: called the method process_bulk_action which is responsible for bulk actions like trashing the posts
  5. Line no 18: called the method get_posts_object which return the WP_Query instance with whatever filters and sorting options are applied, that instance is assigned to the variable $get_posts_obj
  6. Line no 20: check if the queried WP_Query instance have posts object using the method $get_posts_obj->have_posts()
  7. Line no 22: if posts are available then begin the looping while ( $get_posts_obj->have_posts() )
  8. Line no 24: the WP_Query method the_post is used to retrieve the next post internally which sets WP_Query property in_the_loop to true and retrieves the next post
  9. Line no 26: form the array of data therefore each index have an array of values to show in each row of the table, the formation of this array mostly using WordPress template functions
  10. Line no 34: the function wp_reset_postdata is used to reset the global variable $post to the main query’s current post after completing our custom query loop
  11. Line no 37: Assign our looped collection of table data to the parent class WP_List_Table property items therefore other methods that require data can access from this property
  12. Line no 39: the parent class method set_pagination_args is responsible to set pagination related information to the parent class property _pagination_args here we basically set up our pagination using three items
    1. total_items we pass the WP_Query property found_posts
    2. per_page we pass the WP_Query property post_count
    3. total_pages we pass the WP_Query property max_num_pages

Create Bulk Action Dropdown

  1. This method (main source code line no: 309) return array of key-value pairs which is used to show in the bulk action dropdown (if you like to know how the HTML formed by retrieving the return value of this method then please check bulk_actions method of the parent class WP_List_Table)

Process Bulk Actions

  1. This method process_bulk_action (main source code line no: 320) is used to do bulk actions like trashing the post likewise you can change the state of many posts (for e.g. change the set of posts from draft to publish) or process many posts data altogether (for e.g. trigger email to multi-selected users and change the custom state pending to invited)
  1. Line no 9: in the conditional statement, we check whether the current action is trash if so then execute the inner block
  2. Line no 10: the variable $post_ids hold get query value draft_id which is a collection of ids of the posts that need to be trashed
  3. Line no 12: verify is the variable $post_ids is an array
  4. Line no 13: convert all elements in the array into an integer value the reason is we received it from the get query therefore it will be a string and sometimes may have illegitimate data if the user intentionally add some junk data, here we iterated over each element using array_map
  5. Line no 15: we check this in if condition to confirm at least one element present in the $post_ids array
  6. Line no 16: pass all the ids to the WordPress function wp_trash_post which will trash the posts

Display Actions, Filters, and Pagination

  1. The method display_tablenav (main source code LINE NO: 341) is an overridden method that is responsible for displaying bulk actions, filters dropdown, and pagination which accepts a single argument with a value of either top or bottom based on that display the block of HTML at the top or bottom of the table
  1. Line no 12: created the navigation wrapper div with a dynamic class top or bottom based on the argument $which value
  2. Line no 14: verify is the table has items to display
  3. Line no 16: if has items then display the bulk action dropdown
  4. Line no 20: the method extra_tablenav is used to display additional filter we will see more detail about this method in the next section
  5. Line no 21: the method pagination is the parent class method that handles the pagination of the table

Extra Table Navigation HTML

  1. The method extra_tablenav (main source code line no: 367) is used to display additional filter controls here using the argument $which we controlled our filter to display only at the top of the table
  1. Line no 12: conditionally show our filter only at the top by checking the $which argument value is equal to top
  2. Line no 13: create a multidimensional associative array $drafts_dropdown_arg which we pass to the method html_dropdown we will see more about this method in the next section
  3. In the variable $drafts_dropdown_arg the options index has the value to show in the dropdown
  4. The container index has the class name to add to the dropdown component’s container div
  5. The next two indexes label and select represents its tag name, and it holds attributes of that tag in the inner array as key-value pair
  6. Line no 31: using the WordPress function submit_button echoes our submit button

UI Helper HTML Dropdown

  1. The method html_dropdown (main source code line no: 399) is used to generate HTML dropdown dynamically which is wrapped inside container div also to be clear this method needs to be added to the utility class Helper therefore the same method can be used in many other places too but for this tutorial, I added this inside the same class
  1. This method is simple string interpolation of passed argument into the custom HTML it’s pretty easy to understand, and I believe there is no need for a very detailed explanation

Sortable Column

  1. The method get_sortable_columns (main source code line no: 434) is an overridden method that simply returns an associative array
  1. Line no 11: the key is the column internal name and the value is an array that represents the behavior of the sorting
  2. Here we followed the format 'internal-name' => array( 'column', 'is_descending')
  3. The boolean false is no need to pass explicitly (see implementation logic) but for clarity here I passed instead of that if you alter it to true means on initial page load that column will be sorted in descending order

Column CSS

  1. This anonymous function (main source code line no: 448) inject custom HTML in the header part because we used the admin_head tag (this snippet only load in the admin part, not for the user-facing frontend pages if you would like to load on frontend then use the tag wp_head)
  1. Line no 9: fetch the current page name from the global get query string
  2. Line no 10: check the page name is not equal to all-drafts then bypass the upcoming execution by executing the void return statement
  3. Line no 15: add CSS width property to the column type i.e. post type column therefore which will give more space or real-estate to the column Title

Admin Menu For Drafts Table

  1. Using the hook admin_menu (main source code line no: 465) we hooked our drafts table admin page
  1. add_menu_page for more details about each argument and its purpose

Instantiate Draft Table

  1. The function bootload_drafts_table (main source code line no: 483) is a callback function attached to the add_menu_page, we pass this as a second from the last argument
  1. Line no 7: instantiate custom admin table class Drafts_List_Table
  2. Line no 12: pass draft table page menu slug all-drafts as hidden value therefore whenever the user does a submit action like searching, after every new request the filtered table is shown at the right page
  3. Line no 15: the method prepare_items is the workhorse of this class which handles all table data generation and processing logic
  4. Line no 16: search_box is the overridden method that accepts two parameters are a label of the submit button and an HTML id attribute for the search input field here we pass the first argument i.e. label as Search and the second argument i.e. id as search
  5. Line no 17: display is a parent class method that is responsible for displaying or echoing the HTML table with dynamic data, actions, filters, and pagination

Conclusion

  1. Through this tutorial, you learned how we can create a custom admin table on WordPress
  2. Simultaneously using this knowledge you understand how WordPress posts, pages, and comments table are formed
  3. Not only WordPress core many plugins like WooCommerce, SEO by Rank Math, and many other plugins more or less follow the same procedure therefore it’s easy for you to understand their admin table source
  4. By learning this tutorial now you’re comfortable with WordPress core class WP_List_Table