如何使用Phalcon findFirst通过多个条件进行查找? [英] How to find by multiple criteria with Phalcon findFirst?

问题描述

我正在尝试从视频数据库中获取视频，选择基于external_id和language_id(两个整数)的唯一组合.我尝试了以下代码，但findFirst()似乎只选择了第一个条件

I'm trying to get a video from my video database, the selection is based on a unique combination of external_id and language_id (both integers). I tried the following code, but it looks like findFirst() only picks up the first criterium

$video = Video::findFirst("language_id=" . $language->id . " and external_id=" . $external->id);

有人可以帮助我如何正确地使用具有多个条件的findFirst吗?

Can anybody help me how to properly use findFirst with multiple criteria?

推荐答案

尝试绑定参数而不是将其串联.更安全，可能会发现错误区域

Try binding your parameters vs. concatenating them. Safer and it might identify an error area

$video = Video::findFirst(
    [
        'columns'    => '*',
        'conditions' => 'language_id = ?1 AND external_id = ?2',
        'bind'       => [
            1 => $language->id,
            2 => $external->id,
        ]
    ]
);

这篇关于如何使用Phalcon findFirst通过多个条件进行查找?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！