full text search and pagination

wood1e

hi,

I apologise now just incase I am in the wrong forum...

I have used a tutorial to create a full text search...But the problem I have is adding in pagination. HAving looked through this website, I have found many solutions, and got them working on my localhost.

But I need to join the full search code and the pagination code...so the results of the search are paginated...

Can anyone help...I have attached the search code...


<html>
<head><title>Search</title></head>
<body>

<?php

// Database Connection 
include 'db.php';


// Create the search function:

function searchForm()
{
  // Re-usable form

  // variable setup for the form.
  $searchwords = (isset($_GET['words']) ? htmlspecialchars(stripslashes($_REQUEST['words'])) : '');
  $normal = (($_GET['mode'] == 'normal') ? ' selected="selected"' : '' );
  $boolean = (($_GET['mode'] == 'boolean') ? ' selected="selected"' : '' );

  echo '<form method="get" action="'.$_SERVER['PHP_SELF'].'">';
  echo '<input type="hidden" name="cmd" value="search" />';
  echo 'Search for: <input type="text" name="words" value="'.$searchwords.'" />&nbsp;';
  echo 'Mode: ';
  echo '<select name="mode">';
  echo '<option value="normal"'.$normal.'>Normal</option>';
  echo '<option value="boolean"'.$boolean.'>Boolean</option>';
  echo '</select>&nbsp;';
  echo '<input type="submit" value="Search" />';
  echo '</form>';
}




// Create the navigation switch
$cmd = (isset($_GET['cmd']) ? $_GET['cmd'] : '');

switch($cmd)
{
  default:
    echo '<h1>Search Database!</h1>';
    searchForm();

  break;


  case "search":
    searchForm();
    echo '<h3>Search Results:</h3><br />';

$searchstring = mysql_escape_string($_GET['words']);
switch($_GET['mode'])
{
  case "normal":
    $sql = "SELECT id, author, title, caption, dts, 
           MATCH(author, title, caption, full_body) 
           AGAINST ('$searchstring') AS score FROM user 
           WHERE MATCH(author,title, caption, full_body) 
           AGAINST ('$searchstring') ORDER BY score DESC";
  break;

  case "boolean":
    $sql = "SELECT id, author, title, caption, dts, 
           MATCH(author, title, caption, full_body) 
           AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM user 
           WHERE MATCH(author, title, caption, full_body) 
           AGAINST ('$searchstring' IN BOOLEAN MODE) ORDER BY score DESC";
  break;
} 

// echo $sql;

$result = mysql_query($sql) or die (mysql_error());

while($row = mysql_fetch_object($result))
{
  echo '<strong>Title: '.stripslashes(htmlspecialchars($row->title)).'</strong><br />';
  echo '<strong>Author: '.stripslashes(htmlspecialchars($row->author)).'</strong><br />
  ';
  echo 'Score:'. number_format($row->score, 1).' Date: '.date('d/m/y', $row->dts).'<br />';
  echo '<p>'.stripslashes(htmlspecialchars($row->caption)).'</p>';
  echo '<hr size="1" />';
}
  break;
}




?>

</body>
</html>

[code=php]

lucasrd

Try using a query similar to this:

   $sql = "select SQL_CALC_FOUND_ROWS * from news where approved='1' order by story_date desc limit $offset,$results_per_page";

   $result = mysql_query($sql);

   $sql = "select FOUND_ROWS()";
   $count_result = mysql_query($sql);
   $count =    mysql_fetch_array($count_result);

This will give you two things, a subset of results starting at record # offset and returning $results_per_page results. It will also give you the total number of rows that would have been returned had you not limited the result set.

You can then use the result set in your pagination, and use the number of results that woudl have been returned to display your page numbers at the bottom of the page.

Here's how I would display page numbers:

   $pages = 0;

   while($count > 0){
         echo "<a href='index.php?module=news&action=news&offset=".($pages*$results_per_page)."'>" . ($pages + 1) . "</a>&nbsp;&nbsp;";
         $count = $count - $rpp;
         $pages++;
   }

wood1e

Hi, many thanks for that....the problem is I am very new at this...PHP that is...and I am liable now to sound a syupid, but...can you explain a little as to where the code goes?

Many thanks