本留言板程序使用了无限级分类的原理,可以实现无限级留言与回复。留言列表gclist保留了留言层次空格,使留言--回复层次分明.
功能上,本程序可以实现无限级留言与回复,即对留言回复,对回复的留言回复。当然你也可以作有限制的控制,使其只对留言回复,关键是在模板代码中去掉回复的留言中的“回复该留言”即可。欢迎去拍砖!
程序效果演示:w3note点com/guestbook
完整的留言程序代码下载:www点w3note点com-- ----------------------------<br>
-- Table structure for `wb_guestbook`<br>
-- ----------------------------<br>
DROP TABLE IF EXISTS `wb_guestbook`;<br>
CREATE TABLE `eway_guestbook` (<br>
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br>
`pid` int(10) NOT NULL,<br>
`email` varchar(50) NOT NULL,<br>
`path` varchar(100) NOT NULL,<br>
`username` varchar(30) NOT NULL,<br>
`updatetime` int(10) NOT NULL,<br>
`ip` varchar(15) NOT NULL,<br>
`url` varchar(200) NOT NULL,<br>
`inputtime` int(10) NOT NULL,<br>
`content` text NOT NULL,<br>
`verify` varchar(32) NOT NULL,<br>
`isreply` tinyint(1) NOT NULL,<br>
`status` tinyint(1) NOT NULL,<br>
PRIMARY KEY (`id`)<br>
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;<br>
<br>
控制器GuestbookAction.class.php<br>
<?php <br />
// +----------------------------------------------------------------------<br>
// | WBlog<br>
// +----------------------------------------------------------------------<br>
// | Copyright (c) 2008 www点w3note点com All rights reserved.<br>
// +----------------------------------------------------------------------<br>
// | Author: 网菠萝果<br>
// +----------------------------------------------------------------------<br>
// $Id$<br>
/**<br>
+------------------------------------------------------------------------------<br>
* @class 留言板控制器GuestbookAction.class.php<br>
+------------------------------------------------------------------------------<br>
*/<br>
class GuestbookAction extends CommonAction {<br>
public function index(){<br>
$garr= D('Guestbook')->gclist("id,username,inputtime,pid,url,content,path,concat(path,'-',id) as bpath");<br>
<br>
$this->assign('Gklist', $garr['list']);<br>
$this->assign('page',$garr['page']);<br>
$this->display();<br>
}<br>
// +----------------------------------------------------------------------<br>
// | 添加留言<br>
// +----------------------------------------------------------------------<br>
<br>
public function add(){<br>
$this->adddata('Guestbook');<br>
<br>
}<br>
// +----------------------------------------------------------------------<br>
// | 网址跳转。如在表单url添加网址的话,点击会跳转到相关网站<br>
// +----------------------------------------------------------------------<br>
<br>
public function tourl(){<br>
$this->gettourl('Guestbook');<br>
} <br>
}<br>
?><br>
<?php <br />
// +----------------------------------------------------------------------<br>
// | WBlog<br>
// +----------------------------------------------------------------------<br>
// | Copyright (c) 2008 w3note点com All rights reserved.<br>
// | Author: 网菠萝果<br>
// +----------------------------------------------------------------------<br>
// $Id$<br>
/**<br>
+------------------------------------------------------------------------------<br>
* @function 留言板模型<br>
+------------------------------------------------------------------------------<br>
*/<br>
<br>
class GuestbookModel extends RelationModel{<br>
// +----------------------------------------------------------------------<br>
// | $_validate表单自动验证<br>
// +----------------------------------------------------------------------<br>
<br>
protected $_validate = array(<br>
array('email','require','请填写您的邮箱!'),<br>
array('email','email','邮箱格式错误!'), <br>
<br>
);<br>
// +----------------------------------------------------------------------<br>
// | $_auto表单自动填充<br>
// +----------------------------------------------------------------------<br>
<br>
protected $_auto=array(<br>
array('status','1'), <br>
array('inputtime','time',1,'function'),<br>
array('content','content',1,'callback'),<br>
array('url','geturl',1,'callback'), <br>
array ('inputtime','time',1,'function'),<br>
array('path','path',3,'callback'), <br>
array('username','getusername',3,'callback'), <br>
); <br>
// +----------------------------------------------------------------------<br>
// | getusername()过滤用户名<br>
// +---------------------------------------------------------------------- <br>
public function getusername(){<br>
if (isset ($_POST['username'])) {<br>
if(trim($_POST['username'])=='网菠萝果'){<br>
return $data= ' ̄□ ̄'; <br>
}elseif(strlen($_POST['username']) >10){ <br>
return $data= msubstr($_POST['username'],0,5);<br>
}else{<br>
return $data= $_POST['username'];<br>
}<br>
} <br>
} <br>
// +----------------------------------------------------------------------<br>
// | path()返回子类的path,父类的path的值为0<br>
// +---------------------------------------------------------------------- <br>
public function path(){<br>
$pid=isset($_POST['pid'])?(int)$_POST['pid']:0;<br>
$id=$_POST['id'];<br>
if($pid==0){ <br>
return 0;<br>
}<br>
<br>
$fat=$this->where(array('id' => $pid))->find();<br>
$data=$fat['path'].'-'.$fat['id']; <br>
return $data;<br>
}<br>
// +----------------------------------------------------------------------<br>
// | content()过滤留言内容<br>
// +---------------------------------------------------------------------- <br>
public function content() {<br>
if (isset ($_POST['content']) && !empty ($_POST['content'])) {<br>
$data =deleteHtmlTags($_POST['content']);<br>
$data =safeHtml($data);<br>
if (strlen($data) > 1000) {<br>
$data = msubstr($data, 0, 500);<br>
}<br>
return $data;<br>
}<br>
}<br>
// +----------------------------------------------------------------------<br>
// | content()过滤URL<br>
// +---------------------------------------------------------------------- <br>
public function geturl(){<br>
if (isset ($_POST['url'])) {<br>
$data = deleteHtmlTags($_POST['url']);<br>
$data = safeHtml($data);<br>
return $data=$data?$data:"";<br>
}<br>
} <br>
// +----------------------------------------------------------------------<br>
// |gclist($field,$where='',$pagesize=30)留言列表<br>
// +----------------------------------------------------------------------<br>
// |$field,字段<br>
// +----------------------------------------------------------------------<br>
// |$where查询条件,默认为空<br>
// +----------------------------------------------------------------------<br>
// |$pagesize分页记录,默认为30 <br>
// +----------------------------------------------------------------------<br>
// |使用方法,看上面的控制器调用<br>
// +----------------------------------------------------------------------<br>
<br>
public function gclist($field,$where='',$pagesize=30) {<br>
import("ORG.Util.Page");<br>
$count = $this->field('id')->where($where)->count();<br>
$P = new Page($count, $pagesize);<br>
<br>
$list=$this->field($field)->where($where)->order('bpath,id')->limit($P->firstRow . ',' . $P->listRows)->select();<br>
<br>
foreach ($list as $k => $v) {<br>
$list[$k]['count'] = count(explode('-', $v['bpath']));<br>
$list[$k]['tousername']=$this->where(array('id'=> $v['pid']))->getField('username');<br>
$str = '';<br>
if ($v['pid'] 0) {<br>
for ($i = 0; $i
$str .= ' ';<br>
}<br>
$str .= ' ';<br>
}<br>
$list[$k]['space'] = $str;<br>
}<br>
$P->setConfig('header', '篇');<br>
$P->setConfig('prev', "«");<br>
$P->setConfig('next', '»');<br>
$P->setConfig('first', '|«');<br>
$P->setConfig('last', '»|');<br>
$page = $P->show();<br>
$arr=array('page'=>$page,'list'=>$list);<br>
return $arr;<br>
}<br>
}<br>
?>
AD:真正免费,域名+虚机+企业邮箱=0元