简单的PHP留言板

时间:2008-05-08 09:41:20 来源: 作者:

简单的PHP留言板功能实现

发现自己好久没有更新网站了，不好意哦，中国教程网原创文章 http://www.cnjiaocheng.com

实现PHP留言板3个页面实现来源中国教程网

首先是建立数据

CREATE TABLE `qiu` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(20) NOT NULL,
`qq` int(11) NOT NULL,
`title` varchar(20) NOT NULL,
`content` varchar(700) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=74 ;

来源中国教程网

config.php页面中国教程网原创文章

http://www.cnjiaocheng.com

<?php 来源中国教程网

//连接数据库
$coon = mysql_connect("localhost","root","");
$db = mysql_select_db("qiutian"); 来源中国教程网

if(!$db)
echo "没有连上";

来源中国教程网

mysql_query("set names GBK"); //消除乱马，否则不能显示中文
?>

http://www.cnjiaocheng.com

来源中国教程网

gb.php页面中国教程网原创文章来源中国教程网

<?php
include "confiig.php"; //连接数据库

http://www.cnjiaocheng.com

//=================设置页面=========================
$pagesize = 10;          //每页的留言数目
$uid    = $_GET['id'];
if($uid=="")
     $uid = 1;

//==================分页部分=================
$sql = "select count(*) as total from qiu";     //éú3é2é ˉ    êyμ SQLó
$rst = mysql_query($sql) or die("无法执行SQL语句：$sql ！");   //2é ˉ    êy
$row = mysql_fetch_array($rst) or die("没有更多的记录！");   //è 3 ò ì
$rowcount = $row["total"];       //总共的留言条数来源中国教程网

//==================总共的页数=====================
$page = ($rowcount-($rowcount%$pagesize))/$pagesize+1;

http://www.cnjiaocheng.com

//查看总的有多少页
$up = $uid-1;
$down = $uid+1;
$last = $page; 来源中国教程网

$a = ($uid-1)*$pagesize;
$data = "select * from qiu order by id desc limit $a,$pagesize";
$return = mysql_query($data);

来源中国教程网

while($r = mysql_fetch_object($return)){
echo "".$r->id."、"."";
echo "Name: "."$r->name"."<br>";
echo "QQ : "."$r->qq"."       ";
echo "TITLE: "."$r->title"." <br>";
echo "CONTENT: "."$r->content"." ";
echo "<hr>";
}

http://www.cnjiaocheng.com

$title    = $_POST['title'];
$name     = $_POST['name'];
$content = $_POST['content'];
$qq       = $_POST['qq'];
$id       = mysql_insert_id();
$yc       = $_POST['yc'];
$jj    = $_POST['jj']; 来源中国教程网

if($jj==1)
echo "<script> window.location.reload(\"liuyan.php\");</script>"; //ìá á è ê± ￠D ò3
if($yc!=0){
if($content==""){
echo "<script> alert(\"内容不能为空\");</script>";
echo "<script> window.location.reload(\"liuyan.php\");</script>";
}
if($content!=""){
$charu = "insert into qiu (id,title,name,content,qq) values('".$id."','".$title."','".$name."','".$content."','".$qq."')";
$return = mysql_query($charu);
if($return){
echo "<script> alert(\"提交成功!\"); </script>";
echo "<script> window.location.reload(\"liuyan.php\"); </script>"; 来源中国教程网
}
}
} 来源中国教程网

?>
<html>
<head>
<meta http-equiv="Content-Type" content="text ml; charset=gb2312">
<title>留言</title>
   <script language="javascript">
   function tijiao(){
   var msg = confirm("你确定提交吗？");
   if(!msg) {
      document.qiutian.yc.value = 0;
      document.qiutian.jj.value = 1;
   }
   }
   </script>
   <style>
  form{margin:0px;}
  #tijiao{border:#000000 solid 1px; margin-bottom:20px; padding:20px;}
  #fenye{border:#000000 dashed 1px; margin-bottom:20px; width="50%";height:30px; line-height:30px; padding-top:2px; padding-left:5px;}
</style>
</head>
<body> http://www.cnjiaocheng.com
<div id="tijiao">
<form name= "qiutian" action = "liuyan.php" method="post">
姓名:<input type="text" size="15" id="name" name="name"><br>
QQ  :<input type="text" size="12" id="qq" name="qq"><br>
主题:<input type="text" size="30" id="title" name="title"><br>
<textarea name="content" id="content" cols="40" rows="5"></textarea>
<input type="hidden" value="1" id="yc" name="yc">
<input type="hidden" value="0" id="jj" name="jj">
<input type="submit" value=" 提交 " onClick="tijiao()">
</form>
</div> 来源中国教程网

来源中国教程网

</form>
</div>
</body>
</html>
来源中国教程网

来源中国教程网

index.php页面中国教程网原创文章

<?php
//连接数据库
mysql_connect("localhost","root","");
mysql_select_db("qiutian");
mysql_query("set names GBK");

