php - 如何在 PHP 上获取 count(*)？

Question

我有以下来自 MySQL 的输出。

Array
(
[0] => stdClass Object
    (
        [id] => 19
        [date] => 2010-10-04 11:00:00
        [course] => Yoga
        [course_id] => 19
        [count(*)] => 2
        [capacity] => 20
    )

[1] => stdClass Object
    (
        [id] => 20
        [date] => 2010-10-04 13:00:00
        [course] => Spin
        [course_id] => 20
        [count(*)] => 1
        [capacity] => 24
    )
...
...

我可以获取日期、类(class)等，但我不确定如何使用 PHP 获取计数 (*)。

foreach ($bookingnum as $key => $list){
    echo "<tr valign='top'>\n";
    echo "<td align='center'>".$list->date."</td>\n";
            echo "<td align='center'>".$list->course."</td>\n";
          //  echo "<td align='center'>".$list->count(*)."</td>\n";
         // this is wrong. how to get count(*)?? 
 ....
 ...

Answer 1

将您的基本查询修改为

SELECT COUNT(*) AS `total` ...

那么你可以把它当作

$list->total