<?php
//
// cmSlu CMS POC
//
//   Database query result abstraction
//

abstract class DBResult {
  // constants for fetching
  const FT_NUM = 1;
  const FT_ASSOC = 2;
  const FT_BOTH = 3;
  // number of result rows
  abstract public function NumRows();
  // number of affected rows
  abstract public function AffectedRows();
  // insert id for autoincremented primary key
  abstract public function InsertId();
  // move to n-th record in the result set
  abstract public function Seek($offset);
  // fetch result row
  abstract public function FetchRow($how = DBResult::FT_BOTH);
  // shortcuts
  public function FetchArray() { return $this->FetchRow(DBResult::FT_NUM); }
  public function FetchAssoc() { return $this->FetchRow(DBResult::FT_ASSOC); }
  public function FetchValue() { $r = $this->FetchRow(DBResult::FT_NUM); return $r[0]; }
  public function Reset() { $this->Seek(0); }
  // fetch all results
  public function FetchAllAssoc() {
    $arr = array();
    while(!is_null($a = $this->FetchAssoc())) {
      $arr[] = $a;
    }
    return $arr;
  }
  // fetch all values
  public function FetchAllValues() {
    $arr = array();
    while(!is_null($a = $this->FetchValue())) {
      $arr[] = $a;
    }
    return $arr;
  }
}

?>