Sunday, 18 August 2013

Zend 2 adapter in Controller works fine but not in Model

Zend 2 adapter in Controller works fine but not in Model

I am new in Zend 2. I have made a controller and Model.
I am getting the following error:
Fatal error: Call to a member function get() on a non-object in
C:\websites\zend2\module\Pages\src\Pages\Model\PagesTable.php on line 25
What do i do wrong?!?!
controller:
namespace Pages\Controller;
use Zend\Mvc\Controller\AbstractActionController;
class IndexController extends AbstractActionController {
function indexAction() {
$test = new \Pages\Model\PagesTable();
$test->pages();
print_r($test);
}
}
Model:
namespace Pages\Model;
use Zend\Mvc\Controller\AbstractActionController;
use Zend\View\Model\ViewModel;
use Zend\Db\ResultSet\ResultSet;
class PagesTable extends AbstractActionController{
function pages() {
$db = $this->getAdapter();
$sql = 'select * from pages';
$stmt = $db->query($sql);
$result = $stmt->execute();
$resultSet = new ResultSet;
$resultSet->initialize($result);
$viewObj = new ViewModel(array('result' => $resultSet));
print_r($viewObj);
}
public function getAdapter() {
if (empty($this->adapter)) {
$sm = $this->getServiceLocator();
$this->adapter = $sm->get('Zend\Db\Adapter\Adapter');
}
return $this->adapter;
}
}

No comments:

Post a Comment