留言版的显示提交与回复.doc

留言版的显示提交与回复indexControl.class.phpconut();$pageCount=$this-pageCount;if(empty($_GETPage)$_GETPage=1;if($_GETPagetemp=index;$gid=$_GETid;$replies=$model-showReplies($gid);$this-assign(replies,$replies);$list1=$model-getAll($pageCount);$this-assign(list1,$list1);include(/BLL/page.class.php);$pageList=page:showPage($recoredCount,$_GETPage);$this-assign(pageList,array($pageList);$this-display();public function issue()$this-temp=issue;$model=new indexModel;if(!empty($_POSTvalueSubmit)$model=new indexModel;$result=$model-insert();header(Content-type: text/html; charset=utf-8);if($result0)$msgmsg=留言成功!;$msgtype=success;$msgurl=index.php;echo json_encode($msg);else$msgmsg=留言失败!;$msgtype=false;$msgurl=index.php?action=index&op=issue;echo json_encode($msg);exit;else/echo $_POSTvalueSubmit;/echo a;/die();$this-display();/$temp();public function replies()$this-temp=replies;if(!empty($_POSTreplies)$model=new indexModel;$result=$model-replies();/echo aa;/die();echo ;print_r($result);/die();/header(Content-type: text/html; charset=utf-8);if($result0)/*$msgamsg=回复言成功!;$msgatype=success;$msgaurl=index.php;echo json_encode($msg);*/echo alert(留言成功!);location.href=index.php;else/*$msgamsg=回复失败!;$msgatype=false;$msgaurl=index.php?action=index&op=replies;echo json_encode($msga);exit;*/echo alert(留言失败!);location.href=index.php?acitn=index&op=replies;else/echo $_POSTvalueSubmit;/echo a;/die();/echo aa;$this-display();/$temp();function manageGuestBook()$model=new indexModel;/$this-gid=$_POSTgid;/setcookie(gid,);$recoredCount=$model-conut();$pageCount=$this-pageCount;if(empty($_GETPage)$_GETPage=1;if($_GETPagetemp=manageGuestBook;$list1=$model-getAll($pageCount);$this-assign(list1,$list1);include(/BLL/page.class.php);$pageList=page:showPage_adm($recoredCount,$_GETPage);$this-assign(pageList,array($pageList);$this-delete();$this-display();function delete()$model=new indexModel;$gid=$_COOKIEgid;$result=$model-delete($gid);echo .$result;return $result;?indexModel.class.phpdbConnect();$this-limit=10;/$sql=select * from guestbook order by gid desc limit .$pageCount.,.$this-limit;/$sql=select guestbook.gid,guestbook.uid,guestbook.title,guestbook.content,guestbook.posttime,user.userName from user inner join guestbook on guestbook.uid=user.uid order by posttime desc limit .$pageCount.,.$this-limit;/$sql=select replies.replies;/$sql_1=select replies.repliesContent,guestbook.gid,guestbook.uid,guestbook.title,guestbook.content,guestbook.posttime,user.userName from user inner join guestbook on guestbook.uid=user.uid inner join replies on guestbook.gid=replies.gid order by posttime desc limit .$pageCount.,.$this-limit;$sql=select guestbook.gid,guestbook.uid,guestbook.title,guestbook.content,guestbook.posttime,user.userName from user inner join guestbook on guestbook.uid=user.uid;/union select guestbook.gid,guestbook.uid,guestbook.title,guestbook.content,guestbook.posttime,replies.repliesContent from replies inner join guestbook on guestbook.gid=replies.gid order by posttime desc limit .$pageCount.,.$this-limit;$list = $this-db-get_all($sql);return $list;$this-dbClose();public function conut()/统计行数$this-dbConnect();$sql = select count(*) from guestbook;/$sql = select replies.repliesContent from replies inner join guestbook on guestbook.gid=replies.gid;$result = $this-db-get_one($sql);/print_r($result);/$reuult= Array ( 0 = 27 count(*) = 27 ) ? if(empty($result0) $result0 = 0;$this-dbClose();return $result0;public function insert()$this-dbConnect();$this-systemTime=date(Y-m-d H:i:s);$this-title=$_POSTtitle;$this-content=nl2br($_POSTcontent);$this-uid=$_COOKIEuid;$sql=insert into guestbook(uid,title,content,posttime) values(.$this-uid.,.$this-title.,.$this-content.,.$this-systemTime.);/echo $sql;/die();$insert=$this-db-insert($sql);return $insert;$this-dbClose();public function load_content_byUpperid($uid)$sql=select * from guestbook order by uid desc;/按提交的时间降序排序return $sql;public function show_content_groupbyPage()/分页显示留言$sql=select * from guestbook order by uid desc limit .($pageNo-1)*$pageSize.,.$pagesize;$result=mysql_query($sql);return $result;public function showReplies($gid)/$gid=$_COOKIEgid;/echo 当前 id =n.$_POSTid.a;$this-dbConnect();$sql=select * from replies where gid=.$gid;/gid=.$_GETid;echo $gid;die();/$sql=select replies.repliesContent from replies inner join guestbook on guestbook.gid=replies.gid;$result=$this-db-get_all($sql);return $result;public function showName()$this-dbConnect();$sql=select user.userName from user inner join guestbook on guestbook.uid=user.uid;$result=$this-db-get_all($sql);return $result;public function replies()$this-dbConnect();$this-uid=$_COOKIEuid;$this-systemTime=date(Y-m-d H:i:s);$this-replies=nl2br($_POSTreplies);echo $this-replies.;$this-gid=$_GETid;$sql1=select repliesContent from replies where gid=.$this-gid;echo $sql1.;$result=$this-db-get_one($sql1);$sql=insert into replies(uid,gid,repliesContent,repliestime) values(.$this-uid.,.$this-gid.,.$this-replies.,.$this-systemTime.);echo $