将PDO的FetchObject转换为Object属性； PHP中的OOP [英] PDO FetchObject into Object attributes; OOP in PHP

问题描述

如何将PDO FetchObject结果与$ this变量一起使用?

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
  }
}

推荐答案

尝试使用FETCH_INTO样式，例如

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

这篇关于将PDO的FetchObject转换为Object属性； PHP中的OOP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！