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);
