论坛的一些统计,急急,,,,
今日发贴,这个怎么统计,,谢谢...
------解决方案-------------------- <script language=JavaScript>
<!--Karso copyright
var caution = false
function setCookie(name, value, expires, path, domain, secure) {
var curCookie = name + "= " + escape(value) +
((expires) ? "; expires= " + expires.toGMTString() : " ") +
((path) ? "; path= " + path : " ") +
((domain) ? "; domain= " + domain : " ") +
((secure) ? "; secure " : " ")
if (!caution || (name + "= " + escape(value)).length <= 4000)
document.cookie = curCookie
else
if (confirm( "Cookie exceeds 4KB and will be cut! "))
document.cookie = curCookie
}
function getCookie(name) {
var prefix = name + "= "
var cookieStartIndex = document.cookie.indexOf(prefix)
if (cookieStartIndex == -1)
return null
var cookieEndIndex = document.cookie.indexOf( "; ", cookieStartIndex + prefix.length)
if (cookieEndIndex == -1)
cookieEndIndex = document.cookie.length
return unescape(document.cookie.substring(cookieStartIndex + prefix.length, cookieEndIndex))
}
function deleteCookie(name, path, domain) {
if (getCookie(name)) {
document.cookie = name + "= " +
((path) ? "; path= " + path : " ") +
((domain) ? "; domain= " + domain : " ") +
"; expires=Thu, 01-Jan-70 00:00:01 GMT "
}
}
function fixDate(date) {
var base = new Date(0)
var skew = base.getTime()
if (skew > 0)
date.setTime(date.getTime() - skew)
}
var now = new Date()
fixDate(now)
now.setTime(now.getTime() + 365 * 24 * 60 * 60 * 1000)
var visits = getCookie( "counter ")
if (!visits)
visits = 1
else
visits = parseInt(visits) + 1
setCookie( "counter ", visits, now)
document.write( "您是第 " + visits + "访问本专题的! ")
// -->
</script>
------解决方案--------------------用日期函数啊
GETDATA() 当前系统的日期和时间
DAy(日期 )返回某月几号的整数值
------解决方案--------------------或者用这个 http://www.99count.com/ 我觉得在后台写程序判断是否重复提交,多少有点困难。必然是要和访问数据库打交道,这样资源开销挺大的。
------解决方案--------------------今天:
SELECT [字段1],[字段2]
FROM [表]
WHERE datediff(DAY, [时间字段], GETDATE()) = 0
昨天:
SELECT [字段1],[字段2]
FROM [表]
WHERE datediff(DAY, [时间字段], GETDATE()) = 1