当前位置：首页 → 问答吧 → AJAX+PHP制作的简单留言板

AJAX+PHP制作的简单留言板

时间：2008-05-30

来源：互联网

一共涉及两个页面，前台ajax.php页面，后台ajaxadd.php添加信息入库页面。

ajax.php页面

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Ajax GuestBook</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<style type="text/css">

</style>
<script type="text/javascript">

</script>
</head>
<body>
<div id="msgList">
<?php
$db=mysql_connect('localhost','root','');
$select=mysql_select_db("ajax");
mysql_query("SET NAMES GBK");
$sql="select title,author,content,date from liuyan order by date desc";
$result=mysql_query($sql);
while($rs=mysql_fetch_array($result))
{

?>
<dl>
  <dt>标题：<?php echo $rs['title'];?></dt>
  <dd>作者：<?php echo $rs['author'];?>  日期：<?php echo $rs['date'];?></dd>
  <dd><?php echo $rs['content'];?></dd>
</dl>
<?php
}
?>
</div>
<div id="postBox">
<form name="theForm" method="post">
  <dl>
<dt>发表您的留言</dt>
<dd>标题：<input type="text" maxlength="150" size="45" name="title"/></dd>
<dd>作者：<input type="text" maxlength="50" size="45" name="author"/></dd>
<dd>内容：<textarea rows="10" cols="45" name="content"></textarea></dd>
<dd class="button">
<input type="button" value="提交"/>
<input type="reset" value="重填"/>
</dd>
  </dl>
</form>
</div>
</body>
</html>
----------------------------------------------------------------------------------------------------------------------
ajaxadd.php页面
<?php
function unescape($str)//定义unescape解码函数（解决js传递乱码问题）
{
$str = rawurldecode($str);
preg_match_all("/(?:%u.{4})|.+/",$str,$r);
$ar = $r[0];
foreach($ar as $k=>$v)
{
   if(substr($v,0,2) == "%u" && strlen($v) == 6)
   $ar[$k] = iconv("UCS-2","GB2312",pack("H4",substr($v,-4)));
}
return join("",$ar);
}

$db=mysql_connect('localhost','root','');
$select=mysql_select_db("ajax");
mysql_query("SET NAMES GBK");
$title=unescape($_POST[title]);//调用unescape函数
$author=unescape($_POST[author]);
$content=unescape($_POST[content]);
$date=date("Y-m-d H:i:s");
$sql="insert into liuyan(title,author,content,date) values('$title','$author','$content','$date')";
echo $date;
$result=mysql_query($sql);
mysql_free_result($result);
?>
-------------------------------------------------------------------------------------------------------------------
mysql数据库信息
-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2008 年 05 月 29 日 21:45
-- 服务器版本: 5.0.41
-- PHP 版本: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 数据库: `ajax`
--
-- --------------------------------------------------------
--
-- 表的结构 `liuyan`
--
CREATE TABLE `liuyan` (
  `id` int(12) NOT NULL auto_increment,
  `title` varchar(30) character set gbk NOT NULL,
  `author` varchar(50) character set gbk NOT NULL,
  `content` varchar(100) character set gbk NOT NULL,
  `date` varchar(30) character set gbk NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ;
--
-- 导出表中的数据 `liuyan`
--
INSERT INTO `liuyan` (`id`, `title`, `author`, `content`, `date`) VALUES
(42, '你好啊', 'function', 'AJAX好好玩啊', '2008-05-29 21:42:42'),
(43, '是么', '小蟑螂', '不是吧！', '2008-05-29 21:43:18');