PHPMYSQL留言板源码(终极完整版).doc

数据库结构?：(库名：lyb) 表一: admin? 字段: id(int11?) name(varch?vr) passw?ord(varch?vr) 表二: lo 字段: id(int11?) usern?ame(varch?vr) sex(varch?vr) qq(varch?vr) email?(varch?vr) info(text) ip(varch?vr) submi?t_tim?e(datet?ime) 1 conn.php(连接数据库?文件) ?php mysql?_conn?ect(local?host,root,);//连接数据库? mysql?_sele?ct_db?(lyb);//选择数据库? ? 2 heade?r.php(公用头部文?件) 代码: !DOCTY?PE html PUBLI?C -//W3C//DTD XHTML? 1.0 Trans?ition?al//EN /TR/xhtml?1/DTD/xhtml?1-trans?ition?al.dtd html xmlns?=/1999/xhtml? head meta http-equiv?=Conte?nt-Type conte?nt=text/html; chars?et=gb231?2 / title?银子留言板? Versi?on 1.0/title? /head link href=css.css rel=style?sheet? type=text/css / body ?php sessi?on_st?art(); ? div id=head div id=head_?l ul lia href=index?.php偶要看留言?/a/li lia href=post.php偶要发表/a/li ?php //sessi?on_st?art();//DOFY同?学指出本句?前不能有任?何输出内容?，就此改正 if($_SESS?ION[key]==1){//如果获取的?SESSI?ON为1则?显示管理项? ? lia href=admin?exit.php退出管理/a/li ? } else { ? lia href=admin?.php偶要管理/a/li ?}? /ul /div div id=head_?r银子留言板? Versi?on 1.0/div /div 3 foote?r.php(公用底部文?件) 代码: ?php $count?erFil?e=conte?r.xml; funct?ion displ?ayCou?nter($count?erFil?e){ $fp = fopen?($count?erFil?e,rw); $num = fgets?($fp,5); $num += 1; print? div id=\foote?r\银子留言板? Versi?on 1.0 您是第 .$num. 位无聊的银?/div; exec(rm -rf $count?erFil?e); exec(echo $num $count?erFil?e); } if(!file_?exist?s($count?erFil?e)){ exec(echo 0 $count?erFil?e); } displ?ayCou?nter($count?erFil?e); ? /body /html 4 index?.php(首页) 代码: ?php requi?re_on?ce(conn.php); requi?re_on?ce(heade?r.php); sessi?on_st?art(); //分页代码开?始 $pages?ize = 10;//设置每页显?示条数 $rs = mysql?_quer?y(selec?t count?(*) from lo);//取得记录总?数，计算总页数?用 $myrow? = mysql?_fetc?h_arr?ay($rs); $numro?ws = $myrow?[0];//计算总记录? $pages? = intva?l($numro?ws/$pages?ize); if($numro?ws%$pages?ize)$pages?++;//设置页数 if(isset?($_GET[page])) { $page = intva?l($_GET[page]); } else { $page = 1;//设为第一页? } $offse?t = $pages?ize*($1);//计算记录偏?移量 //分页代码结?束 $sql = selec?