Re: [PHP-DB] PHP Results on multiple pages

Hello Chris,

I am inserting complete script for you to have a look at and was using
$s = $pages

  // Get the search variable from URL

  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10;


// check for an empty string and display a message.

if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database **

mysql_connect("localhost","username","password"); //(host, username,
password)

//specify database **

mysql_select_db("_database") or die("Unable to select database"); //select
which database we're using

// Build SQL Query
$query = "select * from mytable where massage like '%".$trimmed."%' order by
id";
// EDIT HERE and specify your table and field names for the SQL query

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);


// If we have no results, offer a google search as an alternative

if ($numrows == 0)
  {

  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero
results</p>";

}

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }
// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for :<font color=blue size=+2> &quot;" . $var .
"&quot;</font>";


// begin to show results set
echo " found  $numrows results <p>";
$count = 1 + $s;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {

  $title = $row["sname"];
  $url = $row["url"];
  $message = $row["massage"];
//&nbsp;<a href=\"$row['url']\">"$row['sname']</a><br />
$row['massage']<br><hr>'\

  echo "$count.)&nbsp";
  echo "<b><a href=\"$url\" target=\"_blank\">$title</a></b>";
  echo "<br>";
  echo "$message<br><hr height=12 color=lightblue><br>";
  $count++;

  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results &lt;&lt;
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href='{$_SERVER['PHP_SELF']}?s=$prevs&q=$var'> <<<
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
//  $s=intval($numrows/$limit);
  $s=ceil($numrows/$limit);


// $s now contains int of pages needed unless there is a remainder from
division

  if ($numrows%$limit) {
  // has remainder so add one page
  $s++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$s) && $s!=1) {

  // not last page so give NEXT link  $PHP_SELF &gt;&gt;
  $news="$s+$limit";

  echo "&nbsp;<a href='{$_SERVER['PHP_SELF']}?s=$news&q=$var'>Next 10 >>>
</a>";

  }

$a = $s+$limit;
  if ($a > $numrows) { $a = $numrows; }
$b = $s+1;
  echo "<p>Showing results $b to $a of $numrows</p>";
include ('footer.inc');
?>


"Chris" <[email protected]> wrote in message 
news:[email protected]...
>
>> This script do everything fine counting total records
>> it display's 1 to 10 records on first page with numbers but
>> second location where i want it to display Showing results 1 to 10 it 
>> shows
>> 17 to 26 second it displays a link to Next but not working.
>
> It takes roughly 20 secs to do a search? Perhaps that should also be 
> looked at.
>
> Try to narrow down your problem.
>
>> // begin to show results set
>> echo " found  $numrows results <p>";
>> $count = 1 + $s;
>
> Where does $s come from? What is it supposed to mean? (Name your variables 
> properly).
>
>> // now you can display the results returned
>>  while ($row= mysql_fetch_array($result)) {
>>
>>  $title = $row["sname"];
>>  $url = $row["url"];
>>  $message = $row["massage"];
>> //&nbsp;<a href=\"$row['url']\">"$row['sname']</a><br />
>> $row['massage']<br><hr>'\
>>
>>  echo "$count.)&nbsp";
>>  echo "<b><a href=\"$url\" target=\"_blank\">$title</a></b>";
>>  echo "<br>";
>>  echo "$message<br><hr height=12 color=lightblue><br>";
>>  $count++;
>>
>>  }
>>
>> $currPage = (($s/$limit) + 1);
>>
>> //break before paging
>>  echo "<br />";
>>
>>  // next we need to do the links to other results
>>  if ($s>=1) { // bypass PREV link if s is 0
>>  $prevs=($s-$limit);
>>  print "&nbsp;<a href='{$_SERVER['PHP_SELF']}?s=$prevs&q=$var'> <<<
>>  Prev 10</a>&nbsp&nbsp;";
>>  }
>>
>> // calculate number of pages needing links
>> //  $s=intval($numrows/$limit);
>>  $s=ceil($numrows/$limit);
>>
>>
>> // $s now contains int of pages needed unless there is a remainder from
>> division
>>
>>  if ($numrows%$limit) {
>>  // has remainder so add one page
>>  $s++;
>>  }
>
> What is $s set to here when there's extra pages to display?
>
>> // check to see if last page
>>  if (!((($s+$limit)/$limit)==$s) && $s!=1) {
>
> That's just too complicated to read. The first part seems redundant since 
> you're calculating $s anyway, why re-do it?
>
> // are there extra pages to display?
> if ($s > 1) {
>   echo "show extra pages";
> }
>
>
>>  // not last page so give NEXT link  $PHP_SELF &gt;&gt;
>>  $news="$s+$limit";
>>
>>  echo "&nbsp;<a href='{$_SERVER['PHP_SELF']}?s=$news&q=$var'>Next 10 >>>
>> </a>";
>>
>>  }
>>
>> $a = $s+$limit;
>>  if ($a > $numrows) { $a = $numrows; }
>> $b = $s+1;
>>  echo "<p>Showing results $b to $a of $numrows</p>";
>> include ('footer.inc');
>> ?>
>>
>> I shall highly appreciate if anyone shall have a look at it
>> and let me know where i am wrong.
>>
>> Thank you.
>>
>>
>
>
> -- 
> Postgresql & php tutorials
> http://www.designmagick.com/
>