Some Useless Stuffs From My Lib

It is just for a while, am sure the admin is working on this. Meanwhile, you can make do with a new post to correct the one with an error.

<style>
body {font:12px tahoma;line-height:5mm}
a:link,a:visited,a:active{text-decoration:none;font:11px tahoma;}
.pager {color:black;font:11px tahoma;margin-top:10px;padding-top:5px;border-top:1px solid blue;}
.pager a:link,a:visited,a:active{color:blue;}
.pager a:hover{color:red;}
</style>
<title>Dynamic Pager Lite</title>


<?php
include_once "connect.php";
include_once "dbview.php";


$dv=new dbview("select * from country2",25);

foreach($dv->rows as $rows) {$dv->garray($rows);
print<<<end
<li>$id | $title | $text</li>
end;
}

print<<<end
<div class='pager' style="width:400px;">
&lt; $dv->prev | $dv->next &gt; &nbsp;&nbsp; Showing <b>$dv->pos_start</b> to <b>$dv->pos_pause</b> out of <b>$dv->maxlength</b>
</div>
end;
?>

<?php
$link = mysql_connect('localhost', 'db_user', 'db_pass');
mysql_select_db("country",$link) or die ("Could not select database");
?>

<?php
class dbview {

function href() {$sfile="http://".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF'];return "$sfile";}
function qhref() {$q=$this->fetchQuery('start');if($q!="") {$q="?$q&start=";} else {$q="?start=";};$href=$this->href().$q;return $href;}

function garray($arr,$search="",$replace="") {if(!is_array($arr)) return; foreach (array_keys($arr) as $key) {$val=$this->unesc(stripslashes($arr[$key]));
$val= $val=="$search" ? "$replace" : "$val";
$key='$GLOBALS["'.$key.'"]="'.$val.'";';eval("$key");
};return;
}

function unesc($text) {$replace = array("'");$find   = array("%27");return str_replace($find, $replace, $text);}


function instrEx($str,$substr) {if (substr_count(strtolower(trim(($str))), trim(strtolower($substr)))>0) {return true;} {return false;}}

function fetchQuery($exclude) {
 if(!isset($_SERVER['QUERY_STRING'])) {return "";}
 $arr=spliti("&",$_SERVER['QUERY_STRING']);
 $xclude=spliti(",",$exclude);
 $result=array();
 foreach($arr as $temp) {$add=true;
   foreach($xclude as $x) {if (substr_count(strtolower(("$temp")), strtolower("$x"))>0) {$add=false;}}
   if($add) {$result[]=$temp;}
 }
 return implode("&", $result);
}


function dbview($search,$maxitems=10) {
//init engine start
$r=mysql_query("$search") or die("$search\n<br>".mysql_error());
$maxlength=mysql_num_rows($r);

$start= intval($_REQUEST['start'])<=0 ? "0" : $_REQUEST['start'];

if($start>=$maxlength) {$start=$maxlength-$maxitems;}

$search="$search limit $start,$maxitems";

$result=mysql_query("$search") or die("$search\n<br>".mysql_error());
//init engine stop

//create array start
$rows=Array();
while($rows[]=mysql_fetch_array($result)) {}
$rows=array_splice($rows,0,-1);

$this->rows=$rows;
//create array stops

//parse result start
$posa =  $start-$maxitems;$posb = $start+$maxitems;

$url=$this->qhref();
if($posa >=0) {$prev_lnk="<a href='$url$posa'>Previous</a>";$prev_txt="";} else {$prev_lnk="";$prev_txt="Previous";}
if($start+$maxitems+1<=$maxlength) {$next_lnk="<a href='$url$posb'>Next</a>";$next_txt="";} else {$next_lnk="";$next_txt="Next";}

$prev= $prev_txt=="" ? $prev_lnk : $prev_txt;
$next= $next_txt=="" ? $next_lnk : $next_txt;

$pos_start=$start+1;$pos_pause=$pos_start+$maxitems-1;

if($pos_pause>$maxlength) {$pos_pause=$maxlength;}

$this->prev=$prev;
$this->prev_lnk=$prev_lnk;
$this->prev_txt=$prev_txt;

$this->next=$next;
$this->next_lnk=$next_lnk;
$this->next_txt=$next_txt;

$this->pos_start=$pos_start;
$this->pos_pause=$pos_pause;
$this->maxitems=$maxitems;
$this->maxlength=$maxlength;
//parse result ends
}

}
?>