next and previous links on results page.

danville

I have a simple search engine for a site I am working on which works fine for what I need it to do. The question I have is can I alter the code below so that it will display the first 10 results on one page and the have next and previous link for the rest of the results. I have looked at few tutorials but have not been able to make sense of them. Thanks in advance for any help.

search.html:
<html>
<head>
<title>Site Search</title>
</head>
</body>
Search:
<form method="post" action="sitesearch.php">
<input type="text" name="search" size=25 maxlength=100>
<input type="Submit" name="Submit" value="Search">
</form>
</body>
</html>

sitesearch.php:

<html>
<head>
<title>Site Search</title>
</head>
</body>
Search:
<form method="post" action="<? echo ($_SERVER[PHP_SELF]);?>">
<input type="text" name="search" size=25 maxlength=100>
<input type="Submit" name="Submit" value="Search">
</form>
<?
$db=mysql_connect("host", "user", "pass");
mysql_select_db("search",$db);
$search=$_POST["search"];

$result = mysql_query("SELECT * FROM data WHERE about LIKE '%$search%' OR title LIKE '%$search%'",$db);
$numRows = mysql_num_rows( $result );

if( $numRows > 0 ) {
      echo "<font color=red>Your search returned $numRows results.</font>";
      echo "<br>";
      echo "<br>";
    while( $row = mysql_fetch_assoc( $result ) ) {
        printf("<b><a href=%s>%s</a></b>", $row['Link'], $row['Title']);
        echo "<br>";
        echo $row['About'];
        echo "<br>";
        echo "<br>";
    }
}
else {
    echo "No Records Found!";
}
?>
</body>
</html>

mystrymaster

search for pagination and you will find it

BeastRider

Here is a simple example of ten records per page. Pass a page number in the URL. Let's say that you are going to get the first set of records. Then you'd pass

http://www.mydomain.com/pagescript?pageid=1

Then pagescript looks like:

<?php
// clean up input
$pageid = substr($pageid, 0, 3); // or however big page max is
$pageid = EscapeShellCmd($pageid);

// build query - using 10 recs per page - but we read 11 rows to
// have a way of knowing if we are at end of file so we don't put
// out the 'next page' link
$skiprows = (($pageid - 1) * 10); // number of rows to skip in query
$query = "SELECT * FROM $table
                   LIMIT $skiprows, 11";

// connect to the database
if(!($dbh=mysql_connect ("localhost",
                         "$user",
                         "$pass")))
  die("Cannot connect to the database");

// open the connected database
if (!mysql_select_db("$dbname",$dbh))
  die("Cannot open the database");

// execute the query
if (!($result = @ mysql_query ($query, $dbh)))
  die("Cannot execute query against the database");

// if we got some rows back then get some numbers and output page
$numrows = mysql_num_rows($result);
if ($numrows > 0)
  {
  for ($i = 1; $i <= 10; $i++)
    {
     // last page may have less than 10 rows 
    if ($row = @ mysql_fetch_array($result))
      {
      // do all the stuff to put out the row
      } // if there are rows in array
    } // for i

  // now put out next and previous links
  // if not on page 1, then do previous
  if ($pageid > 1)
    {
    $oldpageid = $pageid - 1;
    echo "<a href=\"pagescript.php?pageid=$oldpageid\">";
    echo "Go Back to Page $oldpageid</a>";
    }

  // if rowcount less than 11, must be last page otherwise do link
  if $(numrows > 10) // there will be a next page
    {
    $newpageid = $pageid + 1;
    echo "<a href=\"pagescript.php?pageid=$newpageid\">";
    echo "Go Forward to Page $newpageid</a>";
    }
  } // if $numrows > 0
?>

You can also get a little fancier and fix up the script so that you don't get a last page with one or two orphaned entries... you make the current page 1 or 2 entries longer.