duankong8998 2016-11-21 20:33
浏览 46
已采纳

在CakePHP中进行sql查询后访问数据

I have performed the sql statement below and it has obtained the relevant row from the table.

sql;

$user = $this->UserVerifications
                ->find()
                ->where(['code' => $hash])
                ->all();

It is getting the row from the table 'UserVerifications' where the column 'code' is equal to the value of 'hash'. This bit works, see below for output.

debug($user);
\src\Controller\UsersController.php (line 57) object(Cake\ORM\ResultSet) {

'items' => [
    (int) 0 => object(App\Model\Entity\UserVerification) {

        'id' => (int) 23,
        'code' => '4206e38996fae4028a26d43b24f68d32',
        'date_created' => object(Cake\I18n\FrozenTime) {

            'time' => '2016-11-21T18:48:45+00:00',
            'timezone' => 'UTC',
            'fixedNowTime' => false

        },
        '[new]' => false,
        '[accessible]' => [
            '*' => true
        ],
        '[dirty]' => [],
        '[original]' => [],
        '[virtual]' => [],
        '[errors]' => [],
        '[invalid]' => [],
        '[repository]' => 'UserVerifications'

    }
]

}

According to the CakePHP website, or at least the way I'm reading it, I should be able to access the value for id by doing the following;

echo $user->id;

Notice (8): Undefined property: Cake\ORM\ResultSet::$id [APP/Controller\UsersController.php, line 58]

Am I missing something simple?

  • 写回答

2条回答 默认 最新

  • douzhi2988 2016-11-22 00:46
    关注

    If you need particular row only from table,try this:

    $user = $this->UserVerifications
                ->find()
                ->where(['code' => $hash])
                ->first();
    

    And now you can use:

    $user->id;
    

    to access value of id and so on. And if you need multiple rows from the table go with @Felippe's answer.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?