php - 如何在 mysqli_fetch_object 中获取计数帮助我

Question

echo $getq2 = "SELECT publisher,COUNT(publisher) from (select publisher from wiley where $getq2_ UNION ALL SELECT publisher FROM elsevier WHERE $getq2_ UNION ALL SELECT publisher FROM sage WHERE $getq2_  UNION ALL SELECT publisher FROM indianjournal WHERE $getq2_) as publisher Group by publisher order by publisher";

$getquery1 = $conn->query($getq2); 

通过查询获取之后

while($runrows =mysqli_fetch_object($getquery1))
   {
      print_r($getquery1);

      echo $pub=$runrows->publisher;
      //getting the publisher list
      echo $count=$runrows->count['publisher'];
      //not grtting the publisher count
 }

我得到了发布者，但没有得到计数。我怎样才能得到计数？

Answer 1

根据您的查询，您可以这样获取

$runrows->COUNT(publisher);  

或将查询更改为 .像这样设置别名 COUNT(publisher) as count

echo $getq2 = "SELECT publisher,COUNT(publisher) as count from (select publisher from wiley where $getq2_ UNION ALL SELECT publisher FROM elsevier WHERE $getq2_ UNION ALL SELECT publisher FROM sage WHERE $getq2_  UNION ALL SELECT publisher FROM indianjournal WHERE $getq2_) as publisher Group by publisher order by publisher";

然后像这样

 $runrows->count;