Convert normal SQL query to Zend_Db?

Question

I cant convert this below query to Zend_Db:

SELECT `mfaq`.* FROM `m_faq` AS `mfaq`
WHERE (mfaq.delete_flg <> 'D' OR mfaq.delete_flg IS NULL)
AND ((mfaq.title like '%$title%')
OR (mfaq.title like '%$title%')
AND (mfaq.title like '%$title%') 
OR (mfaq.title like '%$title%'))
ORDER BY `create_date` DESC

Some help???

shukshin.ivan · Accepted Answer · 2013-01-14 18:51:25Z

1

First you need to have created dbtable model:

class Application_Model_DbTable_Mfaq extends Zend_Db_Table_Abstract
{
    protected $_name = 'm_faq';
}

Then use it as follows:

$table = new Application_Model_DbTable_Mfaq();

$select = $table->getAdapter()->select()
            ->from(array('mfaq'=>$table->info(Zend_Db_Table::NAME)))
            ->where("( mfaq.delete_flg <> 'D'")
            ->orWhere("mfaq.delete_flg IS NULL )")
            ->where("( mfaq.title like ?", "%$title%")
            ->orWhere("mfaq.title like ? ", "%$title%")
            ->where(" mfaq.title like ?", "%$title%")
            ->orWhere("mfaq.title like ? )", "%$title%")
            ->order("create_date DESC");

// echo $select; // shows your sql
$results = $select->query()->fetchAll();

I hope, you take into account that AND have higher priority than OR.

answered Jan 14, 2013 at 18:51

shukshin.ivan

11.4k4 gold badges58 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert normal SQL query to Zend_Db?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related