时间戳

首页 > 解决方案 > BadMethodCallException：参数数量错误

php - BadMethodCallException：参数数量错误

问题描述

由于我是 Phalcon 框架的新手，我没有找到解决问题的方法。这是我尝试使用的查询：

    $withdraws = Withdrawals::query()
        ->columns('Withdrawals.cashboxId', 'Withdrawals.amount', 'Withdrawals.createdAt', 'Withdrawals.status', 'Withdrawals.serialNo', 'u.firstName', 'u.lastName')
        ->innerJoin('Shop\Domain\Clients\Models\Clients', 'Withdrawals.userId = u.id', 'u')
        ->where('Withdrawals.cashboxId = :cashboxId:', ['cashboxId' => $cashboxId])
        ->andWhere('Withdrawals.status = :status:', ['status' => 1])
        ->execute();

它给了我BadMethodCallException: Wrong number of parameters。我在这里做错了什么？

标签： phpphalcon

解决方案

->columns()需要一个参数，一个字符串或数组。

试试这个

$withdraws = Withdrawals::query()
        ->columns(['Withdrawals.cashboxId', 'Withdrawals.amount', 'Withdrawals.createdAt', 'Withdrawals.status', 'Withdrawals.serialNo', 'u.firstName', 'u.lastName'])
        ->innerJoin('Shop\Domain\Clients\Models\Clients', 'Withdrawals.userId = u.id', 'u')
        ->where('Withdrawals.cashboxId = :cashboxId:', ['cashboxId' => $cashboxId])
        ->andWhere('Withdrawals.status = :status:', ['status' => 1])
        ->execute();

推荐阅读