留言显示页面:比上一个例子增加了分页和留言回复的功能
主要代码:
install/index.php:程序安装页面复制代码代码如下:php
MySQL主机名:MySQL用户名:MySQL密码:数据库名称:留言本每页记录数:管理员账号:管理员密码:留言本标题:php
";if($fp=fopen($config_file,"wb")){if(fwrite($fp,$config_strings)){if($fp2 = fopen($lockfile, 'w')){fwrite($fp2,'1212');fclose($fp2);}echo "安装成功!配置文件为:config.php,您可以手工修改该文件";echo "\n进入系统首页";}else{exit("文件写入失败");}fclose($fp);}}else{exit("不能执行CREATE TABLE语句:".$sql_create_table);}}else{exit("不能执行CREATE DATABASE语句:".$sql_create_database);}}else{exit("不能执行DROP DATABASE语句:".$sql_drop_database);}}else{exit("连接数据库失败,请检查MySQL主机名、用户名和密码");}}生成的config.php文件:复制代码代码如下:php
index.php:程序显示页面复制代码代码如下:php
php
$offset=($page-1)*$pagenum;$sql2="select * from messageboard order by id desc limit $offset,$pagenum";$result2=mysql_query($sql2,$conn);while($row=mysql_fetch_array($result2)){$offset++;echo "";echo "";echo $offset.".";echo base64_decode($row[title])." - ".base64_decode($row[author])." [".date("y年m月d日",$row[addtime])."] ";if(isset($_session["admin_name"]) && $_session["admin_name"]!=""){echo "删除 |";echo "回复";}echo "";echo "".base64_decode($row["content"])."";if($row["photo"]!="none"){echo "";}$sql3="select * from reply where msgid=$row[id] order by id desc";$result3=mysql_query($sql3,$conn);while($row3=mysql_fetch_array($result3)){echo "回复:".date("y年m月d日",$row3[addtime]);if(isset($_session["admin_name"]) && $_session["admin_name"]!=""){echo "删除";}echo "";echo "".base64_decode($row3[content])."";}}?>if($page_count>1){$prev_page=$page-1;$next_page=$page+1;if($pageecho "第一页 | ";}else{echo "第一页| ";}if($prev_pageecho "上一页 | ";}else{echo "上一页| ";}if($next_page>$page_count){echo "下一页 | ";}else{echo "下一页| ";}if($page>=$page_count){echo "最后一页";}else{echo "最后一页";}}?>php
php
退出管理php
登陆管理php
saveadd.php:保存留言复制代码代码如下:php
savereply.php:保存回复php
