php – 如何计算横幅广告展示次数和点击次数

您的方法似乎适用于提供横幅广告,但如果您要进入数据库并跟踪点击次数/展示次数,我建议您全力以赴.因此,请将您的横幅广告属性存储在数据库中.我将继续前进,并假设您的服务器/ Web主机允许一些免费的MysqL数据库.

您需要做的是创建一个数据库,以及数据库的用户/管理员.然后,您将使用MysqL管理器访问数据库,大多数Web主机提供PHPMyAdmin.进入数据库后,需要设置一个表来记录数据.

这是我想要你设置的方式：

|Table Name: Banners      |
|-------------------------|
|Field:    | Type:        |
|-------------------------|
|ID        | int(5)       | The Primary Key and Autoincrement attributes should be set on the ID field as well
|Image     | varchar(100) |
|Url       | varchar(100) |
|Caption   | varchar(100) |
|Views     | int(10)      |
|Clicks    | int(10)      |

现在您已经完成了数据库,这里有一个难点,即PHP.我已经为你做了很多,但它没有经过测试,所以我肯定会有bug,你必须要解决.但它应该指向正确的方向,并帮助你学习.

<?PHP

// First of all,we need to connect to the MysqL server
// For more info,check out: http://PHP.net/manual/en/function.mysql-select-db.PHP
$conn = MysqL_connect("localhost","username","password");
if(!$conn){
    die('Could not connect to the MysqL Server ' . MysqL_error());
}

// Now that we've connected to the MysqL sever,we need to select the database
// More info can be found on the same link as above
$db_selected = MysqL_select_db('my_database',$conn);
if(!$db_selected) {
    die ('Could not select the MysqL Database: ' . MysqL_error());
}

// Now we need to check the URL parameters to see,if we came to this page normally or because a banner was clicked
// If normally,we serve a random banner and increment the Views field in the database
// Otherwise,we increment the Clicks field and direct the user to the banner's URL


if(!isset($_GET['Clicked'])){
    // if the Clicked parameter is not set,we came to the page normally

    // Let's select a random banner from the database
    $result = MysqL_query("SELECT * FROM banners ORDER BY RAND() LIMIT 1") or die(MysqL_error());
    $row = MysqL_fetch_array(result);   

    // Now let's increment the Views field for the banner we selected
    MysqL_query("UPDATE banners SET Views = Views + 1 WHERE ID = '" . $row['ID'] . "'") or die(MysqL_error());

    // let's set the URL to this same page but with the Clicked parameter set
    $url = "banner_server.PHP?Clicked=" . $row['ID'];

    // Last but not least,we have to output the banner HTML
    // Notice,I set the caption on both the 'alt' and 'title' attributes of the 'img' tag,// that's because IE shows the value of the 'alt' tag when an image is hovered,// whereas Firefox shows the value of the 'title' tag,just thought you might want that!
    echo "<a href=\"" . $url . "\"><img src=\"" . $row['Image'] . "\" alt=\"" . $row['Caption'] . "\" title=\"" . $row['Caption'] . "\" /></a>";

}else{
    // Otherwise,increment the Clicks field and redirect

    // First,let's get the ID of the banner that was clicked from the Clicked parameter
    $id = (int)$_GET['Clicked'];

    // Now let's increment the Clicks field for the banner
    MysqL_query("UPDATE banners SET Clicks = Clicks + 1 WHERE ID = '" . $id . "'") or die(MysqL_error());

    // Now let's select the banner from the database so we can redirect to the URL that's associated with it
    $result = MysqL_query("SELECT * FROM banners WHERE ID = '" . $id . "'") or die(MysqL_error());
    $row = MysqL_fetch_array(result);

    // redirect to the URL
    header("location: " . $row['Url']);
}


// Close the MysqL connection
MysqL_close($conn);

?>

祝好运