16.6.6 回帖功能講解 · 7天學會PHP

##回帖功能模板所在位置： `/theme/default/detail.html` PHP頁面 `detail.php` ##頁面功能說明 detail.php頁面可以展示、也可以回復，還能夠實現刪貼、高亮、精華、屏蔽等操作。 ####操作流程 1. 加載基礎 2. 判斷是否 3. 判斷get或者post傳入的類型是什么 4. 若是回復則走回復流程，若是刪除、精華、屏蔽則走對應的流程 5. 將回復內容和SQL語句準備完成，并寫入數據庫 6. 失敗報錯 7. 成功則提示成功，送金幣跳轉回原貼地址 ##回貼、刪除、置頂功能流程圖 ![](https://box.kancloud.cn/2015-10-23_5629a9b9d1600.png) ##整體代碼演示 ~~~ <?php /** * 帖子詳情 */ include './common/common.php'; //判斷帖子ID是否存在 if(empty($_REQUEST['id']) || !is_numeric($_REQUEST['id'])) { $msg = '禁止非法操作'; $url = $_SERVER['HTTP_REFERER']; $style = 'alert_error'; $toTime = 3000; include 'notice.php'; } $Id=$_REQUEST['id']; //保存帖子回復 if($_POST['replysubmit']) { //判斷用戶是否登錄 if(!$_COOKIE['uid']){ $notice='抱歉，您尚未登錄'; include 'close.php'; exit; } $tid = $Id; //跟帖時記錄貼子ID $authorid = $_COOKIE['uid']; //發布人ID $content = strMagic($_POST['message']); //內容 $addtime = time(); //發表時間 $addip = ip2long($_SERVER['REMOTE_ADDR']); //發布人IP $classId = $_POST['classid']; //類別ID $n='first, tid, authorid, content, addtime, addip, classid'; $v='0, '.$tid.', '.$authorid.', "'.$content.'", '.$addtime.', '.$addip.', '.$classId.''; $result = dbInsert('details', $n, $v); if(!$result) { $msg = '回復失敗，請聯系管理員'; $url = $_SERVER['HTTP_REFERER']; $style = 'alert_error'; $toTime = 3000; include 'notice.php'; exit; }else{ $money = REWARD_H; //回帖贈送積分 $result = dbUpdate('user', "grade=grade+{$money}", 'uid='.$_COOKIE['uid'].''); //更新帖子的回復數量[replycount] $result = dbUpdate('details', 'replycount=replycount+1', 'id='.$tid.''); //更新版塊表的回復數量[replycount] $result = dbUpdate('category', 'replycount=replycount+1', 'cid='.$classId.''); //header('location:detail.php?id='.$Id); $msg = '帖子回復成功'; $url = 'detail.php?id='.$Id; $style = 'alert_right'; $toTime = 3000; include 'notice.php'; $msg = '回帖贈送'; include 'layer.php'; exit; } } //點擊帖子時訪問次數加1 $result = dbUpdate('details', 'hits=hits+1', 'id='.$Id.' and isdel=0 and first=1'); if(!$result) { $msg = '您瀏覽的帖子不存在或已被刪除'; $url = $_SERVER['HTTP_REFERER']; $style = 'alert_error'; $toTime = 3000; include 'notice.php'; } //讀取帖子信息 $TiZi = dbSelect('details','*','id='.$Id.' and isdel=0 and first=1','',1); $authorid = $TiZi[0]['authorid']; //作者ID $Title = $TiZi[0]['title']; //標題 $Content = $TiZi[0]['content']; //內容 $Addtime = getFormatTime($TiZi[0]['addtime']); //發布時間 $classId = $TiZi[0]['classid']; //版塊ID $Replycount = $TiZi[0]['replycount']; //回復數量 $Hits = $TiZi[0]['hits']; //點擊數量 $Elite = $TiZi[0]['elite']; //精華 $Rate = $TiZi[0]['rate']; //所需積分數量 //讀取上一條 $top = dbSelect('details','id','id>'.$Id.' and isdel=0 and first=1','id desc',1); if($top) { $topid=$top[0]['id']; }else{ $topid=false; } //讀取下一條 $down = dbSelect('details','id','id<'.$Id.' and isdel=0 and first=1','id desc',1); if($down){ $downid = $down[0]['id']; }else{ $downid = false; } //讀取導航索引 $category = dbSelect('category','cid,classname,parentid,compere','parentid<>0 and cid='.$classId.'','',1); if($category) { $smallName = $category[0]['classname']; $smallId = $category[0]['cid']; $BanZhu = $category[0]['compere']; $parentCategory = dbSelect('category','cid,classname','cid='.$category[0]['parentid'].'','',1); if($parentCategory) { $bigName=$parentCategory[0]['classname']; $bigId=$parentCategory[0]['cid']; }else{ $msg = '非法操作'; $url = $_SERVER['HTTP_REFERER']; $style = 'alert_error'; $toTime = 3000; include 'notice.php'; exit; } }else{ $msg = '非法操作'; $url = $_SERVER['HTTP_REFERER']; $style = 'alert_error'; $toTime = 3000; include 'notice.php'; exit; } //讀取會員信息 $User = dbSelect('user','username,email,udertype,regtime,lasttime,picture,autograph,grade','uid='.$authorid.'','',1); if($User) { $U_sername = $User[0]['username']; $E_mail = $User[0]['email']; $U_dertype = $User[0]['udertype']; $R_egtime = formatTime($User[0]['regtime'],false); $L_asttime = formatTime($User[0]['lasttime'],false); $P_icture = $User[0]['picture']; $A_utograph = $User[0]['autograph']; $G_rade = $User[0]['grade']; } //該主題下的所有回復數量 $TZCount = dbFuncSelect('details','count(id)','tid='.$Id.' and isdel=0 and first=0'); $zCount = $TZCount['count(id)']; $linum = 10; $Lpage = empty($_GET['page'])?1:$_GET['page']; //循環帖子回復信息 $select = 't.id as id,t.isdisplay as isdisplay,t.authorid as authorid,t.content as content,t.addtime as addtime,t.addip as addip,t.isdel as isdel,t.elite as elite,u.username as username,u.email as email,u.udertype as udertype,u.regtime as regtime,u.lasttime as lasttime,u.picture as picture,u.autograph as autograph,u.grade as grade'; $HTiZi = dbDuoSelect('details as t','user as u',' on t.authorid=u.uid',null,null,$select,'t.tid='.$Id.' and t.isdel=0 and t.first=0','t.id asc', setLimit($linum)); $title = $Title.' - '.WEB_NAME; $ggg = 'iPhone 游戲軟件分享區'; //查找版主或管理員 $NBanZhu = explode(',',$BanZhu); if(in_array($_COOKIE['uid'], $NBanZhu)) { $GuanLi=true; }else{ if($_COOKIE['udertype']) { $GuanLi=true; } } //給帖子付款 if(!empty($_POST['paysubmit'])) { //判斷用戶是否登錄 if(!$_COOKIE['uid']) { $notice='抱歉，您尚未登錄'; include 'close.php'; exit; } foreach($_POST['oidarr'] as $key=>$val) { $nval=explode(',',$val); //將order表中的ispay更新為1 $res = dbUpdate('order', 'ispay=1', 'oid='.$key.''); //扣錢 $res = dbUpdate('user', 'grade=grade-'.$nval[1].'', 'uid='.$_COOKIE['uid'].''); //給作者加錢 $res = dbUpdate('user', 'grade=grade+'.$nval[1].'', 'uid='.$nval[0].''); } header('location:detail.php?id='.$Id); exit; } //刪除未購買的帖子 if(!empty($_POST['delsubmit'])) { //判斷用戶是否登錄 if(!$_COOKIE['uid']) { $notice='抱歉，您尚未登錄'; include 'close.php'; exit; } $arrOid = array_keys($_POST['oidarr']); $NarrOid = join(',',$arrOid); $result = dbDel('order', 'oid in('.$NarrOid.')'); header('location:detail.php?id='.$Id); exit; } //購買帖子,點擊及加入訂單表 if(!empty($_GET['pay'])) { //判斷用戶是否登錄 if(!$_COOKIE['uid']) { $notice='抱歉，您尚未登錄'; include 'close.php'; exit; } //查詢訂單表中是否有這個購買記錄 $select = 't.title as title,t.authorid as authorid,o.oid as oid,o.tid as tid,o.uid as uid,o.rate as rate'; $IsOrder = dbDuoSelect('order as o','details as t',' on o.tid=t.id',null,null,$select,'o.uid='.$_COOKIE['uid'].' and t.id='.$Id.'','o.oid asc',1); if(!$IsOrder) { //如果沒有購買記錄，加入訂單表 $Oresult = dbInsert('order', 'uid,tid,rate,addtime,ispay', $_COOKIE['uid'].','.$Id.','.$Rate.','.time().',0'); } //讀取這個用戶還沒有付款的記錄 $OrderList = dbDuoSelect('order as o','details as t',' on o.tid=t.id',null,null,$select,'o.uid='.$_COOKIE['uid'].' and o.ispay=0','o.oid asc'); $allpay = dbFuncSelect('order','sum(rate ) as zpay','uid='.$_COOKIE['uid'].' and ispay=0'); } //檢查當前瀏覽用戶是否已付費 $MyOrder = dbSelect('order','*','uid='.$_COOKIE['uid'].' and ispay=1 and tid='.$Id.'','oid asc',1); if($GuanLi){ //刪除，放入回收站 if(!empty($_GET['del'])){ $result = dbUpdate('details', "isdel=1", 'id='.$Id.''); header('location:index.php'); } //置頂 if(!empty($_GET['istop'])){ $result = dbUpdate('details', "istop=1", 'id='.$Id.''); header('location:detail.php?id='.$Id); } //高亮 if(!empty($_GET['style'])){ $result = dbUpdate('details', "style='red'", 'id='.$Id.''); header('location:detail.php?id='.$Id); } //精華 if(!empty($_GET['elite'])){ $result = dbUpdate('details', "elite=1", 'id='.$Id.''); header('location:detail.php?id='.$Id); } //刪除回帖，放入回收站 if(!empty($_GET['delht'])){ $result = dbUpdate('details', "isdel=1", 'id='.$_GET['hid'].''); header('location:detail.php?id='.$Id); } //回帖置頂 if(!empty($_GET['istopht'])){ $result = dbUpdate('details', "istop=1", 'id='.$_GET['hid'].''); header('location:detail.php?id='.$Id); } //回帖屏蔽 if(!empty($_GET['isdislpay'])){ $result = dbUpdate('details', "isdisplay=1", 'id='.$_GET['hid'].''); header('location:detail.php?id='.$Id); } } include template("detail.html"); ~~~