php - 从 stdClass 对象中删除 stdClass 对象和 count(post_id) ( [count(post_id)] => 1 ) 仅需要结果 1

Question

我的 mysql 查询是:

$query=('SELECT count(post_id)  FROM comments where   post_id='.$row['post_id']);
 $usercomments = $this->db->query($query);
 foreach ($usercomments->result() as $comments)

我得到的输出:

stdClass Object ( [count(post_id)] => 1 )

如何获得计数值1？如何打印？

Answer 1

将您的查询更改为:

SELECT count(post_id)  FROM comments where   post_id='.$row['post_id'];

到

SELECT count(post_id) as post_count  FROM comments where   post_id='.$row['post_id'];
//here post_count is an ALIAS for the count(post_id)

然后获取其值，例如:

$comments->post_count;