Wordpress $wpdb query issue

Question

I am making a custom counter as a wordpress plugin and I hav a little problem with $wpdb This is the query that fails:

private function getMedlemmerfromDB(){
    global $wpdb, $table_prefix;
    $wpdb->plugin_medlemsteller = $table_prefix . "plugin_medlemsteller";
    $fromdb=$wpdb->get_var("SELECT medlemmer FROM $wpdb->plugin_medlemsteller WHERE mID=(SELECT MAX(mID) FROM $wpdb->plugin_medlemsteller)");
    return $fromdb;
}

i do not know what $table_prefix is set to. just hoping it's empty.

in my widget function:

public function widget( $args, $instance ) {
        $medlemmer=getMedlemmerfromDB();
             ...

This fails, and the plugin (witch is still active) doesn't show.

The query works fine, but when I implement it in my plugin it causes the widget to crash.

Hope some one can help me out.

-Krister

birgire · Accepted Answer · 2013-03-02 12:18:51Z

2

You can try to replace

$medlemmer=getMedlemmerfromDB();

with

$medlemmer=$this->getMedlemmerfromDB();

if widget() and getMedlemmerfromDB() are methods of the same class.

answered Mar 2, 2013 at 12:18

birgire

11.4k1 gold badge35 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

birgire Over a year ago

ok great it worked out for you and good luck with your plugin (it's good karma to vote/accept any helpful answers ;-)

RRikesh · Accepted Answer · 2013-03-02 10:34:43Z

0

You did not define $wpdb->plugin_medlemsteller. Only default WordPress tables can be accessed like that.

You need to define it first:

$wpdb->plugin_medlemsteller = $wpdb->prefix . "plugin_medlemsteller";

answered Mar 2, 2013 at 10:34

RRikesh

14.5k5 gold badges55 silver badges74 bronze badges

1 Comment

Faux_Clef Over a year ago

so if I do it in a function like this: [code] private function getMedlemmerfromDB(){ global $wpdb; $plugin_medlemsteller = $wpdb->prefix . "plugin_medlemsteller"; $fromdb=$wpdb->get_var("SELECT medlemmer FROM $plugin_medlemsteller WHERE mID=(SELECT MAX(mID) FROM plugin_medlemsteller)"); return $fromdb; }[/code]

Collectives™ on Stack Overflow

Wordpress $wpdb query issue

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related