本文所述留言板程序使用了無限級分類的原理,可以實現無限級留言與回復。留言列表gclist保留了留言層次空格,使留言--回復層次分明。分享給大家供大家參考。具體分析如下:
功能上,本程序可以實現無限級留言與回復,即對留言回復,對回復的留言回復。當然你也可以作有限制的控制,使其只對留言回復,關鍵是在模板代碼中去掉回復的留言中的“回復該留言”即可。歡迎去拍磚!
程序效果如下圖所示:
完整源碼點擊此處本站下載。
數據表:
復制代碼 代碼如下:-- ----------------------------
-- Table structure for `wb_guestbook`
-- ----------------------------
DROP TABLE IF EXISTS `wb_guestbook`;
CREATE TABLE `eway_guestbook` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) NOT NULL,
`email` varchar(50) NOT NULL,
`path` varchar(100) NOT NULL,
`username` varchar(30) NOT NULL,
`updatetime` int(10) NOT NULL,
`ip` varchar(15) NOT NULL,
`url` varchar(200) NOT NULL,
`inputtime` int(10) NOT NULL,
`content` text NOT NULL,
`verify` varchar(32) NOT NULL,
`isreply` tinyint(1) NOT NULL,
`status` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
代碼:
復制代碼 代碼如下:<?php
// +----------------------------------------------------------------------
// | WBlog
// +----------------------------------------------------------------------
// | Copyright (c) 2008 http://www.w3note.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: 網菠蘿果
// +----------------------------------------------------------------------
// $Id$
/**
+------------------------------------------------------------------------------
* @class 留言板控制器GuestbookAction.class.php
+------------------------------------------------------------------------------
*/
class GuestbookAction extends CommonAction {
public function index(){
$garr= D('Guestbook')->gclist("id,username,inputtime,pid,url,content,path,concat(path,'-',id) as bpath");
$this->assign('Gklist', $garr['list']);
$this->assign('page',$garr['page']);
$this->display();
}
// +----------------------------------------------------------------------
// | 添加留言
// +----------------------------------------------------------------------
public function add(){
$this->adddata('Guestbook');
}
// +----------------------------------------------------------------------
// | 網址跳轉。如在表單url添加網址的話,點擊會跳轉到相關網站
// +----------------------------------------------------------------------
public function tourl(){
$this->gettourl('Guestbook');
}
}
?>
<?php
// +----------------------------------------------------------------------
// | WBlog
// +----------------------------------------------------------------------
// | Copyright (c) 2008 http://www.w3note.com All rights reserved.
// | Author: 網菠蘿果
// +----------------------------------------------------------------------
// $Id$
/**
+------------------------------------------------------------------------------
* @function 留言板模型 類GuestbookModel.class.php
+------------------------------------------------------------------------------
*/
class GuestbookModel extends RelationModel{
// +----------------------------------------------------------------------
// | $_validate表單自動驗證
// +----------------------------------------------------------------------
protected $_validate = array(
array('email','require','請填寫您的郵箱!'),
array('email','email','郵箱格式錯誤!'),
);
// +----------------------------------------------------------------------
// | $_auto表單自動填充
// +----------------------------------------------------------------------
protected $_auto=array(
array('status','1'),
array('inputtime','time',1,'function'),
array('content','content',1,'callback'),
array('url','geturl',1,'callback'),
array ('inputtime','time',1,'function'),
array('path','path',3,'callback'),
array('username','getusername',3,'callback'),
);
// +----------------------------------------------------------------------
// | getusername()過濾用戶名
// +----------------------------------------------------------------------
public function getusername(){
if (isset ($_POST['username'])) {
if(trim($_POST['username'])=='網菠蘿果'){
return $data= ' ̄□ ̄';
}elseif(strlen($_POST['username']) >10){
return $data= msubstr($_POST['username'],0,5);
}else{
return $data= $_POST['username'];
}
}
}
// +----------------------------------------------------------------------
// | path()返回子類的path,父類的path的值為0
// +----------------------------------------------------------------------
public function path(){
$pid=isset($_POST['pid'])?(int)$_POST['pid']:0;
$id=$_POST['id'];
if($pid==0){
return 0;
}
$fat=$this->where(array('id' => $pid))->find();
$data=$fat['path'].'-'.$fat['id'];
return $data;
}
// +----------------------------------------------------------------------
// | content()過濾留言內容
// +----------------------------------------------------------------------
public function content() {
if (isset ($_POST['content']) && !empty ($_POST['content'])) {
$data =deleteHtmlTags($_POST['content']);
$data =safeHtml($data);
if (strlen($data) > 1000) {
$data = msubstr($data, 0, 500);
}
return $data;
}
}
// +----------------------------------------------------------------------
// | content()過濾URL
// +----------------------------------------------------------------------
public function geturl(){
if (isset ($_POST['url'])) {
$data = deleteHtmlTags($_POST['url']);
$data = safeHtml($data);
return $data=$data?$data:"";
}
}
// +----------------------------------------------------------------------
// |gclist($field,$where='',$pagesize=30)留言列表
// +----------------------------------------------------------------------
// |$field,字段
// +----------------------------------------------------------------------
// |$where查詢條件,默認為空
// +----------------------------------------------------------------------
// |$pagesize分頁記錄,默認為30
// +----------------------------------------------------------------------
// |使用方法,看上面的控制器調用
// +----------------------------------------------------------------------
public function gclist($field,$where='',$pagesize=30) {
import("ORG.Util.Page");
$count = $this->field('id')->where($where)->count();
$P = new Page($count, $pagesize);
$list=$this->field($field)->where($where)->order('bpath,id')->limit($P->firstRow . ',' . $P->listRows)->select();
foreach ($list as $k => $v) {
$list[$k]['count'] = count(explode('-', $v['bpath']));
$list[$k]['tousername']=$this->where(array('id'=> $v['pid']))->getField('username');
$str = '';
if ($v['pid'] <> 0) {
for ($i = 0; $i < $list[$k]['count'] * 2; $i++) {
$str .= ' ';
}
$str .= ' ';
}
$list[$k]['space'] = $str;
}
$P->setConfig('header', '篇');
$P->setConfig('prev', "«");
$P->setConfig('next', '»');
$P->setConfig('first', '|«');
$P->setConfig('last', '»|');
$page = $P->show();
$arr=array('page'=>$page,'list'=>$list);
return $arr;
}
}
?>
希望本文所述對大家的ThinkPHP框架程序設計有所幫助。
個人覺得建立一個專門的數據庫表就可以了,給每個回復一個id然後在每次有回復後將這個id對應的回復寫入表中就ok了!
回復內容表:
回復Id 回復內容
回復關聯表:
回復內容id 回復內容id
這樣就可以實現無限回復了!
所以,你想問什麼啊,,,,這個視頻我也看過,還不錯,