Question

I want to create a user history function that allows shows users what they done. ex: commented on an ad, posted an ad, voted on an ad, etc.

我如何这样做?

I was thinking about... in my site, when they log in it stores their user_id ($_SESSION[ user_id ])

so I guess whenever an user posts an ad(postad.php), comments(comment.php), I would just store in a database table "userhistory" what they did based on whenever or not their user_id was activate.

When they comment, I store the user_id in the comment dbc table, so I ll also store it in the "userhistory" table.

And then I would just queries all the rows in the dbc for the user to show it

任何步骤/改进我可以做吗?

Answer 1

查阅媒体图象的统计和记录部分。你们可以执行类似的情况。

Answer 2

同样,你可以做的是我的SQL制成的伐木,因此,我的SQL数据库将每一页打上,该数据库追踪IP、使用、日期和所要求的网页。

然后,在你看来历史的网页上,你可以有这样的文字。这只是伪装的法典,因此认为它具有价值。

<?php
    $actions = array( comment.php  =>  posted a comment , "postedad.php" => "posted an ad");

    $query = mysql_query("SELECT * FROM logHits JOIN users ON users.id = logHits.userid WHERE loghits.userid = $userid");

    while ($row = mysql_fetch_array($query)) { 
         echo $row[ username ]." ".$actions[$row[ pagename ]."<br />"; 
   }
?>

再说一遍,这只是伪装,你当然能够改进这一概念。您可能使用印刷版(印刷版)/印刷版(印刷版)等组合,并在行动文本与实际评论的超文本链接中作出“评论”。

要做到这一点,有几个途径。这或许是最好的。

您也可在用户等表格上插入询问。每当这些人采取与你所述的行动时,历史就是如此。这可能是实现这一目标的最佳途径。你们能够拥有诸如id、使用、行动类型、行动性等领域

行动类型为“comment”或“comment”,行动方式是贴出入境口。然后,你可以很容易地将行动类型绘制到评论页(绕过行动),以了解实际发表的评论。

友情链接