MPOS / php-mpos

   **/

  public function getTypes() {

    $stmt = $this->mysqli->prepare("SELECT DISTINCT type FROM $this->table");

    if ($this->checkStmt($stmt) && $stmt->execute() && $result = $stmt->get_result()) {

      $aData = array('' => '');

      while ($row = $result->fetch_assoc()) {

        $aData[$row['type']] = $row['type'];

      }

      return $aData;

    }

    return $this->sqlError();

  }

  /**

      FROM " . $this->getTableName() . " AS a

      WHERE a.username LIKE ?

      GROUP BY username");

    if ($this->checkStmt($stmt) && $stmt->bind_param('s', $filter) && $stmt->execute() && $result = $stmt->get_result()) {

      while ($row = $result->fetch_assoc()) {

        $aData[$row['id']] = $row['username'];

      }

      return $aData;

    }

    return false;

  }

  /**