教义 - 还是在哪里？ [英] Doctrine - or where?

问题描述

我有以下查询：

$query = Doctrine_Query::create()
                ->from('Member m')
                    ->where("m.type='1'")
                        ->andWhere("m.name LIKE '%$term%'")
                        ->orWhere("m.surname LIKE '%$term%'")
                        ->orWhere("m.company LIKE '%$term%'")
                        ->orderBy('id DESC');

但它不像我想要的那样工作 - 它忽略类型列。

But it's not working like I want — it is ignoring type column.

我需要的是结果集，其中 m.type = 1 和其他一些这个查询中的字段是 LIKE'something'。

What I need is result set where m.type=1 and some of other fields in this query is LIKE 'something'.

推荐答案

$query = Doctrine_Query::create()
  ->from('Member m')
  ->where('m.type = 1 AND m.name LIKE ?', '%'.$term.'%')
  ->orWhere('m.type = 1 AND m.surname LIKE ?', '%'.$term.'%')
  ->orWhere('m.type = 1 AND m.company LIKE ?', '%'.$term.'%')
  ->orderBy('m.id DESC');

您的OR条件不包括第一个条件。还建议您使用？作为变量，以确保Doctrine转义。

Your OR conditions didn't include the first condition. It's also recommended to use the ? for your variables to ensure Doctrine escapes them.

这篇关于教义 - 还是在哪里？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！