[Plugin: Custom List Table Example] Help using plugin (error message with sql instead of example $da

(@redconservatory)

I’ve installed the plugin and it works great with the example data.

However, when I try to use my own sql in the prepare_items function I am getting an error:

Fatal error: Cannot use object of type stdClass as array

It seems like the example data is an array that contains arrays
i.e.

var $example_data = array(
            array(
                'ID'        => 1,
                'title'     => '300',
                'rating'    => 'R',
                'director'  => 'Zach Snyder'
            ),
            array(
                'ID'        => 2,
                'title'     => 'Eyes Wide Shut',
                'rating'    => 'R',
                'director'  => 'Stanley Kubrick'
            ),

But when I write:

global $wpdb;
		  $orderby = (!empty($_REQUEST['orderby'])) ? $_REQUEST['orderby'] : 'name'; //If no sort, default to title
          $sql = "SELECT * FROM wp_nc_location ORDER BY " . $orderby;
		  $data = $wpdb->get_results($sql);

My $data is an array that contains objects, print_r and gettype on $data reveals

data is Array ( [0] => stdClass Object ( …) [1] => stdClass Object ( …) )

Can anyone help?

http://ww.wp.xz.cn/extend/plugins/custom-list-table-example/

Viewing 2 replies - 1 through 2 (of 2 total)

Thread Starter redconservatory
(@redconservatory)

14 years, 9 months ago

Wait, it appears that switching it from an object to an array helped:

function column_default($item, $column_name){
$item = (array)$item;
}

Is that considered a ‘hack’ way of doing this, or is this all right?
Plugin Author Dutch van Andel
(@veraxus)

14 years, 9 months ago
Casting some types of objects as arrays is technically valid.

You can also specify what output type (object vs array) you want get_results() to return, so that no additional casting is necessary. Like so:
```
$data = $wpdb->get_results($sql, ARRAY_A);
```
This example returns an indexed array of all records, and the records themselves are associative arrays (just like the sample data used in the plugin).

Take a look at this codex entry for more ideas >>

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘[Plugin: Custom List Table Example] Help using plugin (error message with sql instead of example $da’ is closed to new replies.