{"id":1227,"date":"2022-08-30T15:14:30","date_gmt":"2022-08-30T15:14:30","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/10\/zend-framework-2-where-clause-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:14:30","modified_gmt":"2022-08-30T15:14:30","slug":"zend-framework-2-where-clause-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/zend-framework-2-where-clause-collection-of-common-programming-errors\/","title":{"rendered":"Zend Framework 2 – Where Clause-Collection of common programming errors"},"content":{"rendered":"

I would like to add a where clause with this method.<\/p>\n

public function fetchAll()\n{\n    $resultSet = $this->select();\n    return $resultSet;\n}\n<\/code><\/pre>\n
I have added like this.<\/p>\n
public function fetchAll()\n{\n    $resultSet = $this->select();\n    $resultSet->where(\"status = ?\", 1);\n    return $resultSet;\n}\n<\/code><\/pre>\n
But, it shown the below error.<\/p>\n
\n
Fatal error: Call to undefined method Zend\\Db\\ResultSet\\ResultSet::where()<\/p>\n<\/blockquote>\n
Could you please help me to add WHERE, OR WHERE, GROUP and ORDER with above mentioned method.<\/p>\n
    \n
  1. \n
    Hopefully this will help you out:<\/p>\n
        public function Profile($accountid)\n    {\n        $result = $this->select(function (Select $select) use ($accountid) {\n            $select\n                ->columns(array(\n                    'datefrom',\n                    'available',\n                    'used',\n                    'details'\n                ))\n                ->where($this->adapter->getPlatform()->quoteIdentifier('accountid') . ' = ' . $this->adapter->getPlatform()->quoteValue($accountid));\n        });\n\n        $row = $result->current();\n\n        if (!$row) {\n            throw new \\Exception('could_not_find_row');\n        }\n\n        return $row;\n    }\n<\/code><\/pre>\n<\/li>\n
  2. \n
    You can also do $sql->select()->where(array('status' => 1))<\/code> or $table->select(array('status' => 1))<\/code> (annoying, wish they used the same syntax).<\/p>\n
    You pass where an associative array with the mapping column => value<\/code> (and since it’s an array you can give it multiple clauses). Diemuzi’s way is good for complex identifiers but this is a more readable way for simple comparison.<\/p>\n<\/li>\n<\/ol>\n
    Originally posted 2013-11-10 00:10:52. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    I would like to add a where clause with this method. public function fetchAll() { $resultSet = $this->select(); return $resultSet; } I have added like this. public function fetchAll() { $resultSet = $this->select(); $resultSet->where(“status = ?”, 1); return $resultSet; } But, it shown the below error. Fatal error: Call to undefined method Zend\\Db\\ResultSet\\ResultSet::where() Could you […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"class_list":["post-1227","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-zend-framework"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1227"}],"version-history":[{"count":1,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1227\/revisions"}],"predecessor-version":[{"id":8883,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1227\/revisions\/8883"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}