- 如何检索twig中的实体数据?我选择了两个实体:新闻和评论,但在 twig 中我只能从新闻实体获取数据。 (例如:“来自树枝”)
- 如何查看获取的实体对象中的内容(例如:来自控制器的 $fetched_news 变量)。我尝试过: print_r($fetched_news) 或 {{ dump(fetched_news }}),但在第一个示例中我得到了全屏代码,而在第二个应用程序中则被挂起。
- 在新闻和评论实体中,有一个名为“内容”的列。如何从该列获取数据?我正在尝试这样的事情:
fetched_news.comments.content
or
fetched_news.news.content
我在很多页面上寻找答案,但找不到有趣的东西。
来自树枝:
{% for news in fetched_news %}
<div class="col-md-5">
<p class="news_title">{{ news.title }}</p>
{{ (news.content|slice(0,600))|raw }}
{{ news.ratePlus }} {# CAN'T GET THIS!#}
{% else %}
{% endfor %}
来自控制器:
public function indexAction()
{
$em = $this->getDoctrine()->getManager();
$query = $em->createQuery("SELECT n, a FROM BlogAdminBundle:News n JOIN n.comments a");
$fetched_news = $query->getResult();
return array('fetched_news' => $fetched_news);
}
来自 Web Profiler 的代码
SELECT
n0_.id AS id0,
n0_.content AS content1,
n0_.title AS title2,
n0_.date_add AS date_add3,
n0_.date_active AS date_active4,
n0_.settings AS settings5,
c1_.id AS id6,
c1_.content AS content7,
c1_.date_add AS date_add8,
c1_.rate_plus AS rate_plus9,
c1_.rate_minus AS rate_minus10,
n0_.user_id AS user_id11,
c1_.user_id AS user_id12,
c1_.news_id AS news_id13
FROM
News n0_
INNER JOIN Comments c1_ ON n0_.id = c1_.news_id
感谢帮助!
实体类点评:
/**
* @ORM\ManyToOne(targetEntity="News", inversedBy="comments")
* @ORM\JoinColumn(name="news_id", referencedColumnName="id")
*/
protected $news;
实体类新闻:
/**
* @ORM\OneToMany(targetEntity="Comments", mappedBy="news")
*/
protected $comments;
public function __construct()
{
$this->comments = new \Doctrine\Common\Collections\ArrayCollection();
}