Pagination for search results

[music_man]

Hi

Any ideas on how I can add pagination to this search script?

<?php require("xxx.php"); dbconnect();

  $search = $_GET["search"];  

  if(isset($search)) {

  if($search) {
  echo "<p class=\"large_heading\">
  Search: $search</p>";


    $result = mysql_query("SELECT * FROM xxx WHERE content LIKE '%$search%'");

    if (mysql_num_rows($result) > 0) {


    echo "<ol>";

    while($row = mysql_fetch_array($result))
    {

    $pre_content = $row[2];
    $string_length = 100;
    $count = strlen($pre_content);
    if  ($count >= 100) {
    $content_almost = trim(substr($pre_content,0,$string_length)); 
    $content_there = $content_almost . "...";
    }
    else {
    $content_there = $pre_content;
    }

    echo "<li><a href=\"xxx.php?view=single&amp;id=$row[0]\">" . $row[1] . "</a>&nbsp;::&nbsp;" . $row[3] . "<br /><br />". $content_there ."</li>";

    }
    }

    else {

    echo "<p class=\"notice\">Sorry there were no results for <b>" . $search . "</b></p>";

    }

    dbdisconnect();
    }

    else {

    echo "<p class=\"notice\">Please submit a search first</p>";

    }
    }
  ?>

Or any tutorials you could point me at.

[Shaped]

Hello Music man

Sorry i carnt create the code for you, not got time. Best i can do is pass you a working copy of pagination that i use for a tagboard.

Its not to hard to work out and rip apart for your query.

Hope it helps..

		

$admin_settings['tagpagelimit'] = 30;

if ( isset ( $_GET['page'] ) && is_numeric( $_GET['page'] ) )
{
	$page = $_GET['page'];
}
else
{
	$page = 1;
}

if ( $admin_settings['tagpagelimit'] == "" )
{
	$limit = 25;
}
else
{
	$limit = $admin_settings['tagpagelimit'];
}

$start = ( $page -1) * $limit;


$sql = mysql_query("SELECT * FROM " . user_tagboard . " ORDER BY time DESC LIMIT $start, $limit") or die("".mysql_error());

if ( mysql_affected_rows() > 0 )
{
	$content .= '<div style="width:100%; text-align:right;">';

	$content .= pageinatetags();

	$content .= '</div>';

	$content .= '<br /><br />';

	$content .= Tableholder_Open();

	$content .= '<table id="content2" cellspacing="0" cellpadding="0" border="0" width="100%">';

	while ( $a = mysql_fetch_array ( $sql ) )
	{

			$content .= '<tr>';

			$content .= '<td>';

			$content .= '<strong>'.stripslashes(ucfirst($a['tag_name'])).'</strong>&nbsp;---&nbsp;<i>'.format_timestamp($a['time'],1).'</i>';

			$content .= '<br />';

			$content .= stripslashes($a['tag']);

			$content .='</td></tr>';

			$content .= '<tr><td>&nbsp;</td></tr>';
	}

	$content .= '</table>';

	$content .= Tableholder_Close();

	$content .= '<br /><br />';		

	$content .= '<div style="width:100%; text-align:right;">';

	$content .= pageinatetags();

	$content .= '</div>';




}
else
{
	$content .= Tableholder_Open();
	$content .= 'No tags found';
	$content .= Tableholder_Close();
}


echo $content;

function pageinatetags()
{
	global $admin_settings;

	$limit = $admin_settings['tagpagelimit'];

	if ($limit == '' || $limit == 0 )
	{
		$limit = 20;
	}

	$total = mysql_result(mysql_query("SELECT COUNT(*) FROM " . user_tagboard),0) or die("".mysql_error());


	if ($total > $limit)
	{
		if ( isset ($_GET['page']) && is_numeric ( $_GET['page'] ) )
		{
			$page = $_GET['page'];
		}
		else
		{
			$page = 1;
		}
	}
	else
	{

		$pagelinks .= '<span class="pageprev">&lt; Prev</span>&nbsp;&nbsp;';
		$pagelinks .= '<span class="pagenext">Next &gt;</span>&nbsp;&nbsp;';
	}



	if ( $page == 1)
	{
		$pagelinks .= '<span class="pageprev">&lt; Prev</span>&nbsp;&nbsp;';
	}
	else
	{
		$pageprev = $page - 1;
		$pagelinks .= '<a class="pageprev" href="viewtags.php?page='.$pageprev.'">&lt; Prev</a>&nbsp;&nbsp;';
	}

	$numofpages  = ceil($total / $limit);
	$range = $limit;
	if ($range == "" || $range == 0 )
	{
		$range = 7;
	}


	$lrange = max(1,$page-(($range-1)/2));
	$rrange = min($numofpages,$page+(($range-1)/2));

	if (($rrange - $lrange) < ($range - 1))
	{
		if ($lrange == 1)
		{
			$rrange = min($lrange + ( $range-1), $numofpages );
		}
		else
		{
			$lrange = max($rrange - ( $range-1),0);
		}
	}


	if ($lrange > 1 )
	{
		$pagelinks .= '<a href="viewtags.php?page=1">First</a>&nbsp;&nbsp;</a>';
	}
	else
	{
		$pagelinks .= "&nbsp;&nbsp";
	}

	for ($i = 1; $i <= $numofpages; $i++)
	{
		if ($i == $page)
		{
			$pagelinks .= '<span>'.$i.'</span>&nbsp;&nbsp;';
		}
		else
		{
			if ($lrange <= $i && $i <= $rrange)
			{
				$pagelinks .= '<a href="viewtags.php?page='.$i.'">'.$i.'&nbsp;&nbsp;</a>';
			}
		}

	}
	if ($rrange < $numofpages )
	{
		$pagelinks .= '<a class="pagelast" href="viewtags.php?page='.$numofpages.'">Last</a>&nbsp;&nbsp;</a>';;
	}
	else
	{
		$pagelinks .= "&nbsp;&nbsp";
	}	

	if (($total - ($limit * $page)) > 0 )
	{
		$pagenext = $page + 1;
		$pagelinks .= '<a href="viewtags.php?page='.$pagenext.'">Next &gt;</a>';
	}
	else
	{
		$pagelinks .= '<span>Next &gt;</span>';
	}


return $pagelinks;
}

