跟我一起学写php单文件留言本_PHP教程_编程技术--HTML5中文学习网

原创单文件留言板 gbk版

看了视频教程之后写的留言版

基本涵盖了大部分php基础知识点，变量，常量，循环(if,switch)，变量作用域，session，函数，递归函数，安全处理，类，构造函数，静态变量，数据库连接、增加、查询、更新、删除

html的知识点隐藏表单 js表单验证页面定时重定向 css悬浮

实现功能：

增加留言留言删除翻页管理员修改密码基于一个页面实现留言板的完整功能

注释比较详细

用户名：admin

密码：123456

<?php

session_start(); //启动会话

* 单文件留言本
* 请注明来自于 PHP100.com

//变量定义、赋值

$db_host = 'localhost:3306'; //设置数据库主机端口号一般为localhost:3360 通常不需修改

$db_user = 'root'; //设置数据库用户名

$db_pass = 'liujie'; //设置数据库密码

$db_name = 'test'; //设置数据库名称

$db_char = 'GBK'; //设置数据库字符集默认GBK 通常情况不需修改

//定义常量

define('Per_page',6); //定义每页记录数

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<style>

<!--

body{padding:0;margin:0;height:100%;overflow-y:auto;}

#contain{width:900px;margin:0 auto;}

#hd{width:400px;margin:50px auto;}

.forms{margin:60px auto;width:400px;color:green;font-size:20px;}

.list{width:900px;margin:20px auto;}

.current{color:green;font-size:20px;}

#showmsg {display:none; top:100px; left:300px; width:600px; height:300px;position:fixed;background:#CCF;padding:50px;opacity: 0.9;} /* IE并不认识fixed，而FF认识 */

* html #showmsg {position:absolute;} /* 这个只有IE认识 */

-->

</style>

<!--

//表单验证

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.length<5){

alert("留言需要大于5个字符");

myform.msg.focus();

return false;

}

