Support » Plugin: Custom List Table Example » Database query instead of example array

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Matt van Andel


    Hey Erixz,

    You use the $wpdb global object to interact with the WordPress database.

    You can find a very detailed breakdown (with examples!) on the WordPress Codex here:

    If you are new to plugin development with WordPress, I would encourage you to read the excellent (and free) WordPress Plugin Developer’s Handbook, which covers a lot of basics like working with database queries in WordPress.

    Hi Erixz,
    I had the same problem.
    I solved it by inserting a piece of code after “$this->process_bulk_action();
    The code:
    $query = “SELECT * FROM {$wpdb->posts}”;
    $totalitems = $wpdb->query($query);
    $this->items = $wpdb->get_results($query);

    After that you should create a function “display_rows()”
    Please refer to this website
    for the details about the “display_rows()” function. Make sure you read the comments because there are some mistakes in the code and users fixed them.

    Line number 383

    $data = $this->example_data;

    $sql = “SELECT ID,title,rating,director FROM wp_films”;
    $data = $wpdb->get_results($sql,ARRAY_A);

    Obviously you’ll need to create the database table

    I hope this helps someone

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database query instead of example array’ is closed to new replies.