[Shaped]

Sorry a but more clearer..

Parts u will need.

    if ( isset ( $_GET['page'] ) && is_numeric( $_GET['page'] ) ) 
    { 
        $page = $_GET['page']; 
    } 
    else 
    { 
        $page = 1; 
    } 

if ( $admin_settings['tagpagelimit'] == "" ) 
{ 
    $limit = 25; 
} 
else 
{ 
    $limit = $admin_settings['tagpagelimit']; 
} 

$start = ( $page -1) * $limit; 

function pageinatetags() 
    { 
        global $admin_settings; 

    $limit = $admin_settings['tagpagelimit']; 

    if ($limit == '' || $limit == 0 ) 
    { 
        $limit = 20; 
    } 

    $total = mysql_result(mysql_query("SELECT COUNT(*) FROM " . user_tagboard),0) or die("".mysql_error()); 


    if ($total > $limit) 
    { 
        if ( isset ($_GET['page']) && is_numeric ( $_GET['page'] ) ) 
        { 
            $page = $_GET['page']; 
        } 
        else 
        { 
            $page = 1; 
        } 
    } 
    else 
    { 

        $pagelinks .= '<span class="pageprev">&lt; Prev</span>&nbsp;&nbsp;'; 
        $pagelinks .= '<span class="pagenext">Next &gt;</span>&nbsp;&nbsp;'; 
    } 



    if ( $page == 1) 
    { 
        $pagelinks .= '<span class="pageprev">&lt; Prev</span>&nbsp;&nbsp;'; 
    } 
    else 
    { 
        $pageprev = $page - 1; 
        $pagelinks .= '<a class="pageprev" href="viewtags.php?page='.$pageprev.'">&lt; Prev</a>&nbsp;&nbsp;'; 
    } 

    $numofpages  = ceil($total / $limit); 
    $range = $limit; 
    if ($range == "" || $range == 0 ) 
    { 
        $range = 7; 
    } 


    $lrange = max(1,$page-(($range-1)/2)); 
    $rrange = min($numofpages,$page+(($range-1)/2)); 

    if (($rrange - $lrange) < ($range - 1)) 
    { 
        if ($lrange == 1) 
        { 
            $rrange = min($lrange + ( $range-1), $numofpages ); 
        } 
        else 
        { 
            $lrange = max($rrange - ( $range-1),0); 
        } 
    } 


    if ($lrange > 1 ) 
    { 
        $pagelinks .= '<a href="viewtags.php?page=1">First</a>&nbsp;&nbsp;</a>'; 
    } 
    else 
    { 
        $pagelinks .= "&nbsp;&nbsp"; 
    } 

    for ($i = 1; $i <= $numofpages; $i++) 
    { 
        if ($i == $page) 
        { 
            $pagelinks .= '<span>'.$i.'</span>&nbsp;&nbsp;'; 
        } 
        else 
        { 
            if ($lrange <= $i && $i <= $rrange) 
            { 
                $pagelinks .= '<a href="viewtags.php?page='.$i.'">'.$i.'&nbsp;&nbsp;</a>'; 
            } 
        } 

    } 
    if ($rrange < $numofpages ) 
    { 
        $pagelinks .= '<a class="pagelast" href="viewtags.php?page='.$numofpages.'">Last</a>&nbsp;&nbsp;</a>';; 
    } 
    else 
    { 
        $pagelinks .= "&nbsp;&nbsp"; 
    }     

    if (($total - ($limit * $page)) > 0 ) 
    { 
        $pagenext = $page + 1; 
        $pagelinks .= '<a href="viewtags.php?page='.$pagenext.'">Next &gt;</a>'; 
    } 
    else 
    { 
        $pagelinks .= '<span>Next &gt;</span>'; 
    } 


return $pagelinks; 
} 

And change ur sql query to look something like

$sql = mysql_query("SELECT * FROM " . user_tagboard . " ORDER BY time DESC LIMIT $start, $limit") or die("".mysql_error()); 

[music_man]

Hi thanks for the code!

Can it show where abouts in the search results you are?

[music_man]

Hi

Got it going:

Thanks.