跟我一起学写php单文件留言本.doc

跟我一起学写php单文件留言本原创单文件留言板 gbk版看了视频教程之后写的留言版/基本涵盖了大部分php基础知识点，变量，常量，循环(if,switch)，变量作用域，session，函数，递归函数，安全处理，类，构造函数，静态变量，数据库连接、增加、查询、更新、删除html的知识点 隐藏表单 js表单验证 页面定时重定向 css悬浮实现功能：增加留言 留言删除 翻页 管理员修改密码 基于一个页面实现留言板的完整功能注释比较详细用户名：admin密码：123456k 留言板!-/表单验证function CheckForm()if(myform.username.value=)alert(请填写用户名);myform.username.focus();return false;if(myform.title.value=)alert(请填写标题);myform.title.focus();return false;if(myform.msg.value.length5)alert(留言需要大于5个字符);myform.msg.focus();return false;function CheckPassword()if(repassform.admin_pass.value.length6)alert(密码长度大于6);repassform.admin_pass.focus();return false;if(repassform.admin_pass.value != repassform.admin_pass2.value)alert(密码不相同);repassform.admin_pass2.focus();return false;/全选function checkAll(name)var el = document.getElementsByTagName(input);var len = el.length;for(var i=0; ilen; i+)if(eli.type=checkbox) & (=name)eli.checked = true;/取消全选function clearAll(name)var el = document.getElementsByTagName(input);var len = el.length;for(var i=0; ilen; i+)if(eli.type=checkbox) & (=name)eli.checked = false;/反选function disAll(name)var el = document.getElementsByTagName(input);var len = el.length;for(var i=0; i留言板首页 管理0 & Url != )timer=setInterval(dis(+time+), 1000);/显示时间timer=setTimeout(Redirect(+Url+),time * 1000); /跳转/-conn = $dbo;/php4 构造函数function base($db_host,$db_user,$db_pass,$db_name,$db_char=GBK)$this-_construct($db_host,$db_user,$db_pass,$db_name,$db_char);/增加留言function add(&$data)$username = $datausername?$datausername:匿名;$title = $datatitle;$msg = $datamsg;$sql = sprintf(insert into liuyan values(,%s,%s,%s,%s),$username,$title,$msg,time();mysql_query($sql,$this-conn);return mysql_insert_id($this-conn);/留言列表function lists($p=0)$c = 0;if($p0)$c=($p-1) * Per_page;$limit = limit .$c.,.Per_page;$where = 1;$r = ;$sql = sprintf(SELECT * from liuyan where %s $limit,$where.$limit);$query = mysql_query($sql,$this-conn);while($row = mysql_fetch_array($query)$r = $row;return $r;/统计分页function page()$sql = select count(id) from liuyan;$query = mysql_query($sql,$this-conn);$row = mysql_fetch_row($query);$pagetotals = $row0;$pagenums = ceil($row0/Per_page);return $page;/删除留言function del($id)$this-check();if(is_array($id)$ids .= implode(,$id);else$ids = $id;$sql = delete from liuyan where id in($ids);mysql_query($sql,$this-conn);return mysql_affected_rows($this-conn);/登录function login($admin_name,$admin_pass)$pass = md5($admin_name.$admin_pass.$admin_name);$sql=select * from admin where name=$admin_name and pass = $pass ;$query = mysql_query($sql,$this-conn);$row = mysql_fetch_array($query);if($rowid0)$_SESSION=$row;ShowMsg(登录成功，欢迎管理员.$_SESSIONname,3,?do=manage);elseShowMsg(登录失败.$_SESSIONname,3,?do=login);/密码修改function repass($admin_name,$admin_pass,$admin_id)$this-check();$pass = md5($admin_name.$admin_pass.$admin_name);$sql = UPDATE admin set name=$admin_name , pass=$pass where id=$admin_id;mysql_query($sql,$this-conn);return mysql_affected_rows($this-conn);/退出function logout()$this-check();session_destroy();/检查是否登录function check()if($_SESSIONname & $_SESSIONpass)/ShowMsg(登录成功，欢迎管理员.$_SESSIONname,3,?do=manage);elseShowMsg(请先登录.$_SESSIONname,3,?do=login);function getErr()return $this-err;function setErr()$this-err = mysql_error($this-conn);/安全处理 递归函数function Post_check($arr)if(is_array($arr)foreach($arr as $n=$k)$data$n = Post_check($k);elsereturn addslashes(trim($arr);return $data;/定时跳转function ShowMsg($msg,$time=0,$url=)echo ShowMsg($msg,$time,$url);exit;?add($data)1)echo 留言添加成功;elseecho $base-err;break;/删除留言case del:$data = Post_check($_POST);$affected_rows=$base-del($dataid);if($affected_rows0)echo 成功删除.$affected_rows.行.返回;elseecho 删除失败;break;/管理员修改密码case repass:$data = Post_check($_POST);$r = $base-repass($dataname,$dataadmin_pass,$dataid);if($r)echo 密码修改成功;elseecho 密码修改失败;break;/管理员退出登录case logout:$base-logout();ShowMsg(成功退出登录.$_SESSIONname,3,?do=);break;/管理员登录case login:if($_POSTadmin_name & $_POSTadmin_pass)$data = Post_check($_POST);$base-login($dataadmin_name,$dataadmin_pass);?管理员：  密  码：  check();$p = intval($_GETp);$lists = $base -lists($p);if(!$lists)echo 留言为空;else?input type = hidden id =id name = id value = /input type = hidden id =name name = name value = /管理员：  退出    新密码：      重复密码：      选择idnametitlemsgtimeinput type=checkbox name=id id=id value=/page();echo 共.$pagestotals.条 .$p./.$pagesnums.页;echo 首页;for($i=0;$i0)$link =$p-1;$link+=$i;if($link$pagesnums)break;if($link=$p)$class=class=current;echo .$link.;echo 末页;?lists($p)