+
+
+
+ ";
+
+
+
+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 ;
+
+
+
+?>
+
+ |
+
+
+
+ 
