Convert mysql query to zend query?

Question

I want to convert following sql query to zend query. How I can convert this mysql query into zend query with zend framework 2?

SELECT SUM(amount)
FROM tbl_sale_amount 
WHERE sale_type_id=7459650 AND YEAR(db_add_date) = YEAR(CURDATE());

NOTE: Need to fetch sum of amount for current year from tbl_sale_amount.

Thanks

GOT MY ANSWER HERE: ZF2 Query WHERE clause with DATE() for datetime column

duplicate question stackoverflow.com/questions/6161370/…

Devendra Singh Bhandari
– Devendra Singh Bhandari

2015-10-29 05:33:48 +00:00
Commented Oct 29, 2015 at 5:33 — Devendra Singh Bhandari
– Devendra Singh Bhandari, Commented Oct 29, 2015 at 5:33

Ninju · Accepted Answer · 2015-10-29 05:46:39Z

0

Use this

 $stmt = $db->query('SELECT SUM(amount)
    FROM tbl_sale_amount 
    WHERE sale_type_id= ? AND YEAR(db_add_date) = YEAR(CURDATE()',
                array($sale_type_id)
            );

$result = $stmt->fetchAll();
        $stmt->closeCursor();
        if ($result) {
            return $result;
        } else {
            return false;
        }

answered Oct 29, 2015 at 5:46

Ninju

2,5322 gold badges16 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Convert mysql query to zend query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related