php - 如何在查询绑定(bind)参数中放置两个以上的条件

Question

您好，我正在处理参数绑定(bind)查询 Phalcon。以下是我的代码

$conditions = "client = :client: AND inv_date = :inv_date: AND date_sent = :date_sent: AND date_received = :date_received:";
        $parameters = array(
            "client" => $search_client,
            "inv_date" => $invoice_date,
            "date_sent" => $date_sent,
            "date_received" => $date_received
        );
$invoices = Invoices::find(
    array(
        $conditions,
        "bind" => $parameters
    )
);

我是否正确使用了 AND？仅供引用，它不起作用，如果我尝试以下操作，它会起作用:

$conditions = "client = :client: AND inv_date = :inv_date:";
$parameters = array(
    "client" => $search_client,
);
$invoices = Invoices::find(
    array(
        $conditions,
        "bind" => $parameters
    )
);

所有字段都存在于表中，我认为还有其他方法可以使用多个AND

Answer 1

$conditions = "client = :client: AND inv_date = :inv_date:";
$parameters = array(
    "client" => $search_client,
);
$invoices = Invoices::find(
    array(
        $conditions,
        "bind" => $parameters
    )
);

此代码不起作用，因为您只传递一个参数 client，但必须传递 2 个参数:client 和 inv_date。

$parameters = array(
    "client" => $search_client,
    "inv_date" => $invoice_date,
);

因此 - 您可以使用此选项(因为它确实有效)或者您可以使用 andWhere 就像@Niki Mihaylov 建议的那样。