public function selectVar($tableName, $where, $order = null, $fieldName = null)
{
//select name from table where id = 1;
//ambil isi field di row 1 col 1
$sql = new Sql($this->_storage->getAdapter());
$metadata = new \Zend\Db\Metadata\Metadata($this->_storage->getAdapter());
$field = $metadata->getColumns($tableName);
$result = array();
$query = $sql->select()->from($tableName)->columns(array($field[0]->getName()))->where($where)->limit(1);
if ($order) {
$query->order($order);
}
if ($fieldName) {
$query->columns(array($fieldName));
}
$statement = $sql->prepareStatementForSqlObject($query);
$response = $statement->execute();
foreach ($response as $key => $value) {
$result[$key] = $value;
}
return $result[$key];
}