function CheckPassword(){

if(repassform.admin_pass.value.length<6){

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; i<len; i++)

{

if((el[i].type=="checkbox") && (el[i].name==name))

{

el[i].checked = true;

}

//取消全选

function clearAll(name)

{

var el = document.getElementsByTagName('input');

var len = el.length;

for(var i=0; i<len; i++)

{

if((el[i].type=="checkbox") && (el[i].name==name))

{

el[i].checked = false;

}

//反选

function disAll(name)

{

var el = document.getElementsByTagName('input');

var len = el.length;

for(var i=0; i<len; i++)

{

if((el[i].type=="checkbox") && (el[i].name==name) && el[i].checked == true)

{

el[i].checked = false;

}else{

el[i].checked = true;

}

//-->

</script>

</head>

<body>

</div>

<!--

//跳转

function Redirect(Url){

window.location = Url;

}

var i = 0;

//显示倒计时

function dis(time){

document.getElementById("tip").innerHTML = "" + (time - i) + "秒后跳转";

i++;

}

//显示提示，定时跳转

function ShowMsg(msg,time,Url){

document.getElementById("showmsg").style.display= "block" ;

document.getElementById("info").innerHTML = msg;

if(time>0 && Url != ''){

timer=setInterval("dis('"+time+"')", 1000);//显示时间

timer=setTimeout("Redirect('"+Url+"')",time * 1000); //跳转

}

//-->

</script>

<?php

//实例化基础类

$base = new base($db_host,$db_user,$db_pass,$db_name,$db_char);

//定义基础类

class base{

private static $conn ;

var $err ;

//php5 构造函数初始化连接

function __construct($db_host,$db_user,$db_pass,$db_name,$db_char='GBK'){

/*连接数据库& 设置数据库字符集*/

@ $dbo = mysql_connect($db_host,$db_user,$db_pass) or die('请检查是否数据库密码是否正确。');

mysql_select_db($db_name,$dbo) or die ('数据库不存在，请确认是否正确安装');

mysql_query("set names '$db_char'",$dbo);

$this->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 = $data['username']?$data['username']:'匿名';

$title = $data['title'];

$msg = $data['msg'];

$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($p>0)$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);

$page['totals'] = $row[0];

$page['nums'] = ceil($row[0]/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($row['id']>0){

$_SESSION=$row;

ShowMsg('登录成功，欢迎管理员'.$_SESSION['name'],3,'?do=manage');

}else{

ShowMsg('登录失败'.$_SESSION['name'],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($_SESSION['name'] && $_SESSION['pass']){

//ShowMsg('登录成功，欢迎管理员'.$_SESSION['name'],3,'?do=manage');

}else{

ShowMsg('请先登录'.$_SESSION['name'],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);

}

}else{

return addslashes(trim($arr));

}

return $data;

}

//定时跳转

function ShowMsg($msg,$time=0,$url=''){

echo "<script>ShowMsg('$msg',$time,'$url');</script>";

exit;

}

<?php

//流程处理不同操作显示不同界面

$do = $_REQUEST['do'];

switch($do){

//添加留言

case 'add':

if($_POST['do'] == 'add'){

$data = Post_check($_POST);

if(@$base->add($data)>1){

echo '留言添加成功';

}else{

echo $base->err;

}

break;

//删除留言

case 'del':

$data = Post_check($_POST);

$affected_rows=$base->del($data['id']);

if($affected_rows>0){

echo '成功删除'.$affected_rows.'行'.'<a href="?do=manage">返回</a>';

}else{

echo '删除失败';

}

break;

//管理员修改密码

case 'repass':

$data = Post_check($_POST);

$r = $base->repass($data['name'],$data['admin_pass'],$data['id']);

if($r){

echo '密码修改成功';

}else{

echo '密码修改失败';

}

break;

//管理员退出登录

case 'logout':

$base->logout();

ShowMsg('成功退出登录'.$_SESSION['name'],3,'?do=');

break;

//管理员登录

case 'login':

if($_POST['admin_name'] && $_POST['admin_pass']){

$data = Post_check($_POST);

$base->login($data['admin_name'],$data['admin_pass']);

}

<table>

<tr>

<td>

</form>

</td></tr></table>

</div>

<?php

//管理留言

break;

case 'manage':

$base->check();

$p = intval($_GET['p']);

$lists = $base ->lists($p);

if(!$lists){

echo '留言为空';

}else{

<table>

</table>

</form>

</div>

<tr>

<td width="5%">选择</td><td width="5%">id</td><td width="15%">name</td><td width="15%">title</td><td width="40%">msg</td><td width="15%">time</td>

</tr>

<?php foreach($lists as $row){

<?php

}

<tr>

</tr>

</table>

</form>

<?PHP

}

//分页

$baseurl = '?do=manage&p=';

$pages = $base->page();

echo '共'.$pages['totals'].'条 '.$p.'/'.$pages['nums'].'页';

echo "<a style='margin:0 10px;' href='".$baseurl."0' target='_self'>首页</a>";

for($i=0;$i<3;$i++){

$class='';

$link = 1;

if($p-1>0)$link =$p-1;

$link+=$i;

if($link>$pages['nums'])break;

if($link==$p){

$class="class='current'";

}

echo "<a style='margin:0 10px;' $class href='".$baseurl.$link."' target='_self'>".$link."</a>";

}

echo "<a style='margin:0 10px;' href='".$baseurl.$pages[nums]."' target='_self'>末页</a>";

</div>

<?php

break;

<?php

//默认显示留言列表

default :

$p = intval($_GET['p']);

$lists = $base ->lists($p);

if(!$lists){

echo '留言为空';

}else{

<tr>

<td width="5%">id</td><td width="15%">name</td><td width="15%">title</td><td width="50%">msg</td><td width="15%">time</td>

</tr>

<?php foreach($lists as $row){

<?php

}

</table>

<?PHP

}

//分页部分

$pages = $base->page();

echo '共'.$pages['totals'].'条 '.$p.'/'.$pages['nums'].'页';

echo "<a style='margin:0 10px;' href='?p=0' target='_self'>首页</a>";

for($i=0;$i<3;$i++){

$class='';

$link = 1;

if($p-1>0)$link =$p-1;

$link+=$i;

if($link>$pages['nums'])break;

if($link==$p){

$class="class='current'";

}

echo "<a style='margin:0 10px;' $class href='?p=$link' target='_self'>".$link."</a>";

}

echo "<a style='margin:0 10px;' href='?p=$pages[nums]' target='_self'>末页</a>";

</div>

</form>

</div>

<?php

break;

}?>

</div>

</body>

</html>

来自 http://www.3oom.com/blog/15.html