Please someone help. I want to put the $url which is created into $shorturl = to generate a custom url ($url actually outputs a http://something.com actual link) but don't know how. or can you help me put the $url in header("Location:"
.$url
']); to redirect users to the generated $url from mysql. Please help
<?php include("function.php");
if(!isset($_GET["u"])){ //this is user id
} else if(!isset($_GET['o'])){ //this is offer id
} else {
$offer = mysql_real_escape_string($_GET["o"]);
$checkOffer = mysql_query("SELECT * FROM offers WHERE offerId = '$offer'");
if(mysql_num_rows($checkOffer) == 0){
} else {
$user = $_GET["u"];
$ip = $_SESSION['ip'] ;
$checkIp = mysql_query("SELECT * FROM clicks WHERE clickIp = '$ip' AND offerId = '$offer' AND status = 'complete'");
if(mysql_num_rows($checkIp) != 0){
$outPut = "<h2>Already Complete!</h2><p> You clicked an offer which is now PAUSED for your unique IP.";
} else {
$clickId = rand_string();
$check_clickId = mysql_query("SELECT * FROM clicks WHERE clickId = '$clickId'");
while(mysql_num_rows($check_clickId) != 0){
$clickId = rand_string();
$check_clickId = mysql_query("SELECT * FROM clicks WHERE clickId = '$clickId'");
}
$checkClick = mysql_query("SELECT * FROM clicks WHERE clickIp = '$ip' AND offerId = '$offer' AND status = 'clicked'");
if(mysql_num_rows($checkClick) == 0){
mysql_query("INSERT INTO `clicks` (`clickId`, `clickIp`, `offerId`, `userId`, `status`,`date`,`time`) VALUES ('$clickId', '$ip', '$offer', '$user', 'clicked',NOW(),NOW())");
} else {
while ($row = mysql_fetch_assoc($checkClick)) {
$clickId = $row["clickId"];
}
}
$urlCheck = mysql_query("SELECT * FROM offers WHERE offerId = '$offer'");
while ($row = mysql_fetch_assoc($urlCheck)) {
$url = $row["url"];
}
$url = str_replace("XXX", $clickId, $url);
$url = str_replace("YYY", $user, $url);
}
$clicks = mysql_result(mysql_query("SELECT clicks FROM offers WHERE offerId = '$offer'"), 0);
// Inputs
$shorturl = "http://example.com";
$username = "xxxxx";
$password = "xxxxx";
$siteurl = "http://trck.clix4offer.info";
// Phases url
$yourlsinput = "".$siteurl."/yourls-api.php?action=shorturl&url=".$shorturl."&username=".$username."&password=".$password."" ;
// Open phased url
$fh = fopen($yourlsinput, 'r') or die("can't open file");
//$yourlsoutput = fread($fh,filesize($yourlsinput));
$yourlsoutput = fread($fh,1024);
fclose($fh);
// Converts xml to php array
$xml = simplexml_load_string($yourlsoutput);
$json = json_encode($xml);
$array = json_decode($json,TRUE);
// Output status
echo "
<html><head><title>Yourls</title></head>" ;
echo "<body><p><b>Status:</b> ".$array['status']."<br>";
echo "<b>Message:</b> ".$array['message']."<br>";
echo "<b>Short url:</b> <a href='".$array['shorturl']."'>".$array['shorturl']."</a></p>";
}
}
//Establishing Connection with Server
$connection = mysql_connect("localhost", "user", "pass");
//Selecting Database
$db = mysql_select_db("db", $connection);
//MySQL Query to read data
if(!isset($_GET["u"])){
echo " <h2>OOPS!</h2><p> The link you have followed is INVALID. It would be great, if you could contact support@clix4offer.info to report this issue. REASON: Doesn't contain any PUBLISHER parameter";
} else if(!isset($_GET['o'])){
echo " <h2>No Offers Found!</h2><p> The link you clicked was invalid. REASON: Doesn't contain any CAMPAIGN ID, contact support.";
} else {
$offer = mysql_real_escape_string($_GET["o"]);
$checkOffer = mysql_query("SELECT * FROM offers WHERE offerId = '$offer'");
if(mysql_num_rows($checkOffer) == 0){
echo " <h2>No Offers Failed!</h2><p> The link you clicked was invalid. REASON: Campaign ID is not given by us! Don't trick us. Please try again, if the problem occurs again, contact support.";
} else {
echo $outPut;
}
}
?> </div> <div class="clear"></div> </div> <div class="clear"></div> </div> </body> </html> <?php
//Closing Connection with Server
mysql_close($connection);
?>