/** * 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); } }