How to set global $wpdb in class variable

Question

I am trying to use OOP in wordpress. Sample code below. As you can see I have to put global $wpdb in each method. I want to avoid duplicating this line in each method.

Is there a way to set this in constructor or into some protected/private variable so i don't have to put that in every function?

    class HouseRepository {
        public function functionB() {
            global $wpdb;

            $results = $wpdb->get_results();

            return $results;
        }

        public function functionA() {
            global $wpdb;

            $results = $wpdb->get_results();

            return $results;
        }
    }

I tried doing in constructor (and removed from each method) it doesn't work.

function __construct() {
    global $wpdb;
}

cjmling · Accepted Answer · 2019-08-02 18:03:40Z

3

You can try setting a reference to the global $wpdb variable to a class property or static property.

function __construct() {
    global $wpdb;

    $this->wpdb = $wpdb;
    // or
    self::$wpdb = $wpdb;
}

And later access that property inside the methods.

public function functionA() {


    $results = $this->wpdb->get_results();
    // or
    $results = self::$wpdb->get_results();

    return $results;
}

Thanks.

edited Aug 2, 2019 at 18:03

cjmling

7,29911 gold badges50 silver badges83 bronze badges

answered Aug 2, 2019 at 17:59

gjzim

6435 silver badges11 bronze badges

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

1 Comment

cjmling Over a year ago

Oh thats what i wanted. Thanks :D

Collectives™ on Stack Overflow

How to set global $wpdb in class variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related