如何在zend框架中使用多条件选择？

Question

我想选择与Zend框架多条件的行我如何可以实现/

1 - 例如“选择ID，名字，姓氏，从一个人的城市，名字=亚历克斯和城市= XX”; 2-example“select name，select name，lastname，from first name = alex or city = xx”;

Answer 1

$firstname = 'alex'; 
$city = 'xx'; 

// AND query 
$select = $adapter->select() 
    ->from('person', array('id', 'firstname', 'lastname', 'city') 
    ->where('firstname = ?', $firstname) 
    ->where('city ?', $city); 


// OR query 
$select = $adapter->select() 
    ->from('person', array('id', 'firstname', 'lastname', 'city') 
    ->where('firstname = ?', $firstname) 
    ->orWhere('city = ?', $city); 

看看在Zend_Db_Select手动看到更多的例子。

Answer 2

你可以看到例子Zend.DB manual

// Build this query: 
    // SELECT product_id, product_name, price 
    // FROM "products" 
    // WHERE (price < 100.00 OR price > 500.00) 
    //  AND (product_name = 'Apple') 

    $minimumPrice = 100; 
    $maximumPrice = 500; 
    $prod = 'Apple'; 

    $select = $db->select() 
       ->from('products', 
         array('product_id', 'product_name', 'price')) 
       ->where("price < $minimumPrice OR price > $maximumPrice") 
       ->where('product_name = ?', $prod);