PHP Class: mysql data as a property

Question

I want to create properties that are set to mysql data.

class MyClass{
    private $a = $r['a'];
    private $b = $r['a'];
    private $c = $r['c']; 
}

I know this is incorrect syntax but I want you to get the idea.

I could create a method that returns a requested mysql data, but I don't want the function to be called for every single row.

joksnet · Accepted Answer · 2011-01-11 11:39:05Z

2

You need to implement the magic method __get.

Something like:

class MyClass {
  protected $_row = array();

  public function __get( $name )
  {
    if (array_key_exists($name, $this->_row)) {
      return $this->_row[$name];
    }
    return null;
  }

  public function __isset( $name )
  {
    return array_key_exists($name, $this->_row);
  }
}

And you could used as:

$obj = new MyClass();
$obj->load(); // Or any method to load internal data
echo $obj->a . $obj->b;

edited Jan 11, 2011 at 11:39

answered Jan 11, 2011 at 11:34

joksnet

2,31515 silver badges18 bronze badges

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

1 Comment

Jonathan Amend Over a year ago

ajreal has a good point, why are you creating a class with an array to hold the property values and magic getters/settings when mysqli_result::fetch_object (or mysql_fetch_object) can do the same thing without all the legwork?

ajreal · Accepted Answer · 2011-01-11 12:21:58Z

1

Why reinvent the wheel ?

check this mysqli_result::fetch_object

answered Jan 11, 2011 at 12:21

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Collectives™ on Stack Overflow

PHP Class: mysql data as a property

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related