Hiding Affiliate Link URL's?

[D-Mac]

Tweet

Change link.php to this:


<?php

include ("db_connect.php"); // include your code to connect to DB.

$sql="SELECT * FROM test WHERE id='".$_GET['product']."'";
$result= mysql_query($sql);
$data=mysql_fetch_assoc($result);
if ($data['url']){


echo "This is your afflink ".$data['link'];
exit;
}
else
{
echo "something went wrong!";
}
?>


Then click one of your images, and see what message, if any is displayed.

[paul1107]

Sorry to get you into this D-Mac but still the same thing happen opens a blank page

However as the same include file "db_connect.php" pulls all the other info that shows on the page I can't see how that same file is the problem?

I'm trying to use the row id which has a column header if "id" as a substitute for the affiliate link which has a column header "link". I thought maybe I have the wrong info in some of the queries?

Just can't understand why it is showing up a blank page despite your changes

[D-Mac]

Hey, no probs, my wife is watching the box, so I am sitting here with the laptop :blush

It seems like php error reporting is disabled on your server, so it hard to know what's wrong without seeing the exact code. It might be a syntax error in your code. E.g. a missing semi-colon.

Can you post the exact code here for the whole link.php file

[paul1107]

I'm a celebrity's got a lot to answer for!

the code is as I showed earlier

<?php

include ("db_connect.php");   // include your code to connect to DB.

$sql="SELECT * FROM test WHERE id='".$_GET['Product']."'";
$result= mysql_query($sql);
$data=mysql_fetch_assoc($result);
if ($data['link']){
$sql="INSERT INTO links VALUES ('".$_GET['Product']."','otherdata','ipaddress')";
$result= mysql_query($sql);
header("Location: ".$data['link']);
exit;
}
else
{
//Your failure code
}
?>

[D-Mac]

capital 'P' on Product should be a lowercase 'p'

There are 2 instances of this.

If this doesn't work, change the lowercase 'p' in your href to a 'P'

[paul1107]

Well, I'm afraid the results are the same, I appreciate all your efforts tonight but it seems a little more complicated than originally expected.

I'm off to bed as my brain hurts and I've had a couple of beers and maybe fresh eyes tomorrow will pick something up

thanks again

[Travel Pixel]

try this?

AFFILIATE CITIZEN Redirect Script for Affiliate Sites in PHP

Dave

[paul1107]

Hi Dave,

thanks for spending the time to comment.

I looked at this previously, as it's mentioned in lots of blogs, but it's not relevant for large amounts of links being pulled from data feeds.

thanks