";
If($criteria_url==''){$criteria="id";}else{$criteria=$criteria_url;}
//echo "Criteria:$criteria
";
$var = $_REQUEST['var'];
$sql = "select * from traffic WHERE `id` LIKE \"%$var%\" OR `site` LIKE \"%$var%\" OR `type` LIKE \"%$var%\" OR `date` LIKE \"%$var%\" OR `ip` LIKE \"%$var%\" OR `link` LIKE \"%$var%\" OR `page` LIKE \"%$var%\"order by `$criteria` desc";
$numresults=mysqli_query($sql);
$numrows=mysqli_num_rows($numresults);
echo"Results: $numrows
";
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
// get results
$result = mysqli_query($query) or die("Couldn't execute query");
// now you can display the results returned
while ($row= mysqli_fetch_array($result)) {
$id= $row["id"];
$ip= $row["ip"];
$date = $row["date"];
$site = $row["site"];
$type= $row["type"];
$link_raw= $row["link"];
$page= $row["page"];
$link=nicetrim($link_raw);
echo "$id | $ip | $date | $site | $type | $page $link
";
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "
";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print " <<
Prev 100 ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
// check to see if last page
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {
// not last page so give NEXT link
$news=$s+$limit;
echo " Next 100 >>";
}
$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
?>
|
