Is this from an array?

Jon12345

I have this:

$moveit=urlencode($ad["CLICKURL"]);

Is the $ad["CLICKURL"]) data from an array or MySQL database or something?

laserlight

$ad["CLICKURL"] is definitely an element of an associative array named $ad. Where does this array come from is anyone's wild guess given the data provided.

Jon12345

Ok, I have a page where if you click a url, it takes you to red.php. On red.php you have the following code:

<?
++$key;
include('db/dbconnect.inc');

$ip = $_SERVER['REMOTE_ADDR'];

$ip_query = @mysql_query("SELECT * FROM logfile WHERE Category = '$category' AND SubCategory = '$productname' AND Product = '$filter' AND Keyword = '$keyword' AND Position = '$key' AND IPaddress = '$ip'");

if (mysql_num_rows($ip_query) < 1) {
	mysql_query("insert into logfile(Category, SubCategory, Product, Keyword, Position, Date, Time, Testcode, IPaddress) values('$category', '$productname', '$filter', '$keyword', '$key', curdate(), curtime(), '$test', '$ip')"); 
}

$moveit=urlencode($ad["CLICKURL"]);
header('location: '.$moveit);

?>

But on that page I cannot see anything that shows that it exists. Any ideas?

mrhappiness

maybe you want to have a look into db/dbconnect.inc?

Jon12345

dbconnect is as follows:

<?
mysql_connect("localhost", "username_xxx", "pw") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("username_SiteData"); 
?>

A typical link that someone might click on to get to red.php is as follows:

echo "<a href='../red.php?category=".$category."&productname=".$productname."&filter=".$filter."&key=".$key."&keyword=".$keyword."&test=".$test."&url=".urlencode($ad["CLICKURL"])."'><img src='images/5-stars2.gif' width='156' height='19' border='0'></a>\n";

Does that help?

kakki

maybe you can use a redirect from javascript( after some seconds )
and do an output in that php-script of yours

Jon12345

I am not quite sure what you mean? After some seconds? Seconds after what? Output of what?

kakki

instead of sending the header,

header('location: '.$moveit);

you may print everything you need ( like $_REQUEST??? )
and then

echo '<script>document.location.href="'.$moveit.'"</script>';