不对的地方请高手赐教
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`mid` INTEGER UNSIGNED NOT NULL,
`
IP` VARCHAR(45) NOT NULL,
`aid` INTEGER UNSIGNED NOT NULL,
`logintime` VARCHAR(45) NOT NULL,
PRIMARY KEY (`id`)
)
新建php
文件count_zj.php 存放到puls
目录下
内容如下
02 |
require_once( dirname (__FILE__). "/../include/common.inc.php" ); |
03 |
require_once( dirname (__FILE__). "/../member/config.php" ); |
14 |
$row = $dsql->GetOne( " Select * From `dede_zj` where aid=’$aid’ and mid=’$mid’" ); |
16 |
$dsql->ExecuteNoneQuery("INSERT INTO dede_zj( ` id `, `mid`, `ip`,`aid` ,`logintime`) |
17 |
VALUES ( ”,$mid, ‘$joinip’,$aid,$nowTime) "); |
19 |
$db->SetQuery( "
Select title From dede_archives join dede_zj on
dede_archives.id=dede_zj.aid where dede_zj.mid=’$mid’ order by logintime
desc limit 1,5" ); |
21 |
while ($row = $db->GetArray()) |
23 |
echo "document.write(‘" .$row[ 'title' ]. "’);\r\n" ; |
28 |
$m = $dsql->GetOne( " Select * From `dede_zj` where aid=’$aid’ and ip=’$joinip’" ); |
30 |
$dsql->ExecuteNoneQuery("INSERT INTO dede_zj( ` id `, `mid`, `ip`,`aid` ,`logintime`) |
31 |
VALUES ( ”,$mid, ‘$joinip’,$aid,$nowTime) "); |
33 |
$db->SetQuery( "
Select title From dede_archives join dede_zj on
dede_archives.id=dede_zj.aid where dede_zj.ip=’$joinip’ order by
logintime desc limit 1,5" ); |
35 |
while ($row = $db->GetArray()) |
37 |
echo "document.write(‘" .$row[ 'title' ]. "’);\r\n" ; |
|
在文章模板处添加如下语句
02 |
<script src= "{dede:field name=’phpurl’/}/count_zj.php?view=yes&aid={dede:field name=’id’/}&mid={dede:field name=’mid’/}" type =’text/javascript’ language= "javascript" ></script> |
03 |
<script type = "text/javascript" > |
05 |
document.getElementById( "zj" ).innerHTML = document.getElementById( "span_zj" ).innerHTML; |
07 |
document.getElementById( "span_zj" ).innerHTML = "" ; |
|
在引用处直接添加<SPAN id="span_zj"></SPAN>排
版本人不在行,
功能上是可以实现的,望各位自己酌情处理
补充一点,关于最近浏览
链接的
问题
02 |
require_once( dirname (__FILE__). "/../include/common.inc.php" ); |
03 |
require_once( dirname (__FILE__). "/../member/config.php" ); |
14 |
$row = $dsql->GetOne( " Select * From `dede_zj` where aid=’$aid’ and mid=’$mid’" ); |
16 |
$dsql->ExecuteNoneQuery("INSERT INTO dede_zj( ` id `, `mid`, `ip`,`aid` ,`logintime`) |
17 |
VALUES ( ”,$mid, ‘$joinip’,$aid,$nowTime) "); |
19 |
$db->SetQuery( "
Select title,dede_archives.id From dede_archives join dede_zj on
dede_archives.id=dede_zj.aid where dede_zj.mid=’$mid’ order by logintime
desc limit 1,5" ); |
21 |
while ($row = $db->GetArray()) |
23 |
echo "document.write(\"<a href=’view.php?aid=" .$row[ 'id' ]. "’>\");" ; |
24 |
echo "document.write(‘" .$row[ 'title' ]. "’);" ; |
25 |
echo "document.write(\"</a>\");\r\n" ; |
30 |
$m = $dsql->GetOne( " Select * From `dede_zjw` where aid=’$aid’ and ip=’$joinip’" ); |
32 |
$dsql->ExecuteNoneQuery("INSERT INTO dede_zjw( ` id `, `mid`, `ip`,`aid` ,`logintime`) |
33 |
VALUES ( ”,$mid, ‘$joinip’,$aid,$nowTime) "); |
35 |
$db->SetQuery( "
Select title,dede_archives.id From dede_archives join dede_zj on
dede_archives.id=dede_zj.aid where dede_zjw.ip=’$joinip’ order by
logintime desc limit 1,5" ); |
37 |
while ($row = $db->GetArray()) |
39 |
echo "document.write(\"<a href=’view.php?aid=" .$row[ 'id' ]. "’>\");" ; |
40 |
echo "document.write(‘" .$row[ 'title' ]. "’);" ; |
41 |
echo "document.write(\"</a>\");\r\n" ; |
|
覆盖上面的php文件