public function getServiceConfig() { return array('factories' => array("myAuthenticate" => function ($sm) { $adapter = $sm->get("db_books"); $dbTableAdapter = new \Zend\Authentication\Adapter\DbTable($adapter, "user", "email", "password"); $select = $dbTableAdapter->getDbSelect(); $select->where->equalTo("status", "1"); $authenticateObj = new \Zend\Authentication\AuthenticationService(null, $dbTableAdapter); return $authenticateObj; }, "authenticateLogin" => function ($sm) { return new \ZendVN\System\Authenticate($sm->get("myAuthenticate")); })); }
public function index04Action() { $adapter = $this->getServiceLocator()->get("db_books"); $dbTableAdapter = new \Zend\Authentication\Adapter\DbTable($adapter, "user", "email", "fullname"); // $select = $dbTableAdapter->getDbSelect(); $authenticateObj = new \Zend\Authentication\AuthenticationService(null, $dbTableAdapter); $authenticateObj->getAdapter()->setIdentity("*****@*****.**"); $authenticateObj->getAdapter()->setCredential("Stark"); $select = $authenticateObj->getAdapter()->getDbSelect(); $select->where->equalTo("status", "0"); //authen $result = $authenticateObj->authenticate(); if (!$result->isValid()) { echo "<pre style='font-weight:bold'>"; print_r($result->getMessages()); echo "</pre>"; } else { echo "good"; //thêm nhiều column //$data = $authenticateObj->getAdapter()->getResultRowObject(); $data = $dbTableAdapter->getResultRowObject(); //agr 1:chọn column muốn lấy ,agr 2 :chọn column không muốn lấy //ghi thông tin vào session $authenticateObj->getStorage()->write($data); echo "<pre style='font-weight:bold'>"; print_r($data); echo "</pre>"; } return false; }
public function getServiceConfig() { return array("factories" => array("Shop\\Model\\Category" => function ($sm) { $tableGateway = $sm->get("CategoryTableGateway"); return new \Shop\Model\CategoryTable($tableGateway); }, "Shop\\Model\\Book" => function ($sm) { $tableGateway = $sm->get("BookTableGateway"); return new \Shop\Model\BookTable($tableGateway); }, "Shop\\Model\\Slider" => function ($sm) { $tableGateway = $sm->get("SliderTableGateway"); return new \Shop\Model\SliderTable($tableGateway); }, "Shop\\Model\\User" => function ($sm) { $tableGateway = $sm->get("UserTableGateway"); return new \Shop\Model\UserTable($tableGateway); }, "Shop\\Model\\Group" => function ($sm) { $tableGateway = $sm->get("GroupTableGateway"); return new \Shop\Model\GroupTable($tableGateway); }, "PermissionTableGateway" => function ($sm) { $adapter = $sm->get("dbConfig"); //hydratingResultSet()---->lấy field từ các bảng khác không cần đưa vào entities $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new \ZendVN\Model\Entity\Permission()); return $tableGateway = new TableGateway("permission", $adapter, null, $resultSetPrototype); }, "Shop\\Model\\Permission" => function ($sm) { $tableGateway = $sm->get("PermissionTableGateway"); return new \Shop\Model\PermissionTable($tableGateway); }, "AuthenticateService" => function ($sm) { $adapter = $sm->get("dbConfig"); $dbTableAdapter = new \Zend\Authentication\Adapter\DbTable($adapter, "user", "email", "password", "MD5(?)"); $dbTableAdapter->getDbSelect()->where->equalTo("status", 1)->where->equalTo("active_code", 1); $authenticateObj = new \Zend\Authentication\AuthenticationService(null, $dbTableAdapter); return $authenticateObj; }, "MyAuth" => function ($sm) { return new \ZendVN\System\Authenticate($sm->get("AuthenticateService")); }, "OrderTableGateway" => function ($sm) { $adapter = $sm->get("dbConfig"); //hydratingResultSet()---->lấy field từ các bảng khác không cần đưa vào entities $resultSetPrototype = new ResultSet(); $resultSetPrototype->setArrayObjectPrototype(new \ZendVN\Model\Entity\Order()); return $tableGateway = new TableGateway("order", $adapter, null, $resultSetPrototype); }, "Shop\\Model\\Order" => function ($sm) { $tableGateway = $sm->get("OrderTableGateway"); return new \Shop\Model\OrderTable($tableGateway); }), "aliases" => array("shopBookTable" => "Shop\\Model\\Book", "shopUserTable" => "Shop\\Model\\User", "shopGroupTable" => "Shop\\Model\\Group", "shopPermissionTable" => "Shop\\Model\\Permission", "shopOrderTable" => "Shop\\Model\\Order"), "invokables" => array('Zend\\Authentication\\AuthenticationService' => 'Zend\\Authentication\\AuthenticationService')); }
public function getServiceConfig() { return array('factories' => array('AuthenticateService' => function ($sm) { $dbTableAdapter = new \Zend\Authentication\Adapter\DbTable($sm->get('dbBatDongSan'), 'users', 'email', 'password', 'MD5(?)'); $dbTableAdapter->getDbSelect()->where->equalTo('status', 1); $authenticateServiceObj = new \Zend\Authentication\AuthenticationService(null, $dbTableAdapter); return $authenticateServiceObj; }, 'Authenticate' => function ($sm) { return new \ZendVN\System\Authenticate($sm->get('AuthenticateService')); }, 'RealEstateTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\RealEstate()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\RealEstateTable' => function ($sm) { $tableGateway = $sm->get('RealEstateTableGateway'); return new \Home\Model\RealEstateTable($tableGateway); }, 'BusinessTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\Business()); return new TableGateway('business', $adapter, null, $resultSetProtype); }, 'Home\\Model\\BusinessTable' => function ($sm) { $tableGateway = $sm->get('BusinessTableGateway'); return new \Home\Model\BusinessTable($tableGateway); }, 'AgencyTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\Agency()); return new TableGateway('users', $adapter, null, $resultSetProtype); }, 'Home\\Model\\AgencyTable' => function ($sm) { $tableGateway = $sm->get('AgencyTableGateway'); return new \Home\Model\AgencyTable($tableGateway); }, 'NewsTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\News()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\NewsTable' => function ($sm) { $tableGateway = $sm->get('NewsTableGateway'); return new \Home\Model\NewsTable($tableGateway); }, 'FengshuiTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\Fengshui()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\FengshuiTable' => function ($sm) { $tableGateway = $sm->get('FengshuiTableGateway'); return new \Home\Model\FengshuiTable($tableGateway); }, 'LegalHousingTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\LegalHousing()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\LegalHousingTable' => function ($sm) { $tableGateway = $sm->get('LegalHousingTableGateway'); return new \Home\Model\LegalHousingTable($tableGateway); }, 'LegislationHousingTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\LegislationHousing()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\LegislationHousingTable' => function ($sm) { $tableGateway = $sm->get('LegislationHousingTableGateway'); return new \Home\Model\LegislationHousingTable($tableGateway); }, 'ContractFormTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\ContractForm()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\ContractFormTable' => function ($sm) { $tableGateway = $sm->get('ContractFormTableGateway'); return new \Home\Model\ContractFormTable($tableGateway); }, 'NiceHouseTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\NiceHouse()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\NiceHouseTable' => function ($sm) { $tableGateway = $sm->get('NiceHouseTableGateway'); return new \Home\Model\NiceHouseTable($tableGateway); }, 'ProjectTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\Project()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\ProjectTable' => function ($sm) { $tableGateway = $sm->get('ProjectTableGateway'); return new \Home\Model\ProjectTable($tableGateway); }, 'MarketTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\Market()); return new TableGateway('category', $adapter, null, $resultSetProtype); }, 'Home\\Model\\MarketTable' => function ($sm) { $tableGateway = $sm->get('MarketTableGateway'); return new \Home\Model\MarketTable($tableGateway); }, 'UserTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\User()); return new TableGateway('users', $adapter, null, $resultSetProtype); }, 'Home\\Model\\UserTable' => function ($sm) { $tableGateway = $sm->get('UserTableGateway'); return new \Home\Model\UserTable($tableGateway); }, 'PermissionTableGateway' => function ($sm) { $adapter = $sm->get('dbBatDongSan'); $resultSetProtype = new ResultSet(); $resultSetProtype->setArrayObjectPrototype(new \Home\Model\Entity\Permission()); return new TableGateway('permission', $adapter, null, $resultSetProtype); }, 'Home\\Model\\PermissionTable' => function ($sm) { $tableGateway = $sm->get('PermissionTableGateway'); return new \Home\Model\PermissionTable($tableGateway); })); }