通过多种条件推进ORM查找

Question

I need to put multiple where conditions in my propel query. What is the best way to do it. For now I'm doing it like this:

 $employee = EmployeeQuery::create()
            ->where("password = '" . $password . "' AND username = '" . $username . "'")
            ->find();

Answer 1

Use the filterByXXX functions:

$employee = EmployeeQuery::create()
           ->filterByUsername($username)
           ->filterByPassword($password)
           ->find();