{"id":1250,"date":"2022-08-30T15:14:53","date_gmt":"2022-08-30T15:14:53","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/10\/set-parameter-with-tablegateway-select-function-show-error-undefined-variable-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:14:53","modified_gmt":"2022-08-30T15:14:53","slug":"set-parameter-with-tablegateway-select-function-show-error-undefined-variable-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/set-parameter-with-tablegateway-select-function-show-error-undefined-variable-collection-of-common-programming-errors\/","title":{"rendered":"Set Parameter with TableGateway Select Function show error undefined variable-Collection of common programming errors"},"content":{"rendered":"

i create a function in my model like :<\/p>\n

public function getAllMenuByOnlyActionPage($actionlot){\n\n            $act  = trim($actionlot);\n            $result = $this->tableGateway->select(function (Select $select) {\n                        $select->where(array('status != ?' => 13))\n                        ->where(array('action' => $act))\n                        ->order('id ASC');\n                    }); \n            $results = array();\n            foreach ($result as $row) {\n                $results[] = $row;\n            }\n            return $results;\n\n        }  \n<\/code><\/pre>\n
When i try to execute then its show me Notice: Undefined variable: act<\/code>. I already see this link ZF2 tableGateway select but i want to set parameter for this function. Thanks<\/p>\n
    \n
  1. \n
    Try<\/p>\n
    $result = $this->tableGateway->select(function (Select $select) use ($act)  {\n                        $select->where(array('status != ?' => 13))\n                        ->where(array('action' => $act))\n                        ->order('id ASC');\n                    }); \n<\/code><\/pre>\n<\/li>\n<\/ol>\n
    Originally posted 2013-11-10 00:12:10. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    i create a function in my model like : public function getAllMenuByOnlyActionPage($actionlot){ $act = trim($actionlot); $result = $this->tableGateway->select(function (Select $select) { $select->where(array(‘status != ?’ => 13)) ->where(array(‘action’ => $act)) ->order(‘id ASC’); }); $results = array(); foreach ($result as $row) { $results[] = $row; } return $results; } When i try to execute then its show […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1250","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1250","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=1250"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1250\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}