php留言本代码.doc

PHP留言本代码classpage{private$pagesize;//保存每页最多显示的记录数private$page;//保存当前的页数private$pagecount;//保存页数private$total;//保存总记录数private$conn;//保存数据库连接句柄publicfunction__construct($pagesize,$page){//构造函数,实现对类体中部分属性的初始化$this->pagesize=$pagesize;$this->page=$page;}publicfunctionlistInfo($code,$style){//定义listInfo()方法显示记录内容if($this->page==""||!is_numeric($this->page)){$this->page=1;}$this->conn=MySQL_connect("localhost","root","123456");mysql_select_db("air",$this->conn);mysql_query("setnamesgb2312");switch($code){case1://未被删除的留言记录$sql=mysql_query("selectcount(*)astotalfrommessage_listwheremessage_code!=-1orderbymessage_iddesclimit",$this->conn);break;case2://未回复留言记录$sql=mysql_query("selectcount(*)astotalfrommessage_listwheremessage_code=0orderbymessage_iddesclimit",$this->conn);break;case3://已回复留言记录$sql=mysql_query("selectcount(*)astotalfrommessage_listwheremessage_code=1orderbymessage_iddesclimit",$this->conn);break;}$info=mysql_fetch_array($sql);$this->total=$info[total];if($this->total==0)//总留言记录数若为0,显示暂无记录!{echo"<tablewidth=704height=20border=0align=centercellpadding=0cellspacing=0>"+"<tr>"+"<td><divalign=center>暂无留言!</div></td>"+"</tr>"+"</table>";}else{if(($this->total%$this->pagesize)==0){$this->pagecount=intval($this->total/$this->pagesize);}else{if($this->total<=$this->pagesize){$this->pagecount=1;}else{$this->pagecount=ceil($this->total/$this->pagesize);}}switch($code){case1://未被删除的留言记录$sql=mysql_query("select*frommessage_listwheremessage_code!=-1orderbymessage_iddesclimit".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);break;case2://未回复留言记录$sql=mysql_query("select*frommessage_listwheremessage_code=0orderbymessage_iddesclimit".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);break;case3://已回复留言记录$sql=mysql_query("select*frommessage_listwheremessage_code=1orderbymessage_iddesclimit".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);break;}?><tablewidth="500"border="0"align="center"cellpadding="0"cellspacing="1"><?phpwhile($inf