Inserting Mysql queries into array using wp_list_table class

Question

I try to make a plugin that can show a table (with rows) in wordpress by using the WP_List_Table class.

In my "students" table Ive got

Fname,Lname,school,Class

I've already found a example where they use arrays and typing manual everything to the table, which then looks like this

var $example_data = array(


array( 'ID' => 1,'booktitle' => 'Quarter Share', 'author' => 'Nathan Lowell', 
               'isbn' => '978-0982514542' ),
        array( 'ID' => 2, 'booktitle' => '7th Son: Descent','author' => ' Hutchins',
               'isbn' => '0312384378' ),
        array( 'ID' => 3, 'booktitle' => 'Shadowmagic', 'author' => 'John Lenahan',
               'isbn' => '978-1905548927' ),
        array( 'ID' => 4, 'booktitle' => 'The Crown Conspiracy', 'author' => 'Michael',
               'isbn' => '978-0979621130' ),
        array( 'ID' => 5, 'booktitle'     => 'Max', 'author' => 'Mark Jeffrey',
               'isbn' => '978-0061988929' ),
        array('ID' => 6, 'booktitle' => 'Jack Wakes Up: A Novel', 'author' => ' Har',
              'isbn' => '978-0307454355' )
    );

So I was wondering about is it possible to make an maybe more arrays where I can type Select * From table name? Or something like that?

Answer 1

I think you should rethink if creating a custom wp_list_table & stuff is the way to go.

I can tell from experience wp_list_table isn't fun to work with.

Besides I think (as far as I can judge here) a custom post type (or multiple) would be the way to go for you. This way you probably don't need queries.

Answer 2

You can make use of $wpdb to query database for arbitrary data via SQL.

I would be hesitant about this approach, as per other answer WP_List_Table is one of more questionable APIs. :) But if you get a start on data retrieval you can always reuse it in different context.

Answer 3

I´ve found a solution !

I´ve tried this and it´s working

private function table_data()
    {
        $data = array();


                $sqlget = "SELECT * FROM elever";
        $sqldata = mysql_query($sqlget) or die('error getting');
        while($row = mysql_fetch_array($sqldata, MYSQL_ASSOC)){

        $data[] = array(
                    'id'          => $row['id'],
                    'fornavn'       => $row['fornavn'],
                    'efternavn' => $row['efternavn'],
                    'skole'        => $row['skole'],
                    'klasse'    => $row['klasse'],
                    );

        }        


        return $data;
    }

It´s much easier than I´ve expected. Just SELECT * FROM elever and then explain where Im going to place the $row´s inside the array