UserTable.php

<?// module/User/src/User/Model/UsersTable.php:
namespace User\Model;

use Zend\Db\TableGateway\TableGateway;
use Zend\Db\Adapter\Adapter;
use Zend\Db\ResultSet\ResultSet;
use Zend\Db\TableGateway\AbstractTableGateway;
use Zend\Db\Sql\Expression;
use Zend\Db\Sql\Select;
use Zend\Db\Sql\Sql;
use Zend\Db\Adapter\ZendDbAdapterAdapter;
use Zend\Db\TableGateway\Feature;
use \Exception;

class UserTable
{
    protected $tableGateway;

    public function __construct(TableGateway $tableGateway, $sm){
        $this->tableGateway = $tableGateway;
        $this->sm = $sm;
    }


    public function getAll(){
        $resultSet = $this->tableGateway->select();
        return $resultSet;
    }

    public function save($data)
    {
        $result = $this->tableGateway->insert($data);
        return $result;
    }

     public function update($data, $where)
    {
        $result = $this->tableGateway->update($data, $where);
        return $result;
    }

    public function delete($where)
    {
       $result = $this->tableGateway->delete($where);
       return $result;
    }


    public function getById($id)
    {
        $resultSet = $this->tableGateway->select(array("id" => $id) );
        return $resultSet->current();
    }


    public function getCount(){
        $select = new Select();

        $resultSet = $this->tableGateway->select(function($select) {
            $select->columns(array('count_r' => new \Zend\Db\Sql\Expression('COUNT(*)')));
        });

        return $resultSet->current();
    }
}