public function rewind() { return sqlite_rewind($this->result); }
function sqlitem_rewind($result) { die('sqlitem_rewind not implemented in PDO'); return sqlite_rewind($result); }
/** * Se Mueve al resultado indicado por $number en un select * * @param int $number * @param resource $resultQuery * @return boolean */ function data_seek($number, $resultQuery = '') { if (!$resultQuery) { $resultQuery = $this->last_result_query; if (!$resultQuery) { return false; } } if (($success = sqlite_rewind($resultQuery, $number)) !== false) { return $success; } else { throw new KumbiaException($this->error()); } }
function sqlitem_rewind($result) { return sqlite_rewind($result); }
/** * Returns a complete result set as array */ function res2arr($res) { $data = array(); if ($this->extension == DOKU_EXT_SQLITE) { if (!sqlite_num_rows($res)) { return $data; } sqlite_rewind($res); while (($row = sqlite_fetch_array($res, SQLITE_ASSOC)) !== false) { $data[] = $row; } } else { if (!$res) { return $data; } $data = $res->fetchAll(PDO::FETCH_ASSOC); } return $data; }
public function rewind() { $lastresult = $this->results[$this->lasthash]; sqlite_rewind($lastresult); }
/** * Returns a complete result set as array */ function res2arr($res) { $data = array(); if (!sqlite_num_rows($res)) { return $data; } sqlite_rewind($res); while (($row = sqlite_fetch_array($res)) !== false) { $data[] = $row; } return $data; }
/** * This method actually has no effect, since we do not rewind ResultSet for iteration. */ function rewind() { sqlite_rewind($this->result); }
///////////// sqlite_query("CREATE TABLE strings(a VARCHAR)", $db); foreach ($data as $str) { sqlite_query("INSERT INTO strings VALUES('{$str}')", $db); } $r = sqlite_unbuffered_query("SELECT a from strings", $db); while (sqlite_valid($r)) { var_dump(sqlite_current($r, SQLITE_NUM)); sqlite_next($r); } $r = sqlite_query("SELECT a from strings", $db); while (sqlite_valid($r)) { var_dump(sqlite_current($r, SQLITE_NUM)); sqlite_next($r); } sqlite_rewind($r); while (sqlite_valid($r)) { var_dump(sqlite_current($r, SQLITE_NUM)); sqlite_next($r); } sqlite_exec("DROP TABLE strings", $db); /////// sqlite_query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)", $db); echo "Buffered\n"; $r = sqlite_query("SELECT * from strings", $db); echo "num fields: " . sqlite_num_fields($r) . "\n"; for ($i = 0; $i < sqlite_num_fields($r); $i++) { var_dump(sqlite_field_name($r, $i)); } echo "Unbuffered\n"; $r = sqlite_unbuffered_query("SELECT * from strings", $db, SQLITE_NUM, $errmsg);
protected function _rewind() { return @sqlite_rewind($this->_idResult); }
/** * Rewind the result set * * @param resource $res * @return boolean */ public function rewind($res) { sqlite_rewind($res); }
/** * Returns a complete result set as array */ public function res2arr($res, $assoc = true) { $data = array(); if (!$res) { return $data; } if (!sqlite_num_rows($res)) { return $data; } sqlite_rewind($res); $mode = $assoc ? SQLITE_ASSOC : SQLITE_NUM; while (($row = sqlite_fetch_array($res, $mode)) !== false) { $data[] = $row; } return $data; }
function db_rewind($res) { sqlite_rewind($res); }
function rewind() { //just to abstract from sqlite sqlite_rewind($this->result); }
public function rewind($result) { sqlite_rewind($result); }
protected function _rewind($result) { sqlite_rewind($result); }
<center><h2>網上『我的最愛』</h2></center> <a name="top"></a>'; if (isset($_SESSION['isLogined'])) { echo '<a href="' . text2xml("fav_action.php?action=order&id=-1" . $SidebarSuffix2) . '" class="admtool" ' . $admAppend . '>' . $MyFav_CatOrder . '</a> '; } if (!$oldNetscape) { echo '<a id="aToggle" href="' . text2xml("javascript:toggleAllDiv('aToggle','force');") . '" class="admtool">' . ($shrinkFirst ? $MyFav_ExpandAll : $MyFav_ShrinkAll) . '</a> <a id="aToggle2" href="' . text2xml("javascript:toggleAllDiv('aToggle2','invert');") . '" class="admtool">' . $MyFav_InvertAll . '</a>'; } echo '<div class="' . ($NoNavi ? 'dh' : ($DispNavi ? 'divNavi' : 'divNavi-hide')) . '" id="divNavi" onmouseover="restoreNavi()" onmouseout="NaviTimout()">'; if (!$NoNavi) { echo '<a href="#bottom" style="font-size:x-small;" onmouseover="restoreNavi()">' . $MyFav_GotoBottom . "</a><br />\n"; while ($row = sqlite_fetch_array($rs)) { echo '<a href="#' . $row['id'] . '" class="navi" onmouseover="restoreNavi()" ' . (!$oldNetscape ? 'onclick="' . text2xml("ExpandDiv('d" . $row['id'] . "','a" . $row['id'] . "');") . '"' : '') . '>' . text2xml($row['name']) . "</a><br />\n"; } echo '<a href="#top" style="font-size:x-small;">' . $MyFav_GotoTop . "</a><br />\n"; sqlite_rewind($rs); } echo '</div> <dl>'; while ($row = sqlite_fetch_array($rs)) { echo '<dt>'; if (isset($_SESSION['isLogined'])) { echo '<div onmouseover="toggleAdmTool(\'adm' . $row['id'] . '\')" onmouseout="toggleAdmTool(\'adm' . $row['id'] . '\')">'; } if (!$oldNetscape) { echo '<a id="a' . $row['id'] . '" href="' . text2xml("javascript:ToggleDiv('d" . $row['id'] . "','a" . $row['id'] . "');") . '" class="toggle">' . ($shrinkFirst ? $MyFav_ExpandMark : $MyFav_ShrinkMark) . '</a> '; } echo '<a name="' . $row['id'] . '"' . ($row['addr'] ? ' href="' . text2xml($row['addr']) . '" ' . $aAppend : '') . '>' . text2xml($row['name']) . '</a>'; if (isset($_SESSION['isLogined'])) { echo '<span class="admtools-hide" id="adm' . $row['id'] . '"><a href="' . text2xml("fav_action.php?action=add&catid=" . $row['id'] . $SidebarSuffix2) . '" class="admtool" ' . $admAppend . '>' . $MyFav_Add . '</a> <a href="' . text2xml("fav_action.php?action=order&id=" . $row['id'] . $SidebarSuffix2) . '" class="admtool" ' . $admAppend . '>' . $MyFav_Order . '</a> ' . printAdmTools($row['id']) . '</span></div>'; }
// echo "on row: ".sqlite_key($rh)."\n"; } // columns sqlite_seek($rh, 2); for ($i = 0; $i < sqlite_num_fields($rh); $i++) { $n = sqlite_field_name($rh, $i); $c = sqlite_column($rh, $i); var_dump($c); $c = sqlite_column($rh, $n); var_dump($c); } // fetch_all $r = sqlite_fetch_all($rh); var_dump($r); // fetch single sqlite_rewind($rh); $r = sqlite_fetch_string($rh); var_dump($r); } else { echo "bad query: " . sqlite_error_string($db); } // array_query $val = sqlite_array_query($db, 'SELECT * FROM mytable'); var_dump($val); // single query $val = sqlite_single_query($db, 'SELECT * FROM mytable'); var_dump($val); $val = sqlite_single_query($db, 'SELECT * FROM mytable LIMIT 1', true); var_dump($val); $val = sqlite_single_query($db, 'SELECT * FROM mytable LIMIT 1', false); var_dump($val);