PDO FetchObject into Object attributes; OOP in PHP

Question

How do I use PDO FetchObject results with the $this variable?

Have a page class which is used to display a page that has its details stored in a database. Each page has a title and a description specific to that page. In production, there are many more variables and functions than those shown here.


class Page  
{  
  var $title;
  var $description;

  function load_page() 
  {
    $this->get_page_meta();

    // do some more stuff and then
    // send $this variable to template view that displays page
  }


  function get_page_meta()
  {
    $stmt = $dbh->query("SELECT title, description FROM pages WHERE page_id = '1'");

    $stmt->fetch(PDO::FETCH_OBJ);
    // HOW DO I MAKE THE RESULT SET REFERENTIAL USING $this?
    // I want $this->title to be accessible 
    // without assigning $this->title = $result->title
  }
}

there is an object merging post here don't know if applies to you: stackoverflow.com/q/455700/642173 or then would $this->pdoObj->title; be an acceptable option for you? It implies that you use $this->pdoObj = $dbh->query($sql); — Melsi
– Melsi, Commented Nov 2, 2011 at 19:40
I would prefer to avoid any "children". I would like $this->title as opposted to $this->meta->title. — csi
– csi, Commented Nov 2, 2011 at 20:00
Unless I am missing something, the merging would take $this->other_attributes and merge it with $this->db_object to form $this->new_obj->combined_attributes. I would prefer $this->all_attibutes. — csi
– csi, Commented Nov 2, 2011 at 20:22

Phil · Accepted Answer · 2011-11-02 21:54:47Z

1

Try using the FETCH_INTO style, eg

$stmt = $dbh->prepare(...);
$stmt->setFetchMode(PDO::FETCH_INTO, $this);
$stmt->execute();
$stmt->fetch();
$stmt->closeCursor();

answered Nov 2, 2011 at 21:54

Phil

166k25 gold badges265 silver badges269 bronze badges

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

1 Comment

csi Over a year ago

Thank you! I wasn't aware of that functionality. That solves a lot of problems in this project and in others.

Collectives™ on Stack Overflow

PDO FetchObject into Object attributes; OOP in PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related