Jump to content

linking paginate


11Tami

Recommended Posts

Hello, here's some pagination code and my question below it.

 

<?php
mysql_connect('', '', '') or die(mysql_error()); 
mysql_select_db("") or die(mysql_error()); 
if(!isset($_GET['page'])){ 
    $page = 1; 
} else { 
    $page = $_GET['page']; 
} 
//pulls results from database
$max_results = 10;

$total_results = mysql_result(mysql_query("SELECT COUNT(id) FROM business"),0);
//name of query web pages is page
$total_pages = ceil($total_results / $max_results);$page = (int)$_GET['page'];
$from = (($page * $max_results) - $max_results); 
$data = mysql_query("SELECT image, url, webname, description FROM business ORDER BY id ASC LIMIT $from, $max_results") or die(mysql_error()); 
while ($info = mysql_fetch_array($data))
{ 
Print $info['Name']; 
echo "<p><a style='font-weight: bold; color: rgb(0, 0, 140); font-size: 14px;' href='$info[url]' target='_blank'>$info[webname]</a>  <span style='font-size: 14px; font-family: arial,sans-serif; padding-right: 3px;'>$info[description]</span></p>";
} 
//show current and previous page numbers
echo "<br /><br /><span style='margin-left:20px'></span>";
if($page > 1){ 
    $prev = ($page - 1); 
    echo "  <a style='color: rgb(0, 0, 128)' href=\"".$_SERVER['PHP_SELF']."?page=$prev\">Previous<<</a>   "; 
} 

for($i = 1; $i <= $total_pages; $i++){ 
    if(($page) == $i){ 
        echo "<span style='color: rgb(138, 0, 0);font-weight:bold'>$i </span>"; 
        } else { 
            echo "<a style='color: rgb(0, 0, 128)' href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; 
    } 
} 

// build next links 
if($page < $total_pages){ 
    $next = ($page + 1); 
    echo "  <a style='color: rgb(0, 0, 128)' href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>"; 
}
?>

 

When the first page is loaded  or any links with this name like

http://www.awebsite.com/business.php?page=1

 

Then it shows the results for a whole page for the first page, and lists the numbers for the other pages for people to click on or not.

 

The problem I am having is the search engines are also showing this page. http://www.awebsite.com/business.php

and I don't know why. I have no links going to that page but the search engines are finding it automatically anyway. But when people go to that page http://www.awebsite.com/business.php

All it shows is page numbers only and no content. Is there anything I can change in this pagination so that the lowest page found is not http://www.awebsite.com/business.php but http://www.awebsite.com/business.php?page=1 instead?

Please let me know, thanks.

 

 

Link to comment
https://forums.phpfreaks.com/topic/70099-linking-paginate/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.