php – 制作子网和回发跟踪工作

1)使用以下字段在MySQL中创建事务表：

TRANSACTIONS
############
id - INT,AUTO-INCREMENT,UNSIGNED,NOT NULL
transaction_id - VARCHAR(8)
created_on - TIMESTAMP,DEFAULT CURRENT_TIMESTAMP()

2)使用以下字段在MySQL中创建转换表：

CONVERSIONS
###########
id - INT,DEFAULT CURRENT_TIMESTAMP()

3)在您的代码中,在将它们发送到URL之前,您需要生成并附加唯一的事务ID(a.k.a Sub ID)：

/**
* Generates [$length] character transaction ID's. Verifies transaction ID is not
* currently in use. If it is,function recursively attempts to generate
* a unique one. After 10 attempts,it fails and returns false.
*
* @param PDO    Database connection via dependency injection
* @param Int    Length of string to generate
*/
function generateTransactionId($db,$length = 8)
{
// Don't let this function get stuck in endless recursion.
static $recursion_count = 0;
$recursion_count++;
if($recursion_count > 10) 
{
    $recursion_count = 0; 
    return false; 
}

// Create transaction ID
$transaction_id = substr(md5(uniqid(mt_rand(),true)),$length);

// Check to make sure it is unique
$query = "SELECT id FROM myDb.transactions WHERE transaction_id = ?";
$stmt = $db->prepare($query);
$stmt->execute(array($transaction_id));
$row = $stmt->fetch(PDO::FETCH_OBJ);
$stmt = null;

// If nothing found,we have a unique ID. Otherwise recursively find a unique one.
if(!is_object($row) || $row == false)
{
    // Reset recursion counter
    $recursion_count = 0;

    // Found unique ID
    return $transaction_id;
}
else
{
    // Recursively generate unique transaction ID
    return generateTransactionId($db);
}
}

$url = "http://www.google.com/";
$transaction_id = generateTransactionId($myPDOConnection);

// Add to URL
$url = $url . "?c3=" . $transaction_id;

// Do redirect to URL
header('Location: ' . $url);

4)在另一个用于接收回发的脚本中,您将希望通过GET获取子ID /交易ID(如果您愿意,可以使用POST)并标记转换：

$transaction_id = isset($_GET['c3']) ? trim($_GET['c3']) : false;

if($transaction_id)
{
   // Received conversion,add this transaction ID to conversions table
}

就实时比较而言,您可以访问的唯一指标是重定向之前的时间点以及收到回发的时间点.您可以通过检查事务表中的COUNT()来查看已完成的重定向次数.您可以通过查看转化表中的COUNT()来查看收到的回复/转化次数.