/**
* take a resource result set and return an array of type 'ASSOC','NUM','BOTH'
* @param resource $result_set
* @param string $result_type in 'ASSOC','NUM','BOTH'
*/
function fetch_res($result_set, $result_type = 'ASSOC')
{
$result_type = strtoupper($result_type);
if (!in_array($result_type, array('NUM', 'ASSOC', 'BOTH'))) {
$result_type = 'ASSOC';
}
if ($result_type === 'ASSOC') {
while ($res[] = sqlite3_fetch_array($result_set)) {
}
unset($res[count($res) - 1]);
//unset last empty row
} elseif ($result_type === 'NUM') {
while ($res[] = sqlite3_fetch($result_set)) {
}
unset($res[count($res) - 1]);
//unset last empty row
} else {
while ($row = sqlite3_fetch_array($result_set)) {
$res[] = array_merge($row, array_values($row));
}
}
if (empty($res)) {
return $this->last_q2a_res = false;
}
$this->num_rows = count($res);
return $this->last_q2a_res = $res;
}
public function fetchArray($mode = SQLITE3_BOTH)
{
switch ($mode) {
case SQLITE3_BOTH:
$result = sqlite3_fetch_array($this->query);
return array_merge($result, array_values($result));
case SQLITE3_ASSOC:
return sqlite3_fetch_array($this->query);
case SQLITE3_NUM:
return sqlite3_fetch($this->query);
}
}
