Getting a redirect to be nofollow ?

290 100+

Hi,

I am using a dynamic redirect to take vistors to the database stored
url as in this part of the script:

Expand|Select|Wrap|Line Numbers

 
  $sql = "SELECT ad_link FROM adverts WHERE advert_id = $N_ad_id";

     $result = mysql_query($sql)    or die("could not execute find PRODUCTS query". mysql_error());  

         $num = mysql_num_rows($result);
 
         if ($num == 0 ) {

         echo "There an ERROR in locating this product.";

       }  // endif    

         else{       

            $row = mysql_fetch_assoc($result);

                $N_ad_link = "http://".$row["ad_link"];
 
$sql = "UPDATE adverts SET click_cnt = click_cnt+1 WHERE advert_id = $N_ad_id";

mysql_query($sql) or die("could not execute adverts update query". mysql_error());
 
header("Location: $N_ad_link");

exit();

Now I want to ensure that search engine robots and web crawlers do not
index these links. Can I insert a bit of html code to accomplish this ?

EG

Expand|Select|Wrap|Line Numbers

 
$sql = "UPDATE adverts SET click_cnt = click_cnt+1 WHERE advert_id = $N_ad_id";

mysql_query($sql) or die("could not execute adverts update query". mysql_error());
 
echo "

<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"

 \"http://www.w3.org/TR/html4/loose.dtd\">
 
<html>

<head>

<title>Temp Page</title>

<meta name=\"allow-search\" content=\"no\">

<meta name=\"robots\" content=\"all, noindex, nofollow\">

</head>

<body>

header(\"Location: $N_ad_link\");

</body>

</html>";
 
exit();

I have escaped the double quotes because they are inside the
echo statement.

Is the header(\"Location: $N_ad_link\"); in the correct place ?
Do you think this is the best way to do it ?

Thanks for any advice.

PS
Maybe I should use a meta-refresh instead:

So in the above html I will put:

Expand|Select|Wrap|Line Numbers

 
echo "<html>

<head>

<title>Temp Page</title>

<meta name=\"allow-search\" content=\"no\">

<meta name=\"robots\" content=\"all, noindex, nofollow\">

<meta http-equiv ='refresh' content = '0;url = $N_ad_link'>

</head>

<body>

</body>

</html>";

Is this a better method ?

Mar 14 '09 #1

Subscribe Post Reply

3025

Markus

6,050

Expert 4TB

Second example will you a 'headers already sent' error.

I believe setting the header to a 301 redirect will discourage spiders from indexing it - 301 is a permanent move. I may be wrong.

Expand|Select|Wrap|Line Numbers

 
header( "HTTP/1.1 301 Moved Permanently" ); 

header( "Location: ..." );

Mar 14 '09 #2

jeddiki

290

100+

Thanks for your reply,

I should mention that with the
suggestions above, the code is being loaded
from a .htaccess re-write command.

So the rewrite is like this:
RewriteRule ^[\.-a-z]+/bonuses-K([0-9]+)\.html$ ad_linker.php?a=$1 [NC,QSA,L]

and then the ad_linker.php?a=$1 code
will look like this:

Expand|Select|Wrap|Line Numbers

 
require_once("my_functions.php");
 
$today = date("U");
 
if(isset($_GET["a"])){                          

    $N_ad_id = safe_sql($_GET["a"]);
 
      $sql = "SELECT ad_link FROM adverts WHERE advert_id = $N_ad_id";

     $result = mysql_query($sql)    or die("could not execute find PRODUCTS query". mysql_error());  

         $num = mysql_num_rows($result);
 
         if ($num == 0 ) {

         echo "There an ERROR in locating this product.";

       }  // endif    

         else{       

            $row = mysql_fetch_assoc($result);

                $N_ad_link = "http://".$row["ad_link"];
 
     // update database

       $sql = "UPDATE adverts SET click_cnt = click_cnt+1 WHERE advert_id = $N_ad_id";

         mysql_query($sql) or die("could not execute adverts update query". mysql_error());
 
echo "<html>

<head>

<title>Temp Page</title>

<meta name=\"allow-search\" content=\"no\">

<meta name=\"robots\" content=\"all, noindex, nofollow\">

<meta http-equiv ='refresh' content = '0;url = $N_ad_link'>

</head>

<body>

</body>

</html>";  

     exit();

     } // end else

} // endif

echo "No Link data !! - please inform admin";
 
?>

Do you see any problems with this ?

( I don't think headers sent earlier will be a problem as this is a new page,
unless I misunderstood )

Thanks

Mar 15 '09 #3

jeddiki

290

100+

Hi Marcus ( or anyone else)

What did you think of this as a solution ?

Have I misunderstood anything ?
Should it work OK ?

Mar 18 '09 #4

Markus

6,050

Expert 4TB

@jeddiki
Sure, if it works for you, then ok. But it's more code that what is necessary; the page loading the html isn't needed, and will just make it a tad slower. I'm pretty sure my post above would prevent spiders from following the redirect.

Mar 18 '09 #5

Similar topics

Why is session lost on redirect?

by: deko | last post by:

I'm trying to create a very basic login page that will redirect a logged in user to a secure page. I set the session_start variable at the top of the login page, then redirect to securePage.php if...

PHP

Class not getting destroyed on Redirect

by: Steve Lutz | last post by:

Hello, I have a page that creates a class, and then on certain conditions, redirects user to another page. The class has a Class_Terminate() function that saves itself to a database. The class...

ASP / Active Server Pages

On Session_OnStart() getting fired when going from page to page at the same level as the global.asa

by: Steve Mauldin | last post by:

This is a standard ASP application that has several pages at the root withthe global.asa. I set a session variable session("accountid") = "123456" within an asp page and then response.redirect to...

ASP / Active Server Pages

how can I change the http_referer when using response.redirect

by: alex p | last post by:

I have create a website that links to other websites, using a response.redirect("URL_OF_WEBSITE") For some reason I have managed to get on top at Google, with these pages that only redirect to a...

ASP / Active Server Pages

Rel="Nofollow"

by: Philipp Lenssen | last post by:

There's a new quasi-standard in the world of HTML; the <a rel="nofollow" href="...">...</a>. It is already or soon implemented in Google, Yahoo, and MSN Search, as well as many different blogging...

HTML / CSS

Page_Load not getting called?

by: Adam Clauss | last post by:

I have a webapp which consists of several different webforms. Basically: (1) view the contents of a database (2) one is to add a new entry (3) confirms the new entry. The third form, upon...

C# / C Sharp

My Dropdownlist keeps getting repopulated

by: needin4mation | last post by:

I remember in 1.1 that I would put not to populate a given dropdownlist unless it was not Page.IsPostBack. But in 2.0 where I use the DAL and no codefile, I don't see where to effect this. Any...

ASP.NET

URGENT Getting null reference errors on 404??

by: David Lozzi | last post by:

Hello there, I'm getting the following error System.NullReferenceException: Object reference not set to an instance of an object. at shopping_bag.GetBagTotals()

ASP.NET

Adding nofollow tag to all my <a href='...'>

by: FFMG | last post by:

Hi, I run a blog hosting site and it is a fairly small community easy enough to police. But some spammers still find ways to get in. What I was thinking is adding nofollow tags to their links...

PHP

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General