来源中国教程网

//分页部分------------------------------------------
$pagesize = 10; //每页显示的数据数
$uid = $_GET['id'];
if($uid==""){
$uid=1;
} http://www.cnjiaocheng.com

//查看总共有多少条数据
$sql = "select count(*) as total from qiu"; //生成查询记录数的SQL语句
$rst = mysql_query($sql) or die("无法执行SQL语句：$sql ！"); //查询记录数
$row = mysql_fetch_array($rst) or die("没有更多的记录！"); //取出一条记录
$rowcount = $row["total"];//取出记录数来源中国教程网

//查看总的有多少页
$page = ($rowcount-($rowcount%$pagesize))/$pagesize+1; 来源中国教程网

//上一页、下一页、尾页
$up = $uid-1;
$down = $uid+1;
$last = $page; 来源中国教程网

http://www.cnjiaocheng.com

<html>
<head>
<title>留言</title>
<script>
  function tan(){
   var flag=confirm("你确定提交吗？")
   if(!flag){
    document.gb.yc.value="2";
   }
  }
</script>
<style>
  form{margin:0px;}
  #tijiao{border:#000000 solid 1px; margin-bottom:20px; padding:20px;}
  #fenye{border:#000000 dashed 1px; margin-bottom:20px; width="50%";height:30px; line-height:30px; padding-top:2px; padding-left:5px;}
</style>
</head>
<body>
<div id="tijiao">
<form name="gb" action="index.php" method="POST">
主题：<input type="text" size="15" id="title" name="title"><br> http://www.cnjiaocheng.com
QQ  ：<input type="text" size="15" id="qq" name="qq"><br>
Name：<input type="text" size="15" id="name" name="name"><br>
<textarea name="content" id="content" cols="40" rows="5">
</textarea>
<input type="hidden" value="1" name="yc" id="yc" />
<input type="submit" value="提交留言" onClick="tan()">
</form>
</div>
<div id="fenye">
<form name="yema" action="index.php" method="GET">
<a href="index.php">首页</a>
<?php
  if($up==0){echo "上一页";}
  else{echo "<a href=\"index.php?id=$up\">上一页</a> ";}

来源中国教程网

?>
<?php
  if($down>$last){echo "下一页";}
  else{echo "<a href=\"index.php?id=$down\">下一页</a> ";}
?>
<?php
  echo "<a href=\"index.php?id=$last\">尾页</a> ";
?>
跳转到<input type="text" id="id" name="id" size="3">页
<input type="submit" value=" GO ">
</form>
</div>
</body>
</html>
<?php

http://www.cnjiaocheng.com

/////////////////////////////////////////////////////
//显示页面的限制的数据条数
$a  = ($uid-1)*$pagesize;
$data = "select * from qiu order by id desc limit $a,$pagesize";
$return = mysql_query($data);
while($row = mysql_fetch_object($return)){
echo "".$row->id."、"." ";
echo "Name:"."$row->name"." ";
echo "title:"."$row->title"." ";
echo "qq:"."$row->qq"." ";
echo "content:"."$row->content"." ";
echo "<hr size=\"1\" color=\"#000000\" width=\"60%\" align=\"left\">";
}
$title = $_POST['title'];
$name = $_POST['name'];
$qq  = $_POST['qq'];
$content= $_POST['content'];
$id  = mysql_insert_id(); 来源中国教程网
$yc  = $_POST['yc'];
if($content!=""&&$yc==1){
//插入数据
$charu = "insert into qiu (id,title,name,content,qq) values('".$id."','".$title."','".$name."','".$content."','".$qq."')";
$return = mysql_query($charu);
echo "<script> window.location.reload(\"index.php\"); </script>";
}
?> 来源中国教程网

来源中国教程网

就这样一个简单的PHP留言版就实现了。

来源中国教程网

希望大家能支持中国教程网来源中国教程网

PHP学习群8920718

来源中国教程网

加入收藏打印本文我要推荐论坛讨论关闭此页

2008-05-08 09:41:20简单的PHP留言板
2008-05-08 09:38:55用PHP画各种图形
2008-05-08 09:36:54PHP图片制作1
2008-05-08 09:31:41用PHP制作处男证！
2008-05-08 09:24:52cnjiaocheng.com原创PHP验证码的实现
2008-04-21 16:59:23IIS+PHP+MySQL+Zend Optimizer+GD库+phpMyAdmin安装配置[完
2008-04-21 16:59:21结合AJAX进行PHP开发之入门1
2008-04-21 16:59:20PHP.MVC的模板标签系统(二)
2008-04-21 16:59:18apache+mysql+php+ssl服务器之完全安装攻略
2008-04-21 16:59:17结合AJAX进行PHP开发之入门3

中国教程网 www.cnjiaocheng.com

简单的PHP留言板

相关文章

推荐信息

24小时热门信息

最新信息